Normalization Example: Video Store
A video rental shop tracks all of their information in one table. There are now 20,000 records in it. Is it possible to achieve a more efficient design? (They charge $10/movie/day.)
VIDEO (Cust_name, Cust_address, Cust_phone, Rental_date, Video_1, Video_2,
Video_3, VideoType_1, VideoType_2, VideoType3, Return_date, Total_Price,