Reg. no.
DEPARTMENT OF SCIENCE AND HUMANITIES
SET
CAT2 EXAM: OCT 2023
SUBJECT CODE: AD3391 – DATA BASE DESIGN AND MANAGEMENT
Year/Sem II / III Date 19.12.2023
Department CSE Duration 3 Hours
Faculty ATHIRAYAN S Max. Marks 100
PART A(10x2=20)
1. Define functional dependency? R CO3
2. What is decomposition R CO3
3. Explain about Loss Less Join Decomposition R CO3
4. Differentiate Weak and Strong Entity Sets U CO3
5. Discuss normalization.1NF,2NF, U CO3
6. Define a Transaction? List the properties of transaction R CO4
7. What is a serializable schedule? U CO4
8. What are the needs for concurrency? R CO4
9. What are the steps followed in executing write(x) command in Transaction? R CO4
10. Define Two Phase locking protocol? U CO4
PART B(5x13=65)
11.a) Discuss in details the steps involved in the ER to Relational – Relational mapping U CO3
11.b) Explain the concept of lozzy and lossless Decompositon U CO3
12.a) Describe properties of relational decomposition U CO3
12.b) Define normalization? Explain 1NF,2NF,3NF normal forms U CO3
13.a) Compare and contrast Boyce Code Normal Form(BCNF )with 3NF? Ap CO3
13.b) Explain ACID properties and illustrate them through examples Ap CO4
14.a) Discuss Serializability in detail? Ap CO4
14. b) Explain the concurrency control Ap CO4
15. a) Explain different types of advanced recovery techniques U CO4
15.b) Discuss two phase locking protocol and strict two phase locking protocols U CO4
PART C(1x15=15)
16 A software contract and consultancy firm maintains details of all various projects in A CO3
which its employees are currently involved. These details comprise
1.Employee number
2.Employee name
3.Date of Birth
4.Department code
5. Department Name
6.Project code
7.Project description
8.Project Supervisor
Assume the following :
Each Employee number is unique
Each department has a single department code
Each project has a single code and supervisor
Each employee may work on one or more projects
Employee names need not necessarily be unique
Project code, project description and project supervisor are repeating fields.
Normalise this data to third normal form
Reg. no.:
DEPARTMENT OF SCIENCE AND HUMANITIES
SET B
CAT2 EXAM: OCT 2023
SUBJECT CODE: AD3391 – DATA BASE DESIGN AND MANAGEMENT
Year/Sem II / III Date 19.12.2023
Department CSE Duration 3 Hours
Faculty ATHIRAYAN S Max. Marks 100
PART A(10x2=20)
1. Define the terms Entity set and Relationship set? Ap CO3
2. Explain about Loss Less Join Decomposition R CO3
3. What are attributes? Give Example R CO3
4. Define Second Normal Form(2NF) U CO3
5. Define Boyce Code Normal Form R CO3
6. Discuss different phases(states) of transaction R CO4
7. What are the two operations for accessing data in transaction? U CO4
8. What are the steps followed in Executing read(x) command in Transaction? U CO4
9. What is timestamp? R CO4
10. Explain about locking protocols? U CO4
PART B(5x13=65)
11.a) Explain Enhanced Entity Relationship Model U CO3
11.b) Briefly Discuss about the functional dependency concepts U CO3
12.a) Explain the concept of Dependency preservation Ap CO3
12.b) Describe the process of decomposition Ap CO3
State the need for normalization of a Database and Explain the various Normal
13.a) U CO3
Forms (1st , 2 nd,3rd, BCNF, 4th, 5th and Domain-key) with suitable examples?
13.b) Discuss the Desirable properties of Transactions U CO4
14.a) Explain Scheduling of Transactions U CO4
14. Explain the concurrency control CO4
U
b)
15. a) Explain different types of advanced recovery techniques U CO4
15.b) Discuss two phase locking protocol and strict two phase locking protocols U CO4
PART C(1x15=15)
16. Draw E-R diagram for the “Restaurant menu ordering system” that will facilitate the A CO3
food items ordering and services with in a restauran
