E D1071 Pages: 4

Reg No.:_ Name:

APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
FOURTH SEMESTER B.TECH DEGREE EXAMINATION, MAY 2019
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. Marks
1 Illustrate with an example, the difference between the conceptual data models and the (3)

physical data models.

2 How is weak entity type different from a strong entity type? Give an example. (3)
3 What is entity integrity constraint? Why is it important? (3)
4 Using the following ER diagram, create a relation database. Give your assumptions. (3)

PART छ
Answer any two full questions, each carries 9 marks.

5 9७) With the help of an example, compare DML and DDL. (4)
b) What are logical data independence and physical data independence? What is the (5)

difference between them? Which of these harder to realize? Why?

6 Design an ER diagram to represent the following scenario: (9)
A company has many employees working on a project. An employee can be part of
one or more projects. Each employee works on a project for certain amount of time.
Assume suitable attributes for entities and relations. Mark the primary key(s) and the
cardinality ratio of the relations.

7 Consider the following relations for a database that keeps track of business trips of
salespersons in a sales office:

SALESPERSON(Ssn, Name, StartYear, DeptNo)

Page 1 of 4