Exercise

Converting to 1NF

In the next three exercises, you'll be working through different tables belonging to a car rental company. Your job is to explore different schemas and gradually increase the normalization of these schemas through the different normal forms. At this stage, we're not worried about relocating the data, but rearranging the tables.

A table called customers has been loaded, which holds information about customers and the cars they have rented.

Instructions 1/2

undefined XP

1

2

Question

Does the customers table meet 1NF criteria?

Possible answers

Yes, all the records are unique.

No, because there are multiple values in cars_rented and invoice_id

No, because the non-key columns such as don't depend on customer_id, the primary key.