Database Management SystemTU Board 2021
Given the schema as below, write relational algebra and SQL queries for following: Sailors(sid, sname, rating, age) Boats(bid, bname, colour) Reserves(sid, bid, reservedate) a) Find name, rating and…
10Given the schema as below, write relational algebra and SQL queries for following: Sailors(sid, sname, rating, age) Boats(bid, bname, colour) Reserves(sid, bid, reservedate) a) Find name, rating and age of all the sailors. b) Find the name and color of boats having color blue. c) Find name of the boats reserved on date 2021/07/20. d) Find the names of boats and sailors who have reserved boats having color green. e) Use Left and Right Outer Join between Sailors and Reserves.
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define transaction. Describe ACID properties with example. [1+4]TU Board 20265Explain physical data independence and logical data independence. [2.5+2.5]TU Board 20265What is stored procedure? Describe statement level trigger and multi row enabled trigger? [1+4]TU Board 20265Define schedule and serializability with example. How can you test the serializability? [2+3]TU Board 20265What is data model? What are its types? [1+4]TU Board 20265Define query processing and steps in query processing. [1+4]TU Board 20265