Question: Based on the information below, what is the correct way to normalize the Facility relation to 3 NF? We assume that one facility is in
Based on the information below, what is the correct way to normalize the Facility relation to 3 NF? We assume that one facility is in one gym, and a gym may have multiple facilities. Facility (FacilityID, BookValue, GymID, GymLocation, FacilityType, GymManager) FD: GymID GymLocation, GymManager A) Facility (Facility!D, BookValue, FacilityType) Gym (GymID, GymLocation, GymManager, FacilityID) Foreign Key: FacilityID references Facility B) Facility 2 acilityID, BookValue, FacilityType) Gym (GymlD, GymLocation, GymManager) C) Facility (FacilityID, BookValue, GymID, FacilityType) Foreign Key: GymID references Gym Gym GymID, GymLocation, GymManager, FacilityID) Foreign Key: FacilityID references Facility D) Facility (FacilityID, BookValue, GymID, Facilitytype) Foreign Key: GymID references Gym Gym (GymID, GymLocation, GymManager)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
