Words: 336
his database will be used to track problems linens are having and the consultants who are working on them. Each client can have many problems and many clients can be facing the same problems. Each time a client reports a problem you want to track the client, what their problem is, the consultant who is working on it and the date it was logged into the system, its status and the date the problem was solved (note this is blank for pending problems). Consultants also work on many problems at any given time. For each type of problem there is one consultant who is considered the expert on this problem.
A consultant can be an expert on many different types of problems. Assuming constraints are not exact Question 4 Create an ERE diagram for the following case. Write your assumptions about any missing information: You want to track information about 10 departments in your company. Each department has a unique name, is located on a specific floor and has a phone number. Within each department there is a department head and a range of additional employees. For all employees we want to track their name, who their boss is, their salary as well as the unique employee number each had assigned to them when they started the company.
Each employee also has a set of skills. You need to track this set of skills so you can locate employees with the right skill set to be part of various cross department project teams. You need to also track information about all of the projects that are under taken by these various departments. Each project has a unique id, a name, a start date, and at least 3 employees on it. All teams have a project leader and a project coordinator. Any employee can be a project leader but they can only lead one project. Furthermore any employee can be a project coordinator and they can coordinate any number of projects.