Exercises

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;}Exercises

คำแนะนำ 1 / 2

คำถาม

คำตอบที่เป็นไปได้

Exercises