Database Management Systems - Dec 2013
Computer Engineering (Semester 4)
TOTAL MARKS: 80
TOTAL TIME: 3 HOURS (1) Question 1 is compulsory.
(2) Attempt any three from the remaining questions.
(3) Assume data if required.
(4) Figures to the right indicate full marks. 1(a) galleries keep information about artist,their names (which are unique birthplace, age and style of an art)for each piece of artwork the artist. The its price must be stored. Its unique title, its type of art(e.g.painting, sculpture),and its price must be stored.
i) Piece of artwork are also classified into groups of various kinds e.g portraits, still life works by Picasso or works by 19th century a given piece may belong to more than one group.
ii) Each group is identified by a name (like those given)that describes the group.
iii) galleries keep information about customers like persons (unique name, address total amount spent, artist and the group of art that the customers tends to like).
iv) Draw ER diagram for the database and covert it into equivalent schema.(10 marks) 1(b) Explain the following terms with example(2marks each)
i) Weak entity set
ii) Project operator in relational algebra
iii) Foreign key
v) Data manipulation languages.(10 marks) 2(a) Explain first, second and third normal forms with example.(10 marks) 2(b) Explain two phase locking protocol.(10 marks) 3(a)
Person (<u>driver-id</u>, name, address)
car(<u>license</u>, model, year)
accident(<u>report-number</u>, <u>date</u> location)
Participated (<u>driver-id</u>, <u>car</u>, <u>report-number</u>, damage, amount)
i) Create relation persons owns inSql
ii) Add a new accident to the database,assume any values for required attribute.
iii) Delete the SKODA belonging to 'Sachin Parker'.
iv) Find the total number of people who owned cars that were involved in accident in 1999.
v) Find the total number of people whose names starts with'S' and arrange in decreasing order of driver-id.
Write short notes on:
7 (a) Mapping cardinality(5 marks) 7 (b) Aggregate function in SQL(5 marks) 7 (c) Shadow paging(5 marks) 7 (d) Checkpoints(5 marks) 7 (e) Views in SQL.(5 marks)