313302 DMS IMP Questions for MSBTE Winter 2024 Exam

Welcome to practicalkida, in this blog post, we share 313302 Database Management System 313302 DMS IMP Questions for the MSBTE Winter 2024 Exam.

MSBTE computer third semester K scheme students must try to solve the important questions given below.

313302 DMS IMP Questions for MSBTE Winter 2024

• Chapter no: 1 Introduction to Database System

• 2 Marks Questions

1. List any four applications of DBMS.
2. State the four database users.
3. Define Schema and Instance.
4. Define data independence and list its types.

• 4 Marks Questions

1. Explain any four advantages of DBMS over file processing systems.
2. Explain Data Abstraction with a neat diagram.
3. Describe any four Codds rules.
4. Draw and explain the overall structure of DBMS.
5. Explain the tier and three-tier architecture of DBMS.
6. Explain the Hierarchical data model with an example.
7. Distinguish between Relational and Network Model.

• Chapter no: 2 Relational data model
• 2 Marks Questions

1. Define Tuple and Attribute.
2. Define Primary Key and Foreign Key.
3. List any four symbols used in the ER diagram.
4. Define normalization.

• 4 Marks Questions

1. Describe the domain integrity constraint using syntax and an example.
2. Describe the referential integrity constraint using syntax and an example.
3. Explain different types of attributes used to draw the ER diagram
4. Differentiate between strong and weak entity sets.
5. Draw an ER diagram for the Banking system.
6. Draw an ER diagram for the Library Management System.
7. Explain 2NF with an example.

Conclusion

This blog post provides all important questions for Database Management Systems. consider sharing this post with your friends.

MSBTE Winter 2024 IMP