DBMS Assignment (With Answer Space)
Unit 1: Introduction to DBMS
1. Define DBMS. Explain its advantages over file systems.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
2. Differentiate between DBMS and RDBMS with examples.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
3. Explain the three levels of database architecture.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
4. What is data independence? Why is it important?
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
5. Describe the roles of a Database Administrator (DBA).
__________________________________________________________________
__________________________________________________________________
DBMS Assignment (With Answer Space)
__________________________________________________________________
Unit 2: Data Models and ER Diagrams
6. What are different types of data models in DBMS? Explain each briefly.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
7. Draw an ER diagram for a library management system. Convert it to relational schema.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
8. Define entity, attribute, relationship, and cardinality with examples.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
9. Explain the concept of generalization, specialization, and aggregation in ER modeling.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
Unit 3: Relational Model & Algebra
10. Define relational model. What are the key constraints in relational databases?
DBMS Assignment (With Answer Space)
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
11. Write relational algebra expressions for the following operations: Selection, Projection, Join, Union
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
12. Explain candidate key, primary key, foreign key, and super key with examples.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
Unit 4: SQL (Structured Query Language)
13. Create a table in SQL for an employee database. Insert at least 5 records.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
14. Write SQL queries for:
- Fetching all employees with salary > 50,000.
- Updating the department of an employee.
- Deleting employees from a specific department.
- Performing a join between two tables.
DBMS Assignment (With Answer Space)
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
15. Explain the use of GROUP BY, ORDER BY, HAVING with examples.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
Unit 5: Functional Dependency & Normalization
16. Define functional dependency. Give real-life examples.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
17. Explain 1NF, 2NF, 3NF, and BCNF with examples.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
18. Normalize the following relation into 3NF:
Student(RollNo, Name, Course, Instructor, Instructor_Phone)
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
DBMS Assignment (With Answer Space)
Unit 6: Transactions & Concurrency
19. What are ACID properties? Explain each with an example.
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
20. Define concurrency control. How is deadlock handled in DBMS?
__________________________________________________________________
__________________________________________________________________
__________________________________________________________________
