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
Explain the terms. Total participation and partial participation' with example.
What is an attributes? Explain different types of attributes with examples.
Write SQL queries for the given database.
i) Find the names of sailors who have reserved 'red' boat.
ii) Find the sailor name with highest rank
ii)i Find the average age of sailor.
iv) Find the age of youngest sailor for each rating level.
v) Add the new boat to the database. Assume any values for required attributes.
Explain following relational algebra operational with examples:
i) set intersection
ii) generalized projection
iii) natural join
iv) Division operator