Question
Vehicle(VRN, Ma, Mo, Color) , Own(VRN, SSN) , Person (SSN, Name, Addr, Phone) Vehicle Own Person VRN Ma Mo Color VRN SSN SSN Name Addr
Vehicle(VRN, Ma, Mo, Color) , Own(VRN, SSN) , Person (SSN, Name, Addr, Phone)
| Vehicle |
| Own |
| Person |
| |||
VRN | Ma | Mo | Color | VRN | SSN | SSN | Name | Addr | Phone |
123 | Honda | Hawk | Red | 123 | bcd | abc | Dave | Birch | xxx |
234 | Mazda | RX7 | Blue | 234 | abc | bcd | Mary | Grove | yyy |
345 | Ford | Taurus | Blue | 456 | uonakoo | cde | Sriram | Oak | zzz |
456 | Ford | Ranger Green | 567 | ghi | def | Fang | Birch | www | |
567 | Honda | Accord Red | 683 | def | efg | Derek | Elm | uuu | |
678 | Mazda | RX7 | Silver | 795 | abc | uona | Jason | Elm | vvv |
789 | VW | Bug | White | 901 | bcd | ghi | Xie | Oak | sss |
890 | Suzuki | Intruder | Black | 789 | uona | hij | Gilford | Birch | ttt |
901 | Harley | Sportster | Black |
|
|
|
|
|
|
012 | VW | Bug | Red |
|
|
|
|
|
|
1. Write a relational algebra query to return all rows (tuples) of Vehicle table in which Ma = Suzuki
2. Write a relational algebra query to return only the Ma and Mo of Vehicles with Ma = VW
|
|
|
|
|
3. Using the full table of the handout write the result of the query
TT Ma, SSN ( (Vehicle I own) Color ,Green
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