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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

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

Post by answerhappygod »

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.)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply