3) Consider the following relational database to track video streaming content. The schemas (with primary key attributes underlined for the first two relations) are: Customer-schema = (cust_id, lifetime_salary) Movie-schema = (movie id, movie_name, genre) Views-schema = (cust_id, movie_id, view_date) a) (5 points) Suppose that a customer is only allowed to watch a movie one time. What candidate keys would the Views-schema have? b) (5 points) Suppose that a movie is only allowed to watched by one customer. What candidate keys would the Views-schema have? c) (20 points) Suppose that we only allow customers to watch a movie one time per day. In addition, a movie can be viewed by multiple customers. Draw a schema diagram for this database. Be sure to indicate all foreign keys implied by the attribute names and primary keys in the relation schemas