E $2088 Pages: 4

Reg No.: Name:
APJ ABDUL KALAM TECHNOLOGICAL UNIVERSITY
FOURTH SEMESTER B.TECH DEGREE EXAMINATION, DECEMBER 2018
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 List out any three responsibilities of database administrators. (3)

2 Give good examples (using ER notation) for unary and ternary relationships with avery (3)
brief explanation.
3 Consider a scenario where artists act in movies: an artist can act in different movies and (3)
movie can have manyartists. Assuming suitable attributes show how the situation can
be represented using relations with foreign keys. (A relational schema showing primary
and foreign keys is sufficient. Minimal number of attributes is required.)
4 Two relational algebra expressions are said to be equivalent if they produce exactly the (3)
same output. Consider a relation R(A,B,C,D,E) with A as its key.
(1) What can you say about the number of tuples returned by the expression [1५ ०(२)?
(ii) Write two relational algebra expressions equivalent 10 [ 1420 (17-30 (R)).
PART B
Answer any two full questions, each carries 9 marks.
5 a) Briefly explain the concepts of physical data independence and logical data (5)
independence with a typical real-world example for each.
b) In the following ER diagram, howcan we replace the entity set SCENE with an (4)
attribute of the entity set MOVIE? Draw the new ER diagram.

ال _ __ ا __

(೫೦೫೫೫) MOVIEID ‏سۓ'‎
‎VN

ee 1 ಕ സ്സ N PR
( NAME >) MOVIES ८ வன | வே DESC 2
4

‎cs‏ هت
(
‎HOTS >)‏ ۸۲ف

‎6 The relational database schema below represents certain information about albums, (9)
songs in the albums and singers of those songs. Foreign keys are given the same
name as primary keys for easy identification.

‎ALBUMS(ALBUM#, ALBUM-NAME, PRODUCED-BY, YEAR)

‎SONGS(SONG#, SONG-START, DURATION, ALBUM#)

‎SUNGBY(ARITISTNAME, SONG#)

‎In the context of the schema, write relational algebra expressions for the following

‎queries:

‎(a) Names of albums produced by ‘HMV’ in the year 2018, (b) Names of albums

‎in which an artist with name, ‘AVANTHIKA’ sung. (c) Names of albumsin which
Page 1of 4