Download AKTU B-Tech 5th Sem 2016-2017 Database Management Systemdbms Ncs 502 Question Paper

Download AKTU (Dr. A.P.J. Abdul Kalam Technical University (AKTU), formerly Uttar Pradesh Technical University (UPTU) B-Tech 5th Semester (Fifth Semester) 2016-2017 Database Management Systemdbms Ncs 502 Question Paper

Printed Pages - 4 NCS-502
(Following Paper ID and Roll No. to be ?lled in your
Answer Books)
Paper II): 21H 227?) Roll No_
B.TECH
Regular Theory Examination (Odd Sem -V), 2016-17
DATABASE MANAGEMENT SYSTEM (DBMS)
Time : 3 Hours Max. Marks : 100
Section - A
1. Attempt?all parts . All parts carry equal marks.
Write answer of each part in short. 3 (10X2=20)
a) What is data model? List the types of data model
used.
b) Give example for one to One and one to many
relationship.
0) With an example show how a referential integrity
can be implemented.
(1) Write the purpose of trigger.
e) ' What is normalization?
f) De?ne the term ACID properties.
502/12/2016/13260 (1) [P.T.O.

NCS-502
g) State the properties of transaction.
h) What is serializability? How it is tested?
i) Why is concurrency control needed?
j) Define timestamp.
Section 4 B
2. Attempt any ?ve questions from this section.
'(5X10=50)
a) Consider the following relational database
employee (employee-name, street, city works
(employee-name, company-name, salary) company
(company-name, city) manages (employee-name,
' manager?name).
Give an expression in SQL to express each of the
following queries:
i) Find the names and cities of residence of all
employees who work for XYZ bank.
ii) F ind the names, street address, and cities of
residence of all employees who work for XYZ
Bank and earn more than Rs. 10,000 per annum.
iii) Find the names of all employees in this
database who live in the same city as the
company for which they work.
502/12/2016/13260 (2)
Note:
b)
NCS-502
Discuss about the deadlock prevention schemes.
Explain the differences between physical level,
conceptual level and view level of data abstraction.
Explain embedded SQL and dynamic SQL in detail.
Describe shadow paging recovery technique.
Write down in detail about deadlock and
serializability.
Section - C
Attempt any 2 questions from this section.
(2X15=30)
What are the relational algebra operations supported
in SQL? Write the SQL statement for each
operation.
' Draw an ER diagram for a small marketing company
database, assuming your own data requirements.
Explain lNF, 2NF, 3NF and BCNF with suitable
example.
Consider the universal relational schema R (A, B,
C, D, E, F, G, H, 1, J) and a set of following ?mctional
dependencies. '
.F={AB?>C,A?>DE,B?>F,F?>GH,D?>IJ}
502/12/2016/13260 ' (3) [P.T.O.

NCS-502
Determine the keys for R? Deco?mpose R into 2nd'
NormalForm.
5. Explain the following protocols for concurrency control.
i) Lock based protocols
ii) Time Stamp based protocols
502/12/2016/13260 (4)