Question
Database Systems (NEEDS TO USE ORACLE LANGAUGE SOFTWARE) - ORACLE PLEASE DO NOT NOT WRITE IN SQL ORACLE SOFTWARE ONLY!! SHOW PICTURE EXERCISES ON RELATIONAL
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started