Do as Directed: 1. Define: Primary Key 2. Define: Candidate Key 3. What is Super class? 4. What is Denormalization? 5. Define: Integrity Constraints. 6. What is BCNF? 7. What is Generalization?
[7 marks]Describe the main components of a DBMS
[7 marks]What are the different types of database languages, including DDL and DML? Discuss the role of each language in a DBMS
[7 marks]Define data abstraction and explain its significance in database design. Differentiate between logical and physical data independence
[7 marks]Explain DBMS Advantages in detail.
[7 marks]Explain :1) Conceptual Data Model 2) Logical Data Model 3) Physical Data Model
[7 marks]Write a short note on the types of database users.
[7 marks]Explain the Three Schema Architecture in detail and discuss why it is used?
[7 marks]Explain Components of ER-Model in detail
[7 marks]Describe the Hierarchical model, Network model, and Relational model used in organizing databases
[7 marks]1) Explain the concept of functional dependencies 2) Explain strong and weak entities in Entity-Relationship
[7 marks]Discuss the various integrity constraints in a DBMS?
[7 marks]What is Normalization? explain 1NF, 2NF and 3NF with example.
[7 marks]Define views and discuss the benefits of creating views in a DBMS? provide a suitable example
[7 marks]Discuss Codd's 12 Rules in detail.
[7 marks]Explain Functions in SQL: ROLLBACK, COMMIT, SAVEPOINT
[7 marks]Define SQL and Explain various features offered by SQL
[7 marks]