Question 6
Which of the following relations are guaranteed to be in third normal form even if you don't have the
related FDs to check 3NF?
WatchNext (Customer ID*, Video ID*, Notification Requested)
FK (Customer ID) references Customer
FK (Video ID) reference Video
Customer (Customer ID, Email Address, Name, Address, Phone Number, Date of Birth, Registration Year)
Video (Video ID, Video Title, Genre, Release Year, Rental Rate)
Rental (Customer ID*, (Video ID, Copy Serial Number)*, Rental Date, Due Date, Late Fee, Return Date)
FK (Customer ID) references Customer
FK (Video ID, Copy Serial Number) references VideoCopy