E 02000CS208052002 Pages: 4
Reg No.: Name:
APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
Fourth semester B.Tech examinations (S), September 2020

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 three schema architecture with a suitable diagram. (3)
2 With a help of an example, elaborate weak entity set and strong entity set. (3)
3 Differentiate DDL and DML with suitable example. (3)
4 With suitable example, define integrity constraint? (3)
PART B

Answer any two full questions, each carries 9 marks.

(9)

Design an ER diagram for the given scenario;

Suppose that you are designing a schema to record information about reality

shows on TV. Your database needs to record the following information:

_ For each reality show, its name, genre, basic_info and participants name. Any

reality show has at least two or more participants.

- For each producer, the company name, company country. A show is produced by

exactly one producer. And one producer produces exactly one show.

- For each television, its name, start year, head office. A television may broadcasts

multiple shows. Each show is broadcasted by exactly one television.

-For each user, his/her username, password, and age. A user may rate multiple
shows, and a show may be rated by multiple users. Each rating has a score of 0 to

10.

Page 1 of 4