exercise

Converting to 3NF

Last, but not least, we are at 3NF. In the last exercise, you created a table holding car_idss and car attributes. This has been expanded upon. For example, car_id is now a primary key. The resulting table, rental_cars, has been loaded for you.

Instruktioner 1 / 2

undefined XP

1

2

Fråga

Why doesn't rental_cars meet 3NF criteria?

Möjliga svar

Because there are two columns that depend on the non-key column, model.

Because there are two columns that depend on the non-key column, color.

Because 2NF criteria isn't satisfied.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}exercise

Instruktioner 1 / 2

Fråga

Möjliga svar

exercise