Kerala University 2010-5th Sem B.Tech Computer Science and Engineering Data Base Design - Question Paper
Ftllh Semester B.Tech. Degree Examination, November 2010 (200B Scheme)
08.503 DATA RASH DESIGN
Time: J Hours MavMarlcsilGfJ
PART-A
(Answer nil questions. Each carries 4 marks)
1 What arc (he characteristics of Uatabase Approach?
2 WhaL is Indexed sequential File organization?
3 Explain the attribute types ol' E-R model?
4 Distinguish between schema and instances. Give examples
5 Define functional dcpcndcncics?
6 What is meant by & loss less decomposition nf relations?
7 What are transaction states?
3 What do you meant, by serialiitability?
9 What is a deadlock?
i 0 What are the AC ID propcrt ics of a transact iun? (10* 4 40 Marts)
PAR'i-j* y
(Answer any onefiitl question from each Module)
MODULE-]
II a. W hat i i meant by datamode I7 Espla in 1 he di Ifcrent data m udel? {10)
b. Explain three schcirca architecture and describe how il contributes to dala
independence? (10)
(OR)
] 2 A Bank maintains data as follows:
The Hank has different branches, each identified by a branch-namea branch-number and branch assets. The bank maintains account for customers cach containing account -number, balance, and customer-number
Each Customer is identified by Cuslomcr-number, Customcr-name* Street, and City, The bank also maintains Loans taken by customers each containing t-oan -number, Customer-name and Amount.
A customer may be related with an account, Joan or botli. Also each loan Is associated wiib <1 branch.
Represent the information by using an Lntity-Rclalioniiliip diagram. Clearly state all assumptions made. (20)
13 Consider the following relational database.
CUSTOMER (C-USTNO, CUST-NAME, CITY)
BILL (BlLLNO, CUSTNO, BILL-DATt)
U11.1 PRODUCT (IllLLNO, PRODUCTNO.. QUANTITY)
PRODUCT (PRODUCTNO, NAME, UNIT-PRICE)
Give SQL expressions for the following Queries:
A) Find the names of customers along with bill number and date, whose total purchase exceeds Ks.5, 000 in a bill,
B) Find (he names of customers whose bill total amount is more than the total amount for every customer living in 'L'RIVaNDRAM.
C) Modify the Quantity in BILL PRODUCT table to 17 for LilLLNO 5 and PRODUCTNO 12,
D) Delete all bills for customers who live in EkANAKULAM-
E) Find the name of the product whose unit price is maximum, (20)
(OR)
14 a. What is normalization? What are its objectives?
(10)
<10}
b, Slate and explain four forms of Normalization with cxamp-les-
MODULE-111
15 a. Explain the concepts of conflict serial inability and view aerial inability with examples?
(10)
(10)
b Explain about the locking methods?
(OR)
16 a. What are the problems with concurrent database? How can these problems, handled?
m
(10)
b.Write about database recovery?
|
Attachment: |
| Earning: Approval pending. |
