This document is an exam for a Database Management Systems course. It contains 5 questions with multiple parts each. Students must answer 2 parts from each question. The questions cover key topics related to databases, including defining common database terms, database models and languages, normalization, CAP theorem, NoSQL databases, key-value stores, distributed databases, graph databases, and CRUD operations. The level and expected learning outcome are provided for each part to guide students' answers.
This document is an exam for a Database Management Systems course. It contains 5 questions with multiple parts each. Students must answer 2 parts from each question. The questions cover key topics related to databases, including defining common database terms, database models and languages, normalization, CAP theorem, NoSQL databases, key-value stores, distributed databases, graph databases, and CRUD operations. The level and expected learning outcome are provided for each part to guide students' answers.
This document is an exam for a Database Management Systems course. It contains 5 questions with multiple parts each. Students must answer 2 parts from each question. The questions cover key topics related to databases, including defining common database terms, database models and languages, normalization, CAP theorem, NoSQL databases, key-value stores, distributed databases, graph databases, and CRUD operations. The level and expected learning outcome are provided for each part to guide students' answers.
This document is an exam for a Database Management Systems course. It contains 5 questions with multiple parts each. Students must answer 2 parts from each question. The questions cover key topics related to databases, including defining common database terms, database models and languages, normalization, CAP theorem, NoSQL databases, key-value stores, distributed databases, graph databases, and CRUD operations. The level and expected learning outcome are provided for each part to guide students' answers.
Regular/ Supplementary Summer Examination – 2023 Course: B. Tech. Branch : CSE(AI&DS)/AI&DS Semester : IV Subject Code & Name:BTAIC402 / Database Management System Max Marks: 60 Date: 15-07-23 Duration: 3 Hr. Instructions to the Students: 1. All the questions are compulsory. 2. The level of question/expected answer as per OBE or the Course Outcome (CO) on which the question is based is mentioned in ( ) in front of the question. 3. Use of non-programmable scientific calculators is allowed. 4. Assume suitable data wherever necessary and mention it clearly. (Level/CO) Marks Q. 1 Solve Any Two of the following. 12 A) Define Data, Information,database, Metadata, instance and schema. CO1 6 B) Difference between DBMS & RDBMS. CO1 6 C) Explain with diagram the three tier architecture CO1 6
Q.2 Solve Any Two of the following. 12
A) Explain Database languages with syntax and example. CO2 6 B) What is the need of Normalization? Write necessary conditions for CO2 6 1NF,2NF,3NF and BCNF C) Explain in detail the Data Model and its types. CO2 6
Q. 3 Solve Any Two of the following. 12
A) Explain CAP theorem with diagram. CO3 6 B) Explain NOSQL along with the types of NOSQL database. CO3 6 C) Write the differences between RDBMS and NOSQL CO3 6
Q.4 Solve Any Two of the following. 12
A) Describe the properties of Key-Value Store CO4 6 B) Describe distributed database system with suitable diagram CO4 6 C) Draw Cassandra Architecture with various components. Explain each CO4 6 component in brief.
Q. 5 Solve Any Two of the following. 12
A) Explain various graph representation techniques (data structures) with CO5 6 suitable examples B) Explain properties of graph database model. CO5 6 C) List and explain various CRUD operations of MongoDB with syntax CO4 6 and example. *** End *** The grid and the borders of the table will be hidden before final printing.