Database Management Systems
Total time: --
(1) Assume appropriate data and state your reasons
(2) Marks are given to the right of every question
(3) Draw neat diagrams wherever necessary
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.
i) Weak entity set
ii) Project operator in relational algebra
iii) Foreign key
v) Data manipulation languages.
Person (driver-id, name, address)
car(license, model, year)
accident(report-number, date location)
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.