Question: Prepare an ER model, the ER model should have entities, attributes and relations and the database design should have primary and foreign keys. Comment on

Prepare an ER model, the ER model should have entities, attributes and relations and the database design should have primary and foreign keys. Comment on what normal form your database is in. If you make any assumptions, then write them below the models.

ABC Consulting is a small-sized consulting firm in the IT industry. ABCs business is managing several Systems Development projects by assigning staff consultants to these projects as their skills are needed. Each employee is designated to have one primary skill, but there may be other employees with the same primary skill. A consultant may work on one or more projects or may not yet be assigned to a project. The company charges for each project by billing each consultant's hours worked by the billing rate. The hourly billing rate is dependent on the employees primary job skill.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!