Consider the following relation : CAR_SALE (Car#, Date_sold, Salesman#, Commission%, Discount_amt). Assume that a car may be sold by multiple salesmen and hence {CAR#, SALESHMAN#} is the primary key. Additional dependencies are : Date_sold-> Discount_amt and Salesman#-> Commission% 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 ?
Answers
Given relation CARSALE (Car#, Date_sold, Salesman#, Commission%, Discount_amt) Given {Car#, Salesman#} is the primary key.
⇒ Prime attributes = {Car#, Salesman#}
Additional FD is
Date_sold → Discount_amt
Salesman# → Commission%
∴ FD’s of above relation are
Car# Salesman# → Date_sold Commission%
Discount_amt (1)
Date_sold → Discount_amt (2) Salesman# → Commission% (3)
Checking for 2NF:
A relation r is said to be in 2NF, if they are no partial dependencies in r.
Partial dependency is nothing but part of the key determining nonkey attribute.
Here FD (3) is partial dependency since salesman# which is part of key determining nonprime attribute commission%
∴ Highest normal form, the above relation
satisfying is 1NF
Explanation:
mark the?brainliest
Explanation:
all the attributes in R will be atomic/single valued so it has 1NF
