Instructions: Attempt all the sections.
Section -A
(Very short Answer Type Questions)
Note: Attempt all questions of this section in about 50 words. 4 × 3= 12
1. Answer the following questions.
a) Distinguish terms primary key and super key.
b) Describe Outer Join
c) Give the limitation of ER model and how do you overcome this?
Section -B
(Short Answer Type Questions)
Note: Attempt all questions of this section in about 150 words. 5 × 2= 10
2. Consider the following relation:
R [A, B, C, D, E]
The primary key of the relation is AB. The following functional dependencies hold by Relation R:
A C
B D AB E
Define the normal form for the above relation R. List the various
Super Key(s) for Relation R.
3. Explain in detail ACID properties in transaction with example. Illustrate the states of transaction.
Section -C
(Long Answer Type Questions)
Note: Attempt all questions of this section in about 200 words. 8 × 1= 8
4. Consider the given schema:
Emp(Eid, Ename, Sal, City Works(Eid, Cid)
Company(Cid, Cname, City)
Write SQL queries for the given database:
i. Find the highest paid employee.
ii. Find how many employees are working for the company ‘XYZ Cooperation”.
iii. Modify the database so that “Suraj” now lives in “Ayodhya”.
iv. Find the total number of employees of each company.
Instructions: Attempt all the sections.
Section -A
(Very short Answer Type Questions)
Note: Attempt all questions of this section in about 50 words. 4 × 3= 12
1. Answer the following questions.
a) With an example explain referential integrity.
b) With an example explain a weak entity in an ER diagram.
c) Describe Natural Join
Section -B
(Short Answer Type Questions)
Note: Attempt all questions of this section in about 150 words. 5 × 2= 10
2. What are the main differences between file processing system and DBMS
3. Consider the following relation:
R [A, B, C, D, E]
The primary key of the relation is AB. The following functional dependencies hold by Relation R:
A C
B D
AB E
Define the normal form for the above relation R.
List the various Super Key(s) for Relation R.
Section -C
(Long Answer Type Questions)
Note: Attempt all questions of this section in about 200 words. 8× 1= 8
4. Explain timestamp based protocol and how timestamp-ordering protocol guarantees
serializability. Check whether the given schedule S is conflict serializable or not?
S : R1(A) , R2(A) , R1(B) , R2(B) , R3(B) , W1(A) , W2(B)
Instructions: Attempt all the sections.
Section -A
(Very short Answer Type Questions)
Note: Attempt all questions of this section in about 50 words. 4 × 3= 12
1. Answer the following questions.
a) Explain two desirable properties of decomposition.
b) Define Functional Dependency.
c) Define Data manipulation language
Section -B
(Short Answer Type Questions)
Note: Attempt all questions of this section in about 150 words. 5 × 1= 10
2. Explain different types of Database users and the responsibilities of the DBA?
3. Explain the three levels of abstraction in DBMS.
Section -C
(Long Answer Type Questions)
Note: Attempt all questions of this section in about 200 words. 8 × 1= 8
4. With example explain about Selection, Projection, Rename, Division, Cartesian product,
Natural Join and Outer Join operations in relational algebra?
Instructions: Attempt all the sections.
Section -A
(Very short Answer Type Questions)
Note: Attempt all questions of this section in about 50 words. 4 × 3= 12
1. Answer the following questions.
a) Define Data definition language
b) Define Instances and schemas of database?
c) Define CROSS PRODUCT operation in Relational algebra?
Section -B
(Short Answer Type Questions)
Note: Attempt all questions of this section in about 150 words. 5 × 2 = 10
2. What are different types of normalization? Also explain the difference between BCNF and 3NF.
3. Explain in detail ACID properties in transaction with example. Illustrate the states of transaction.
Section -C
(Long Answer Type Questions)
Note: Attempt all questions of this section in about 200 words.. 8 × 1= 8
4. Consider the following schema:
Suppliers (sid : integer, sname : string, address : string)
Parts (pid : integer, pname : string, color : string)
Catalog (sid : integer, pid : integer, cost : real)
The key fields are underlined and domain of each field is listed after the field name.
Find the name of suppliers who supply some red parts
Find the sids of suppliers who supply some “red part” or are at “kydganj”