演習

Converting to 2NF

Let's try normalizing a bit more. In the last exercise, you created a table holding customer_ids and car_ids. This has been expanded upon and the resulting table, customer_rentals, has been loaded for you. Since you've got 1NF down, it's time for 2NF.

指示1 / 2

undefined XP

1

2

質問

Why doesn't customer_rentals meet 2NF criteria?

選択肢

Because the end_date doesn't depend on all the primary keys.

Because there can only be at most two primary keys.

Because there are non-key attributes describing the car that only depend on one primary key, car_id.

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

指示1 / 2

質問

選択肢

演習