A relational database is to be designed for a medium sized Company dealing with industrial applications of computers. The Company delivers various products to its customers ranging from a single application program through to complete installation of hardware with customized software. The Company employs various experts, consultants and supporting staff. All personnel are employed on longt erm basis, i.e. there is no short‐term or temporary staff. Although the Company is somehow structured for administrative purposes (that is, it is divided into departments headed by department managers) all projects are carried out in an inter‐disciplinary way. For each project a project team is selected, grouping employees from different departments, and a Project Manager (also an employee of the Company) is appointed who is entirely and exclusively responsible for the control of the project, quite independently of the Company's hierarchy. The following is a brief statement of some facts and policies adopted by the Company.
A relational
erm basis, i.e. there is no short‐term or temporary staff. Although the Company is somehow structured for administrative purposes (that is, it is divided into departments headed by department managers) all projects are carried out in an inter‐disciplinary way. For each project a project team is selected, grouping employees from different departments, and a Project Manager (also an employee of the Company) is appointed who is entirely and exclusively responsible for the control of the project, quite independently of the Company's hierarchy. The following is a brief statement of some facts and policies adopted by the Company.
- Each employee works in some department.
- An employee may possess a number of skills
- Every manager (including the MD) is an employee
- A department may participate in none/one/many projects.
- At least one department participates in a project.
- An employee may be engaged in none/one/many projects
- Project teams consist of at least one member.
For the above business stories you are expected to create the following.
- Analyze the data required.
- Normalize the attributes.
- Create the logical data model (ER diagrams).
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 2 images
