Database Management System

Define Database Management System.

What is Data Abstraction?

Define the term 'Data Independence'.

What is a Primary Key?

Define Referential Integrity.

What is the purpose of Normalization?

Define First Normal Form (1NF).

What is a Transaction?

Define Atomicity in ACID properties.

What is a Deadlock in DBMS?

Explain the three-level architecture of DBMS.

Describe the various components of an E-R diagram.

Explain the difference between specialization and generalization.

What are the various types of attributes in E-R model?

Explain the concept of Functional Dependency with an example.

Describe the properties of a transaction (ACID properties).

Explain the concept of Shadow Paging.

(a) Explain the E-R model in detail with a suitable example. (b) Explain the various symbols used in E-R diagrams.

Discuss the various types of database users and their responsibilities.

Explain the following with examples: (i) Tuple Relational Calculus (ii) Domain Relational Calculus.

What is Normalization? Explain 2NF, 3NF and BCNF with suitable examples.

Explain the concept of Concurrency Control. Describe the Two-Phase Locking (2PL) protocol in detail.