练习

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 个

问题

答案选项

练习