2. The Magic Fitness Centre (MFC) has several staff members. Each staff member may work in one or more sections of Magic

[answerhappygod]

2 The Magic Fitness Centre Mfc Has Several Staff Members Each Staff Member May Work In One Or More Sections Of Magic 1 (36.05 KiB) Viewed 51 times

2. The Magic Fitness Centre (MFC) has several staff members. Each staff member may work in one or more sections of Magic Fitness Centre (MFC). The Magic Fitness Centre (MFC) has 3 sections. The current design of the Magic Fitness Centre (MFC) database allows each staff member to be assigned to one position and one section only. The staff and section entities and their attributes of the current Magic Fitness Centre (MFC) database are as follows: Position, Sex, DateofBirth, Staff(StaffID, FirstName, LastName, TelNumber, SectionID) Section(SectionID, SectionName, Location, TelNumber) Redesign the staff and section entities by adding new entities as required to allow each staff member to be assigned to more than one position and more than one section in Magic Fitness Centre (MFC). (Hint: You may like to create new entities.)