Week 3 Homework - Entity Relationship Diagram

Draw an Entity Relationship Diagram complete with keys and attributes for Miller Consulting based on the following information.

Jim Miller currently runs a one-person consulting company and serves three clients. He sends an invoice at the end of the month to any client where work has been performed during the month. Clients usually pay within 30 to 45 days. Each client is billed at a different hourly rate. One of the existing clients wants Miller Consulting to do more work and has suggested that Miller Consulting hire staff to perform the additional work.

Miller Consulting has decided to build a system to keep track of Clients, Projects, Staff and Invoices. Both Clients and Staff have address information. Miller Consulting can be doing zero, one or more Projects for a Client at any given time. A Project belongs to one and only one Client. Each active Client will continue to be invoiced at the end of the month.

Staff may be working on zero, one, or more Projects. The Staff Person's hourly billing rate varies from Project to Project. (Hint: Billing Rate does not belong to either the Staff Entity or the Project Entity.) A Project must have at least one Staff Person assigned to it. When a Staff Person is assigned to a Project, the start date and estimated end date of that assignment are known. Miller Consulting wants to keep track of Skills for each Staff Person. A Staff Person may have zero, one, or more skills. Each Skill has a name (Analyst, Data Base Designer, and PHP Programmer) and a level (Beginning, Intermediate, and Advanced).

Scope Control: You can ignore invoices for this exercise. You can draw this diagram with any tool including Microsoft Word or pencil and paper. If you use pencil and paper, it is your job to scan your paper into a computer and then cut and paste your picture onto this assignment. If your diagramming tool allows you to cut and paste diagrams, you can paste your diagram below. If it does not allow this, attach the file from your CASE tool to the assignment and provide me with the URL of your case tool so I can read your file.