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, 24.06.2019 00:00
For the following example of making a peanut butter and jelly sandwich, identify which are inputs, processes, or outputs: bread scooping and spreading peanut butter plate scooping and spreading jelly finished sandwich putting two pieces of covered bread together dirty plate crumbs
Answers: 2
question
Computers and Technology, 25.06.2019 05:00
How does computer network work in a paragraph
Answers: 1
question
Computers and Technology, 25.06.2019 12:00
Fill in the blank; "as well as their traditional role of computing data, computers are also extensively used "
Answers: 3
question
Computers and Technology, 25.06.2019 21:10
Steps for turning off two step verification on ,for example, iphones.
Answers: 1
You know the right answer?
Consider the following relation : CAR_SALE (Car#, Date_sold, Salesman#, Commission%, Discount_amt)....
Questions
question
Mathematics, 29.07.2021 23:50
question
Mathematics, 29.07.2021 23:50
question
Mathematics, 29.07.2021 23:50
question
History, 29.07.2021 23:50
question
Mathematics, 29.07.2021 23:50
question
Mathematics, 29.07.2021 23:50
question
Mathematics, 29.07.2021 23:50
Questions on the website: 13722360