Module 1 -Database System Concepts and Architecture
1. Define Database. Explain the characteristics of a database with suitable examples.
2. Differentiate between File System and Database Management System.
3. Explain Data Abstraction with neat diagram.
4. Explain Data Independence with suitable examples.
5. Differentiate between Logical and Physical Data Independence.
6. Explain DBMS Architecture with neat diagram.
7. Explain Three-Schema Architecture with neat diagram.
8. Explain External, Conceptual and Internal Levels.
9. Explain the role and responsibilities of Database Administrator (DBA).
Module 2 -Entity Relationship (ER) Data Model
1. Explain Conceptual Modeling with suitable example.
2. Explain the Entity Relationship (ER) Model with neat diagram.
3. Explain Entity Types, Entity Sets, Attributes and Keys with examples.
4. Draw ER Diagram for
Hospital Management System
Library Management System
Student Management System
Banking System
Railway Reservation System
5. Convert an ER Diagram into Relational Schema.
6. Explain different Types of Attributes with examples.
7. Explain Keys in ER Model with examples.
8. Explain Entity Relationship Model with neat diagram.
9. Explain all components of ER Model.
10. Draw ER Diagram for Library Management System.
11. Draw ER Diagram for Hospital Management System.
12. Draw ER Diagram for Banking System.
13. Convert ER Diagram into Relational Schema.
14. Explain Strong Entity and Weak Entity with suitable examples.
15. Explain Entity Types with examples.
16. Explain Simple, Composite, Single-valued, Multi-valued and Derived Attributes.
17. Explain different types of keys with suitable examples.
18. Explain Candidate Key, Primary Key, Alternate Key, Super Key and Foreign Key.
19. Differentiate between Primary Key and Foreign Key.
20. Explain Generalization with a neat diagram and suitable example.
21. Differentiate between Generalization and Specialization with examples.
Module 3- Relational Model and Algebra
1. Explain the Relational Data Model with suitable example.
2. Explain different Relational Model Constraints.
3. Explain Domain, Entity Integrity and Referential Integrity Constraints.
4. Explain Relational Database Schema with example.
5. Explain the components of the Relational Model.
6. Explain Mapping of ER Model to Relational Model.
7. Explain mapping of Strong Entity, Weak Entity, Relationship and Multivalued Attributes.
8. Explain Relational Algebra with suitable example.
9. Explain Binary Relational Operations with examples.
10. Write Relational Algebra queries using Selection, Projection, Join and Division.
Module 4- Structured Query Language (SQL)
1. Explain DDL Commands with syntax and examples.
2. Explain CREATE, ALTER, DROP and TRUNCATE commands.
3. Write SQL queries using DDL commands.
4. Explain Aggregate Functions with examples.
5. Explain SQL Set Operations with suitable examples.
6. Explain handling of NULL Values in SQL.
7. Write SQL queries using GROUP BY and HAVING.
8. Explain DML Commands with syntax and examples.
9. Explain DCL Commands with examples.
10. Differentiate between DDL, DML and DCL.
11. Write SQL queries using INSERT, UPDATE and DELETE.
12. Explain Views with advantages and disadvantages.
13. Explain GROUP BY and HAVING clause with examples.
14. Explain Nested Queries with examples.
15. Explain Referential Integrity in SQL.
16. Explain JDBC Architecture with neat diagram.
17. Explain the steps to connect Java with Database using JDBC.
18. Explain different JDBC Drivers.
19. Explain JDBC API Components.
20. Explain Security and Authorization in SQL with suitable examples.
21. Explain GRANT and REVOKE commands with syntax and examples.
22. Explain different types of SQL privileges.
Module 5-Relational Database Design
1. Explain the Design Guidelines for Relational Schema.
2. Explain the problems caused by poor relational schema design.
3. Explain the goals of relational database design.
4. Explain Insertion, Deletion, and Update Anomalies with examples.
5. Explain Functional Dependency (FD) with suitable examples.
6. Explain different types of Functional Dependencies.
7. Explain Normalization with suitable example.
8. Explain the Need for Normalization
9. Explain First Normal Form (1NF) with suitable example.
10. Explain Second Normal Form (2NF) with suitable example.
11. Explain Partial Dependency with example.
12. Explain Third Normal Form (3NF) with suitable example.
13. Convert a relation from 2NF to 3NF.
14. Explain Transitive Dependency with example.
15. Explain BCNF with suitable example.
16. Differentiate between 3NF and BCNF.
Module 6-Storage and Indexing
1. Explain different File Organization Techniques.
2. Explain Hashing with suitable example.
3. Explain Primary, Secondary and Clustering Indexes.
4. Differentiate between Single-Level and Multilevel Indexes.
5. Explain B-Tree with neat diagram.
6. Explain B+ Tree with neat diagram.
7. Explain Composite (Multi-Key) Index with suitable example.