The following ERD is for a simplified video store environment. CUSTOMER Customer_Name{pk} Name(FirstN, M, LastN) DOB [TotalAmount] Customer Type Rents Check OutDate Due_Date [Amount_Paid) Role FILM COPY ACTOR --Carries ----- #performed by -O Copy_No {partial identifier} Current_Condition [No_of_CheckOut] FID{pk) Title Rate Category {Directors) SSN{pk) Name *COPY entity has a partial identifier (Copy.no) 1. Transform the diagram on the previous page into a relational model. All the relations in the relational model should be in the third normal form. Show primary keys, referential integrity constraints, and functional dependencies, as appropriate. 2. The following two changes are made to the Film entity in the ERD (Other parts of the ERD remain the same). Revise your transformed relation (Film) and it should be in the third normal form. Show referential integrity constraints, and functional dependencies as appropriate: 1) A new attribute , SHOW-TIME, is added to Film to describe the time period in which a film can be played. 2) The following new functional dependency holds: CATEGORY SHOW_TIME