Database Management System (DBMS) — Winter 2023

Discuss Relational Model Hierarchical Model & Network Model in Detail.

What are the characteristics of database management system? Explain in detail.

Write a short note on Codd’s 12 Rules.

What is SQL? Explain various types of languages available in SQL.

Explain Components of DBMS in detail.

Discuss different types of relationships with suitable E-Rdiagram and example.

Explain various integrity constraints of DBMS.

Differentiate between DDL and DML.

Discuss physical and logical database models in detail.

What is data independence? Discuss its types.

Explain ACID properties of transaction.

Define Normalization. Explain 1st NF, 2nd NF, 3NF, BCNF with example.

Discuss three schema architecture in details. Why it is used?

Explain GRANT and REVOKE commands in detail.

Write a note on Contemporary database trends and application.

Explain the functions of SQL- ROLLBACK, COMMIT, SAVEPOINT.

Explain the most popular RDBMS in detail.