Perform normalization to the following relations. Mark primary keys and foreign keys accordingly. Follow the steps as required. (1) MOVIE(Title, Year, Length, Genre, StudioName, StarName, StudioPresident, Studio PresidentAddress) Assumpations: Same title may be produced in another years again. A movie may have more than one stars. (2) EMPLOYEE(Employeeld, EmployeeName, Department, DepartmentManager, Date, ProjectID, ProjectName, Hours WorkedFor Project, ProjectHourlyRate) Assumption: An employee may be assigned to work for different projects at one day