Is the Video store in 1NF?

No attributes should form repeating groups - remove them by creating another table. There are repeating groups for videos and customers.

CUSTOMER (Cust_Num, Cust_Name, Cust_address_Cust_phone

VIDEO (VideoNum, VideoName, VideoType

RENTAL (Cust_num, VideoNum, Rental_date, Return_date, TotalPrice, Paid?)

Previous slide

Next slide

Back to first slide

View graphic version