Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

تمرين 2

Consider the following relation:
CAR_SALE (CarID, Option_type, Option_Listprice, Sale_date, Discounted_price)
This relation refers to options installed on cars (e.g.- cruise control) that were sold at a dealership and the list and discounted prices for the options.
If CarID → Sale_date and Option_type→ Option_Listprice, and
CarID, Option_type → Discounted_price, argue using the generalized definition of the 3NF that this relation is not in 3NF. Then argue from your knowledge of 2NF, why it is not in 2NF.