Video Shop is movie DVD rental store. It must maintain data on the DVDs that it has for rent, the movies that are titles and customer numbers are also unique identifiers. Assume that each movie has exactly one star. Note the difference in the year that the movie was originally filmed as opposed to the date that a DVD - an actual disk - was manufactured. The relation VideoShop is a 1NF relation. VideoShop (DVDNo, ManufactureDate, MovieTitle, Star, YearFilmed, MovieLength, CustomerNo, CustomerName, CustomerAddress, RentalDate, ReturnDate, FeePaid) Its functional dependencies are stated below: DVDNo ->MovieTitle, Star, ManufactureDate, Movielength, YearFilmed MovieTitle-> Star, MovieLength, YearFilmed CustomerNo-> CustomerName, CustomerAddress DVDNo, CustomerNo, Rental Date->ReturnDate, FeePaid (1) Please identify the primary key of the relation VideoShop. (3 points) (2) Decompose VideoShop into a set of 3NF relations. Please state the fimctional dependencies to justif decomposition and identify the primary, foreign keys in each step of the decomposition