Unit I : DBMS Introduction

1. Introduction to Databases and Database Architecture

1. What is a database?

2. Define schema.

3. What is a database state?

4. Describe with a neat diagram the database architecture.

5. Depict the Three Schema Architecture of a database by interpreting the different schema levels.

6. Bring out the difference between physical and logical data independence.

7. Depict the component module of the database system by elaborating on its working principle.

8. Explain the responsibilities of a Database Administrator (DBA).

2. Relational Model and Constraints

9. What are the core concepts of the Relational Model?

10. Discuss the following schema-based constraints with appropriate examples:
      a) Domain constraint
      b) Key constraint
      c) Entity integrity constraint

11. Discuss the relational constraints. Why is each considered important?

12. Analyze and discuss the different constraints available in SQL with proper syntax and examples.

3. Update Operations and Constraint Violations

13. Analyze and discuss in detail the different constraint violations that can occur during insert, delete, and update operations on a relational database system.

14. Exemplify the violation of various integrity constraints caused by each of the three types of update operations.