subject

Consider the following relation: car_sale(car_id, date_sold, salesperson_id, commission_percent, discount_amt) assume that a car may be sold by multiple salespeople, and hence {car_id, salesperson_id} is the primary key. additional dependencies are: date_sold β†’ discount_amt salesperson_id β†’ commission_percent (a) based on the given primary key, is this relation in 1nf, 2nf, or 3nf? why or why not? (b) how would you successively normalize it completely?

ansver
Answers: 2

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 00:30
Quick pl which one of the following is considered a peripheral? a software b mouse c usb connector d motherboard
Answers: 1
question
Computers and Technology, 23.06.2019 11:30
Me dangers of social media and the internetexplain what each means: 1) social media and phones have become an addiction.2) outside people have access to you all the time.3) cyberstalking4) cyberbullying5) catphishing6) viruses7) identity theft8) credit card fraud9) hacking10) money schemes
Answers: 1
question
Computers and Technology, 23.06.2019 15:00
What is the total resistance in a circuit that contains three 60 ohm resistors connected in a series? a. 20 ohms b. 120 ohms c. 60 ohms d. 180 ohms
Answers: 2
question
Computers and Technology, 23.06.2019 22:20
If i uninstall nba 2k 19 from my ps4 will my career be gone forever?
Answers: 2
You know the right answer?
Consider the following relation: car_sale(car_id, date_sold, salesperson_id, commission_percent, di...
Questions
question
Mathematics, 30.10.2020 20:40
question
Mathematics, 30.10.2020 20:40
question
English, 30.10.2020 20:40
question
Chemistry, 30.10.2020 20:40
question
Mathematics, 30.10.2020 20:40
question
History, 30.10.2020 20:40
question
Chemistry, 30.10.2020 20:40