CS6302 Database Management Systems1
VALLIAMMAI ENGINEERING COLLEGE
III SEMESTER - B.E – COMPUTER SCIENCE AND ENGINEERING
QUESTION BANK - CS6302 DATABASE MANAGEMENT SYSTEMS
UNIT I
1. What are the disadvantages of file processing system?
2. Explain the basic structure of a relational database with an example.
3. What do you mean by weak entity set?
4. Give example for one to one and one to many relationships.
5. What is the need of normalization?
6. Write a note on functional dependencies.
7. Who is a DBA? What are the responsibilities of a DBA?
8. What is a data model? List the types of data models used.
9. What are the components of storage manager?
10. What is a data dictionary?
11. What is an entity relationship model?
12. Define single valued and multi valued attributes.
13. What are stored, composite and derived attributes?
14. What is meant by the degree of relationship set?
15. Define weak and strong entity sets?
16. Explain the two type’s o f participation constraint.
17. Define the two levels of data independence.
18. Write down any two major responsibilities of a database administrator.
19. Define irreducible sets of dependencies.
20. Define the normal forms.
16/10/8 Marks Questions
1. With a neat diagram, explain the structure of a DBMS.
2. What is data integrity? Explain the types of integrity constraints.
3. Explain 1NF, 2NF, 3NF and BCNF with suitable example.
4. What are the pitfalls in relational database design? With a suitable example, explain the role of functional dependency in the process of normalization.
5. Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. State any assumptions you make.
6. What is aggregation in an ER model? Develop an ER diagram using aggregation that captures the following information :
Employees work for projects. An employee working for a particular project uses various machinery. A unnecessary attributes. State any options you make.
III SEMESTER - B.E – COMPUTER SCIENCE AND ENGINEERING
QUESTION BANK - CS6302 DATABASE MANAGEMENT SYSTEMS
UNIT I
1. What are the disadvantages of file processing system?
2. Explain the basic structure of a relational database with an example.
3. What do you mean by weak entity set?
4. Give example for one to one and one to many relationships.
5. What is the need of normalization?
6. Write a note on functional dependencies.
7. Who is a DBA? What are the responsibilities of a DBA?
8. What is a data model? List the types of data models used.
9. What are the components of storage manager?
10. What is a data dictionary?
11. What is an entity relationship model?
12. Define single valued and multi valued attributes.
13. What are stored, composite and derived attributes?
14. What is meant by the degree of relationship set?
15. Define weak and strong entity sets?
16. Explain the two type’s o f participation constraint.
17. Define the two levels of data independence.
18. Write down any two major responsibilities of a database administrator.
19. Define irreducible sets of dependencies.
20. Define the normal forms.
16/10/8 Marks Questions
1. With a neat diagram, explain the structure of a DBMS.
2. What is data integrity? Explain the types of integrity constraints.
3. Explain 1NF, 2NF, 3NF and BCNF with suitable example.
4. What are the pitfalls in relational database design? With a suitable example, explain the role of functional dependency in the process of normalization.
5. Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. State any assumptions you make.
6. What is aggregation in an ER model? Develop an ER diagram using aggregation that captures the following information :
Employees work for projects. An employee working for a particular project uses various machinery. A unnecessary attributes. State any options you make.