Computers and Technology, 12.11.2019 02:31 jagger68

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?

Answers: 2

Show answers

Another question on Computers and Technology

Computers and Technology, 23.06.2019 00:00

What engine component is shown in the above figure?

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:30

Write a program that prints the day number of the year, given the date in the form month-day-year. for example, if the input is 1-1-2006, the day number is 1; if the input is 12-25-2006, the day number is 359. the program should check for a leap year. a year is a leap year if it is divisible by 4, but not divisible by 100. for example, 1992 and 2008 are divisible by 4, but not by 100. a year that is divisible by 100 is a leap year if it is also divisible by 400. for example, 1600 and 2000 are divisible by 400. however, 1800 is not a leap year because 1800 is not divisible by 400.

Answers: 3

Answer

Computers and Technology, 24.06.2019 13:30

What process should be followed while giving a reference? sam has given a reference of his previous manager in his resume. sam should him in advance that the potential employers will him.

Answers: 1

Answer

Computers and Technology, 24.06.2019 17:30

Which computer network component connects two different networks together and allows them to communicate? a is a node (or a device) that connects two different networks together and allows them to communicate.

Answers: 2

Answer

You know the right answer?

Consider the following relation: car_sale(car_id, date_sold, salesperson_id, commission_percent, di...

Questions