subject
Computers and Technology, 20.09.2020 18:01 med69

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?

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 01:30
Someone wishes to run the software on another computer system that runs an operating system that does not support the software what can he do
Answers: 3
question
Computers and Technology, 22.06.2019 23:50
List a few alternative options and input and output over the standerd keyboard and monitor. explain their functioning in details.
Answers: 2
question
Computers and Technology, 23.06.2019 02:30
Which component acts as a platform on which application software runs
Answers: 2
question
Computers and Technology, 23.06.2019 16:00
Does read theory have answers keys ?
Answers: 1
You know the right answer?
Consider the following relation : CAR_SALE (Car#, Date_sold, Salesman#, Commission%, Discount_amt)....
Questions
question
Arts, 06.07.2021 18:50
question
Mathematics, 06.07.2021 18:50
question
Mathematics, 06.07.2021 19:00
Questions on the website: 13722363