Exercise

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.

Instructions 1/2

undefined XP

1

2

Question

Why doesn't customer_rentals meet 2NF criteria?

Possible answers

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.