Assignment 2 - Entity Relationship Digagram

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 my have zero, one, or more skills. Each Skill has a name (Analyst, Data Base Designer, PHP Programmer) and a level (Beginning, Intermediate, Advanced).