Database Management Systems : Question Paper Dec 2013 - Computer Engineering (Semester 4)

3views

written 8.7 years ago by

teamques10 ★ 68k

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 19^th 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
iv) Join
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 (driver-id, name, address)
car(license, model, year)
accident(report-number, date location)
owns(driver-id,license)
Participated (driver-id, car, report-number, 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.

(10 marks) 3(b) Explain any five relation algebra operators.(10 marks) 4(a) what is transaction discuss ACID properties of transaction.(10 marks) 4(b) Explain data dictionary storage.(5 marks) 4(c) Explain data independence.(5 marks) 5(a) Explain UNDO and REDO operation for log based recovery. How are they used during recovery.(8 marks) 5(b) Describe method for deadlock recovery.(6 marks) 5(c) Give one protocol that prevents deadlock.(6 marks) 6(a) Explain differed modification techniques For log based recovery.(10 marks) 6(b) Explain Conflict serializability(10 marks)

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)

ADD COMMENT EDIT