Department of Computer Science
Academic Year 2025-26
[Link]. (Computer Science) Sem-III
Subject- Database Management System-I
DBMS Question Bank
Chapter 1: Introduction to DBMS
1 Mark Questions
1. Define data.
2. What is a database?
3. Define DBMS.
4. Draw a simple diagram of DBMS architecture.
5. What is metadata?
6. List two advantages of DBMS.
7. What is data independence?
8. Define data abstraction.
9. What are database users?
10.What is the difference between data and information?
2 Marks Questions
1. Explain the difference between a file system and DBMS.
2. Write short notes on levels of abstraction in DBMS.
3. Explain any two disadvantages of DBMS.
4. Describe the role of database users.
5. Compare physical and logical data independence.
3 Marks Questions
1. Explain the three levels of architecture of DBMS with a neat diagram.
2. Discuss advantages and disadvantages of DBMS.
3. Explain various types of DBMS users.
4. Describe how DBMS overcomes limitations of file-based systems.
4 Marks Questions
1. Explain DBMS architecture in detail with a diagram.
2. Compare file system vs DBMS (at least five points).
3. Explain levels of abstraction and data independence with example.
Short Notes (2.5 Marks)
● Data abstraction
● Advantages of DBMS
● Database users
● DBMS architecture
Chapter 2: Conceptual Design
1 Mark Questions
1. What is an entity?
2. Define attribute.
3. What is a relationship set?
4. Draw a symbol for weak entity set.
5. Define ER model.
6. What is specialization?
7. Define generalization.
8. What is aggregation?
9. Define domain constraint.
10.What is a foreign key?
2 Marks Questions
1. Explain types of attributes in ER model.
2. Define and give example of entity and relationship.
3. Explain domain, entity integrity and referential integrity constraints.
4. Write short note on hierarchical data model.
5. Explain the concept of aggregation with an example diagram.
3 Marks Questions
1. Explain E-R model components with suitable example.
2. Explain specialization and generalization with diagrams.
3. Discuss constraints in relational databases.
4. Explain steps in database design process.
5. Compare ER model and Relational model.
4 Marks Questions
1. Explain ER diagram for a College Management System.
2. Explain extended ER features with diagrams (specialization, generalization, aggregation).
3. Describe and compare various data models (ER, Relational, Hierarchical, Network).
4. Draw and explain an ER diagram for Library Management System.
Short Notes (2.5 Marks)
● Specialization and Generalization
● Aggregation
● Constraints in DBMS
● ER Model symbols
Chapter 3: SQL
1 Mark Questions
1. Define SQL.
2. What is a query?
3. What are DDL commands?
4. Define a view.
5. Give an example of aggregate function.
6. What is a join?
7. What is a nested query?
8. Define DCL commands.
9. Write one example of a set operation in SQL.
10.What is a Cartesian product?
2 Marks Questions
1. Write any four DDL commands with examples.
2. Differentiate between DDL and DML.
3. Write syntax of CREATE TABLE and INSERT INTO.
4. Explain aggregate functions in SQL.
5. Explain the difference between INNER JOIN and OUTER JOIN.
3 Marks Questions
1. Explain various types of joins with example queries.
2. Describe SQL command categories with examples.
3. Write and explain a nested SQL query.
4. Explain SQL set operations with examples.
5. What are views? How are they created and used?
4 Marks Questions
1. Write SQL queries for the following:
a) Display all employees working in ‘IT’ department.
b) Find the average salary of employees.
c) List employees whose salary is greater than 50000.
2. Explain all SQL command categories (DDL, DML, DCL, TCL) with examples.
3. Write SQL queries using aggregate functions and group by clause.
Short Notes (2.5 Marks)
● Aggregate functions in SQL
● Types of joins
● Views
● Nested queries
Chapter 4: Relational Database Design
1 Mark Questions
1. Define functional dependency.
2. What is normalization?
3. What is a primary key?
4. Define candidate key.
5. Define super key.
6. What is BCNF?
7. What is decomposition?
8. Define Armstrong’s axioms.
9. What is lossless join decomposition?
10.Define dependency preserving decomposition.
2 Marks Questions
1. Explain desirable properties of decomposition.
2. Write short note on closure of attribute set.
3. Define and differentiate between candidate key and super key.
4. Explain 1NF with example.
5. Explain functional dependency with example.
3 Marks Questions
1. Explain Armstrong’s axioms in detail.
2. Explain steps to find closure of F (F+).
3. Explain 2NF and 3NF with examples.
4. Differentiate between lossy and lossless decomposition.
5. Explain concept of normalization with an example.
4 Marks Questions
1. Explain all types of normal forms (1NF, 2NF, 3NF, BCNF) with examples.
2. Discuss desirable properties of decomposition in detail.
3. Explain concept of keys with examples (primary, candidate, super, alternate, composite).
4. Describe normalization process with a suitable example table.
Short Notes (2.5 Marks)
● Functional dependency
● Normalization
● Armstrong’s axioms
● Lossless decomposition