B4E0562
Total Pages: 2
Reg No.: __ _ Name:
APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
FOURTH SEMESTER B.TECH DEGREE EXAMINATION, JULY 2017
Course Code: CS208
Course Name: PRINCIPLES OF DATABASE DESIGN (CS, IT)
Max. Marks: 100 Duration: 3 Hours
Limit answers to the required points.
PARTA
Answer all questions. Each carries 3 marks.
1 What are the responsibilities of the DBA? (3)
2 Define the following terms: (3)
i) Data model ii) Database schema 111) Meta-data
3 Consider the following ER diagram. Using this ER diagram create a relational (3)
database (primary keys are underlined).
ಜಾ ലു ~~ —
മ) (மழ) (चट) CH)
‏ے‎ UN | ‏اح ےم‎ |
—]| for LRN 0
‏ید‎ ۲
© a വ്യൂ (121) (०; ٦
(4) (०३.१.९५ (121 2)
4 What are the different ways of classifying a DBMS? (3)
PART B
Answer any two questions. Each carries 9 marks.
5 With the help of a neat diagram explain the three-schema architecture of DBMS. (9)
6 Explain the following terms briefly: - (9)

i) Participation constraint
ii) Overlap constraint
iii) Covering constraint
7 Consider the following database with primary keys underlined (9)
Suppliers ( sid, sname, address)
Parts ( pid, pname, color)
Catalog ( sid, pid, cost)
sid is the key for Suppliers, pid is the key for Parts, and sid and pid together
form the key for Catalog. The Catalog relation lists the prices charged for
parts by Suppliers.
Write relational algebra for the following queries: -
i) Find then names of suppliers who supply some red part
ii) Find the sids of suppliers who supply some red or green part
iii) Find the sids of suppliers who supply some red part and some green part.

Page 1 of 2