演習

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.

指示1 / 2

undefined XP

1

2

質問

Why doesn't rental_cars meet 3NF criteria?

選択肢

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;}演習

指示1 / 2

質問

選択肢

演習