Database Systems

(NEEDS TO USE ORACLE LANGAUGE SOFTWARE) - ORACLE PLEASE DO NOT NOT WRITE IN SQL

ORACLE SOFTWARE ONLY!! SHOW PICTURE EXERCISES ON RELATIONAL ALGEBRA

Use the following schema to write relational algebra statements for the questions that follow. The primary keys are underlined in the schema. Sailor (sid:char,sname:char, age:integer) Boat (bid: char, bname:char, color:cha) Reservation (sid:char, bid:char, rdate:date, deposit:numeric)

1. List the names of the boats that were reserved between 01/23/2014 and 03/10/2014.

2. Find the name and age of the sailor who reserved the green boat on 04/15/2014

3. How much was deposited for the boat named Fair Play and what date was it reserved?

4. How old is the sailor who reserved a green and a blue boat?

5. Find the names of the sailors who deposited more than $100 for a boat reservation

6. Find the color of the boat that has not yet been reserved.