do not copy from Google do it clearly in your own handwriting.

1. Discuss the following with examples (where necessary) Relational Data model (1) Attributes (1Legal Instance (iv) Entity (v) E-R data model 2. What is Relational Algebra? Describe its fundamental operators with suitable examples 3. List any five advantages of using DBMS in compare to File system management. How DBMS supports the logical and physical data independence 4. What do you mean by Integrity Constraints? Discuss the Primary key and Foreign Key constraints by taking two relations STUDENT and ENROLLMENT 5. Use three relations Sailor (sid, sniame rating, age). Reserve (sid, bid day) and Boat (bid, bname, color) and write the Relational Algebro syntax for following queries (1) Find the name and age of sailors who have reserved boat 105 Find the name of sailors who have reserved both, red and green bouts Find the name of sailors who have reserved at least two boats (iv Find the name of sailors who have reserved all the boats (v) Find the sid of sailors with age more than 25, who have not reserved a red boat 6. Use three relations Sailor (sid, shame, rating age), Reserve (Nid, bid, day) and Boat (bid, name, color) and write the TRC syntax for following queries (1) Find the name and age of sailors with rating above 7 (11) Find the sailor's name, bout id and reservation date for each reservation Find the name of sailors who have reserved boat 105 (iv) Find the name of sailors who have reserved a red boat Find the name of sailors who have reserved at least two boats