Question: You are designing a database for a staff management system for an organisation. The organisation has a number of departments. Each department manages a number
You are designing a database for a staff management system for an organisation. The organisation has a number of departments. Each department manages a number of projects and has a number of staff members. Each staff member has a name, a unique staff ID a date of birth, and a contact phone number. Staff work for a department and are assigned to work on projects. Each project has a name which does not have to be unique, and a single staff member who acts as project leader. Multiple staff can work on a single project, and each staff member can be working on any number of projects.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
