Guru Gobind Singh Indraprastha Vishwavidyalaya 2008 B.C.A Computer Application Data base management system(dbms) - Question Paper
(Please write your Exam Roll No.) Exam Roll No. C*~'
_Second Semester [BCA] May-2008
Subject: Database Management Systems
IPaper Code:BCA~110 \ Paper Id: 20110
Batch (2005-2007)
Time: 3 Hours
Maximum Marks :75
Note: Q1. is compulsory. Rest of the questions have internal choice.
Q1. (2.5x10=25)
"Differentiate between physical data independence and logical data independence. v' (b) What is spanned record organization?
(c) State various relational database design guidelines.
Jjf Illiterate normalization.
.Differentiate between composite & derived attributes.
Distinguish between Primary key, candidate key & super key. i" (g) Define referential Integrity constraint.
,(hf How do you get 3NF from 2NF?
zplain Hashing.
' Define Audit Trail.
(10)
(10)
(5)
(5)
(10)
(10)
(10)
(10)
(10)
Q2, What is timestamp? How does system generate timestamps?-'
OR
WntTe down all the steps of Entity Relationship to Table mapping.
Q3. ,(a)'hat is deadlock & how can it be prevented?
What is 2 phase locking and 2 phase commit protocols.
OR
What is an ER diagram? How is EER different from E-R model. Construct an ER diagram for bankirig'enterprise covering all major activities.
Q4. pjifpiain different mechanism of concurrency control. Define Pros & cons of each.
OR
Illustrate in detail about all Raid level.
Q5. What is a join? Write all categories of joins (theta join, equi join, outer join, self join). , OR
v,0op5'ider a relation schema R(a, b, c, d, e, f) having functional dependencies, b c b - a d > c e af f a
Normalise this relation upto 3NF.
(10)
Q6. .ytfrite SQL queries for:
DNO
Salary
SSN
Lname
(10)
(i) Retrieve first name. Last name of employees who work in Department number 5.
(ii) Retrieve the employees whose salary is areater than 5000.
OR
Write SQL statements for the following table;
Address
Fname |
Customer | |||||||||||||||||||||||||
|
(a) Display the invoice information for customer a01 & 'a02\
(b) Find the movies of type horror and Comedy.
(c) Print the information from invoice table of customer who have been issued movies in the month of September.
************
Attachment: |
Earning: Approval pending. |