Based on the given primary key, is this relation in 1NF, 2NF, or 3NF? Why or why not? How would you successively normalize it completely?
Consider the following relation:
CAR_SALE(Car#, Date_sold, Salesman#, Commision%, Discount_amt
Assume that a car may be sold by multiple salesmen and hence {CAR#, SALESMAN#} is the primary key. Additional dependencies are:
Date_sold ->Discount_amt
and
Salesman# ->commission%
```
Given the relation schema
Car_Sale(Car#, Salesman#, Date_sold, Commission%, Discount_amt)
with the functional dependencies
Date_sold ??Discount_amt
Salesman# ??Commission%
Car# ??Date_sold
This relation satisfies 1NF but not 2NF (Car# ??Date_sold and Car# ?
Discount_amt
so these two attributes are not FFD on the primary key) and not 3NF.
To normalize,
2NF:
Car_Sale1(Car#, Date_sold, Discount_amt)
Car_Sale2(Car#, Salesman#)
Car_Sale3(Salesman#,Commission%)
3NF:
Car_Sale1-1(Car#, Date_sold)
Car_Sale1-2(Date_sold, Discount_amt)
Car_Sale2(Car#, Salesman#)
Car_Sale3(Salesman#,Commission%)
```
You might also like to view...
Most computers are assigned a temporary IP address called a(n) static IP address.
Answer the following statement true (T) or false (F)
A computer-generated report includes inventory information for 200 items. The information for each item is given on a separate line. If 50 lines will fit on a page of printer paper, how many pages of printer paper will it take print the report?
Identify the data, condition, and unknown (Polya's components).
Which of the following statements is not true about importing an Excel spreadsheet into Access?
A) It will make the database file size larger. B) There will be no dependency between the imported data and the original Excel sheet. C) You have more control over the imported data. D) You have less control over the imported data.
To create a file that can be transferred between platforms, use the ________ file extension
A) .rtf B) .docx C) .potx D) .txt