Database Management System

Define Weak Entity Set.

What is a Candidate Key?

Explain the term 'Schema'.

What is DML?

Define Lossless Join Decomposition.

What is the role of a Database Administrator (DBA)?

Define BCNF.

What is Log-based Recovery?

Explain 'Checkpoints' in recovery.

Define 'Serializability'.

Explain the differences between File System and DBMS.

Discuss the mapping constraints in E-R model.

Explain the Relational Algebra operations: Selection and Projection.

Describe the concept of Multi-valued dependency.

Explain the concept of Deadlock detection and recovery.

Discuss the 4NF and 5NF in brief.

Explain the concept of Recovery with Concurrent Transactions.

Explain the relational model concepts. Discuss the various types of integrity constraints.

What is an EER (Extended Entity-Relationship) model? Explain generalization, specialization, and aggregation.

Explain the various Normal forms up to BCNF with examples.

Discuss the concept of Query Processing and Optimization.

Explain the Lock-based protocols for concurrency control.