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?

Answers: 2

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 09:30, relic7391

Is a string of code written to hurt others by damaging or destroying

Answers: 1

continue

Computers and Technology, 23.06.2019 10:00, serenityharmon1

Hey i just logged on and one of the moderators deleted a bunch of my answers to questions, even though the answers were right and the people it doesn't make sense but if anyone wants to talk about anything just message me lol (this is super random lol)

Answers: 1

continue

Computers and Technology, 23.06.2019 16:30, rileysndr1782

Monica and her team have implemented is successfully in an organization. what factor leads to successful is implementation? good between different departments in an organization leads to successful is implementation.

Answers: 1

continue

Computers and Technology, 24.06.2019 04:30, minecrafter3882

Fall protection, confined space entry procedures, controlled noise levels, and protection from chemical hazards are some of the things that contribute to a safe what

Answers: 1

continue

You know the right answer?

Consider the following relation : CAR_SALE (Car#, Date_sold, Salesman#, Commission%, Discount_amt)....