Categories
question bank

CS6302 Database Management Systems Question Bank Regulation 2013 Anna University

CS6302 Database Management Systems Question Bank

CS6302 Database Management Systems Question Bank Regulation 2013 Anna University free download. Database Management Systems CS6302 Question Bank pdf free download.

Sample CS6302 Database Management Systems Question Bank:

Part A 2 Marks CS6302 Database Management Systems Question Bank

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. (CS6302 Database Management Systems Question Bank)

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? (CS6302 Database Management Systems Question Bank)

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.

Part B 16 Marks CS6302 Database Management Systems Question Bank

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.

Subject Name Database Management Systems
Subject code CS6302
Regulation 2013

CS6302 Database Management Systems Question Bank Click here to download

CS6302 Database Management Systems Syllabus


CS6302 Database Management Systems Notes


CS6302 Database Management Systems Important Questions


 

 

Leave a Reply

Your email address will not be published. Required fields are marked *