Scribd
Upload
175 views

BCS403 Model Set 1 Paper

This document is a model question paper for the Fourth Semester B.E Degree Examination in Database Management Systems for the academic year 2024-25. It consists of various modules with questions covering topics such as end users, DBMS advantages, relational model constraints, normalization, database transactions, and concurrency control. Students are required to answer five full questions, ensuring to choose at least one question from each module.

Uploaded by

premalataarya475
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
175 views

BCS403 Model Set 1 Paper

This document is a model question paper for the Fourth Semester B.E Degree Examination in Database Management Systems for the academic year 2024-25. It consists of various modules with questions covering topics such as end users, DBMS advantages, relational model constraints, normalization, database transactions, and concurrency control. Students are required to answer five full questions, ensuring to choose at least one question from each module.

Uploaded by

premalataarya475
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Model Question Paper- I with effect from 2022

Fourth Semester B.E Degree Examination 2024-25


Database Management Systems (BCS403)
TIME: 03 Hours Max.Marks:100
1. Note: Answer any FIVE full questions, choosing at least ONE question from each MODULE
2. M: Marks, L: Bloom’s level, C: Course outcomes.

Module - 1 M L C
Q.1 a Explain the types of end users with examples. 8 L2 CO1

b What are the advantages of using DBMS? Explain. 8 L2 CO1

c Describe the characteristics of database. 4 L2 CO1

OR
a Explain three schema architecture. Why mappings b/w schema levels are 8 L2 CO1
Q.2
required?
b Explain the different types of attributes in ER model. 8 L2 CO1

c Explain the following. 4 L2 CO1


1. Cardinality Ratio 2. Weal Entity

Module - 2
Q.3 a Explain the different Relational Model constraints. 6 L2 CO2

b Demonstrate the concepts of Generalization & Specialization with examples. 6 L2 CO2

c Explain Entity Integrity Constraint & Referential Integrity Constraints? Why 8 L2 CO2
each of these is important in a database.

OR
Model Question Paper- I with effect from 2022
Q.4 a Consider the Sailors-Boats-Reserves DB described 10 L3 CO2
s (sid, sname, rating, age)
b (bid, bname, color)
r (sid, bid, date)
Write each of the following queries in SQL.
1. Find the colors of boats reserved by Alber.
2. Find all sailor ids of sailors who have a rating of at least 8 or reserved
boat 103.
3. Find the names of sailors who have not reserved a boat whose name
contains the string “storm”. Order the names in ascending order.
4. Find the sailor ids of sailors with age over 20 who have not reserved
a boat whose name includes the string “thunder”.
b Discuss the Equijoin & Natural Join with suitable example. 6 L3 CO2

c Explain the relational algebra operation for set theory with examples. 4 L2 CO2

Module - 3
Q.5 a Explain the Cursor & its properties in embedded SQL with an example. 6 L2 CO3

b What is a Normalization? Explain the 1NF, 2NF & 3NF with examples. 10 L2 CO4

c Explain informal design guidelines for relational schema design. 4 L2 CO3


OR
a What is Functional Dependency? Write algorithm to find minimal cover for 10 L2 CO4
Q.6 set of Functional Dependency. Construct the minimal cover m for set of
functional dependency. E={ BA, DA, ABD}
b Explain the types of update anomalies in SQL with an example. 10 L4 CO3

Module - 4
Q.7 a Demonstrate the Database Transaction with transaction diagram. 10 L2 CO4

b Demonstrate working of Assertion & Triggers in SQL? Explain with an 10 L3 CO3


example.
OR

Q.8 a Demonstrate the System Log in database transaction. 6 L2 CO4

b Demonstrate the ACID properties of database transaction. 4 L2 CO4

c Explain stored procedure language in SQL with an example. 10 L2 CO3


Model Question Paper- I with effect from 2022

Module - 5
Q.9 a Demonstrate the Two phase locking protocol used for concurrency control. 8 L3 CO5

b Demonstrate the Concurrency control based on Timestamp ordering. 4 L2 CO5

c. Why Concurrency control is needed? Demonstrate with an example. 8 L3 CO5

OR

Q.10 a What is NOSQL? Explain the CAP theorem. 6 L2 CO5

b What are document based NOSQL systems? Explain basic operations 8 L2 CO5
CRUD in MongoDB.
c What is NOSQL Graph database? Explain Neo4j. 6 L2 CO5

You might also like