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.

Instructions 1/2

undefined XP

1

2

Question

Why doesn't rental_cars meet 3NF criteria?

Possible answers

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.