Consider the following relational database schema: TYPE( Make, Model, Year, Base
ID: 654363 • Letter: C
Question
Consider the following relational database schema:
TYPE(Make, Model, Year, Baseprice)
VEHICLE(VID, Color, Make, Model, Year)
CUSTOMER(CID, CName, CStreet, CCity, CState, CZip)
SALES(VID, CID, Salesperson, Salesprice, DateSales)
OPTIONS(Code, Description, Price)
AVAIL_OPT(Make, Model, Year, Opcode, Std_opt)
HAS_OPT(VID, Code)
The primary key of each table is bolded.
Answer the following queries using Relational Algebra (using either book notations or WinRDBI notations).
I just need the actual queries I would make, not the results.
2. Display the colors of the FORD EXPLORERS purchased in February 1993. (COLOR)
3. Which vehicle had the most expensive sales price? (VID, Make, Model, Year, Salesprice)
4. Which vehicle type has the least expensive base price? (Make, Model, Year, Baseprice)
The attributes in the parentheses are to be displayed. Answer at least one and I will give full points.
Explanation / Answer
Answers:
Select Operator (?)
It selects tuples/rows that satisfy the given predicate/predicate from a relation.
Notation ? ?p(r)
the meaning of ? is selecting predicate and r for relation. p is preposititional logic, which use connectors like and,or and not, Other relational operators like =, ?, ?, < , >, ?.
For example ?
Output ? Selects tuples from books where subject is 'database'.
2. Display the colors of the FORD EXPLORERS purchased in February 1993. (COLOR)
Answer: