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:
Staff(StaffID, FirstName, LastName,
Position, Sex, DateofBirth, 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.)
The Magic Fitness Centre (MFC) has several staff members. Each staff member may work in one or more sections of Magic Fi
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am