Question: Consider the following relations for a database that keeps track of automobile sales in a car dealership: CAR(Serial_No, Model, Manufacturer, Price) OPTION(Serial_No, Option name, Price)
-
Consider the following relations for a database that keeps track of automobile sales in a car dealership:
CAR(Serial_No, Model, Manufacturer, Price) OPTION(Serial_No, Option name, Price) SALE(Salesperson_ID, Serial No, Date, Sale_price) SALESPERSON(Salesperson_ID, Name, Phone)
Option denotes optional equipment.
-
(2) For the salesperson Jim, write a relational algebra expression to find the following information for the cars sold: Serial number, Manufacturer, Model, Sales price.
-
(2) Write a relational algebra expression to find the serial number and model of cars with no options.
-
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
