subject

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% 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?

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 02:00
Aletter or menu command that starts an action when the user presses the designated letter and the alt key together is called what?
Answers: 1
question
Computers and Technology, 22.06.2019 10:00
What is a society that has moved to the internet rather than relying on physical media called
Answers: 2
question
Computers and Technology, 22.06.2019 11:00
Which law requires employers to provide safe working environments for their employees? a. civil rights act b. fair labor standards act c. occupational safety and health act d. wagner act
Answers: 1
question
Computers and Technology, 23.06.2019 12:30
How is the brightness of oled of the diaplay is controled
Answers: 1
You know the right answer?
Consider the following relation: CAR_SALE(Car#, Date_sold, Salesman#, Commision%, Discount_amt) Assu...
Questions
question
Physics, 22.04.2020 20:57
question
Mathematics, 22.04.2020 20:57
question
Mathematics, 22.04.2020 20:57
question
Physics, 22.04.2020 20:57
Questions on the website: 13722367