E

Reg No.:_

D192078 Pages:4

Name:

APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
FOURTH SEMESTER B.TECH DEGREE EXAMINATION(S), DECEMBER 2019
Course Code: CS208
Course Name: PRINCIPLES OF DATABASE DESIGN

Max. Marks: 100 Duration: 3 Hours
PARTA
Answer all questions, each carries 3 marks. Marks
1 List three significant differences between a file-processing system and a DBMS. (3)
2 When is the concept of weak entity used in data modelling? Define the following (3)

3

4

5 a)
b)

6 a)
b)

terms:

(i) Identifying relationship type

(ii) Owner entity type

Consider the relational database shown below:

employee (person-name, street, city) (3)
works (person-name, company-name, salary)

company (company-name, city)

manages (person-name, manager-name)
Define the integrity constraints in the given relation. State the assumptions used.

Design a relational database corresponding to the following E-R diagram. (3)

PART B
Answer any two full questions, each carries 9 marks.
Explain the characteristics of the database approach. (3)
Explain three schema architecture with figure. (6)
Who all are the actors on the scene in DBMS and explain their roles? (3)

Explain the left outer join, right outer join and full outer join operations with (6)
examples.

Page 1 of 3