Sterile Reports Research Example ERD Problem
Sterile Reports Research Example ERD Problem
Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information. Remember the ERD will eventually turn into the design for a
Please use a drawing tool of some type to show the ERD diagram (Word, PowerPoint, and Visio all work well). I want you to get in the habit of drawing these with a computer instead of by hand, as this will be important as we get to more difficult examples. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality.
Sterile Reports Research Example
The Sterile Reports Research Company conducts a number of research projects each year. Each project is carried out by a team of employees from different departments. However, all projects are complex and have to be broken into a number of manageable assignments. It is to an assignment that an employee is assigned. Most projects are carried out for a single customer, but some are financed by a group of customers. At any one time, a customer may have several projects under way. An employee may be working on more than one project or assignment at once. At any given time, the company needs to be able to produce reports showing which employees are working on which projects, the departmental staff commitments to a particular project, and the expected finish dates of projects being carried out for a particular customer.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
