अभ्यास

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

प्रश्न

संभावित उत्तर

अभ्यास