Chat with AI
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Edition 6ISBN: 0136086209 Exercise 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.
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.
Explanation
Verified
Verified
For this relation to be in 3NF, all of t...
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
