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.
For this relation to be in 3NF, all of the nontrivial functional dependencies must both be fully functional and nontransitive on every key of the relation. However, in this relation we have two dependencies (CarID ? Sale_date and Option_type ? Option_Listprice) that violate these requirements. Both of these dependencies are partial and transitive.
For this relation to be in 2NF, all of the nontrivial functional dependencies must be fully functional on every key of the relation. Again, as was discussed about 3NF, this relation has two partial dependencies that violate this requirement.
You might also like to view...
[C++14] : Which of the statements a), b) and c) is false?
a. To create a binary literal, precede a sequence of 1s and 0s with 0b or 0B. b. You can define a 32-bit mask as 0b10000000'00000000'00000000'00000000 c. The literal in part b) uses C++14’s single-quote character to separate groups of digits for readability. d. All of the above statements are true.
IP is an example of a protocol that operates in which layer of the OSI model?
a. Layer 7 b. Layer 6 c. Layer 5 d. Layer 2 e. None of these answers is correct.
A custom chart type that you can apply like any other chart type is a ________
A) dual axis chart B) 3-D pie chart C) scatter chart D) chart template
The computer at your email service provider that handles outgoing email messages is called the ____.
A. Internet service provider B. email service provider C. outgoing service provider D. outgoing email server