Assignment task: The Canberra Fitness Centre (CFC) has several branches and staff members with a large number of customers in Canberra. Each staff member may work in one or more branches at Canberra Fitness Centre (CFC). The Canberra Fitness Centre (CFC) has 3 branches in Canberra. The current design of the Canberra Fitness Centre (CFC) database allows each staff member to have one telephone number, one position, and be assigned to one branch only. The staff and branch entities and their attributes of the current Canberra Fitness Centre (CFC) database are as follows:
Staff (StaffID (PK), FirstName, LastName, Position, Sex, DateofBirth, TelNumber, BranchID)
Branch (BranchID (PK), Location, TelNumber)
Redesign the staff and branch entities above by adding new entities as required to allow each staff member to have several telephone numbers and to be assigned to have more than one position and to be assigned more than one branch in Canberra Fitness Centre (CFC). (Hint: You may like to create new entities.)