We are constructing the following system. For each relation, specify what should be used as the primary key or keys.
An On-Demand Online Video Streaming Database. That has a relation called Videos with the following attributes: name, duration,
age_rating, category, year, and episode_number.
Primary Key: episode_number
A user view history relation called Views with the following attributes: user_id, video, rating, date.
Primary Key:
user_id
A relation that stores the information about the devices that each user has connected to the service called Devices. Devices has
the following attributes: user_id, device_id, device_name, device_ip, and device_type.
Primary Key:
device_id is a primary key and we can have user_id, device_name and devic_ip a
