แบบฝึกหัด

Converting to 3NF

Last, but not least, we are at 3NF. In the last exercise, you created a table holding car_idss and car attributes. This has been expanded upon. For example, car_id is now a primary key. The resulting table, rental_cars, has been loaded for you.

คำแนะนำ 1/2

undefined XP

1

2

คำถาม

Why doesn't rental_cars meet 3NF criteria?

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

Because there are two columns that depend on the non-key column, model.

Because there are two columns that depend on the non-key column, color.

Because 2NF criteria isn't satisfied.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}แบบฝึกหัด

คำแนะนำ 1/2

คำถาม

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

แบบฝึกหัด