Question: Create one E-R diagram for the 3 entities given below, with attributes (given in a simplified manner): (1) CONSULTANT - SSN, Name, Specialty (single valued),

Create one E-R diagram for the 3 entities given below, with attributes (given in a simplified manner): (1) CONSULTANT - SSN, Name, Specialty (single valued), Certificate (single valued) (2) CLIENT - TIN (tax ID number), Name, SIC (standard industry code) (3) PROJECT - Name, Type (single valued) - Note: it is a generic type such as "ERP installation" that can be performed for any client. [I.e., not "ERP installation for CSUN" but just "ERP installation" in general] The ERD needs to keep track of the start and end dates of a consultant working in a type of project for a client. Write any business rules that help to clarify your construction of the ERD. The general scenario is that an individual consultant can work on multiple projects, a client (company) can have multiple projects going on, and a project can have multiple consultants working on it, possibly with different start and end dates. If there needs to be any associative entity, create as your logic supports (and please state your reasoning, possibly with the support of citation of the text), and correctly indicate the entity's attributes

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 Accounting Questions!

CMS Project Phase I Instructions Part A: Background Information: CMS Systems, Inc. is a company that provides information systems consulting services to companies in the telecom industry in the...

Part A: Background Information: CMS Systems, Inc. is a company that provides information systems consulting services to companies in the telecom industry in the United States and the United Kingdom....

CMS Systems, Inc. is a company that provides information systems consulting services to companies in the telecom industry in the United States and the United Kingdom. Due to its success, CMS is...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Database design and technology As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU is...

DBMS Question. 1. 6+4 = 10 Suppose you are appointed as a database designer for COVID-19 vaccination project. You have to design the overall database of the registration system with application...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

need answer for these questions 13, 17, 19, 20, and 23? PART 5 Business Valuations Chapter Business Valuations A valuation analyst should be able to explain and defend his or her valuation, including...

need answers for questions 13, 17, 19, 20, and 23? PART 5 Business Valuations Chapter Business Valuations A valuation analyst should be able to explain and defend his or her valuation, including both...

Sharp Company manufactures a product for which the following standards have been set: Standard Quantity or Hours Standard Price or Rate Standard Cost Direct materials 3 feet $ 5 per foot $ 15 Direct...

For problems 20, fill in the missing amount. Work-in-process inventory, September 1 ........ 5,500 tons Work-in-process inventory, September 30 ...... 3,400 tons Units started during September...

When determining a firmi's weighod average cost of capital ( WNCC ) which of the following terms is NOT necessary? A . the firmis weight of debt financing B . The risk - tree rate of peturn C . the...

4 5 7 8 Irish Pub Staffing Total number of servers Revenue @ $600 per server $ 2,400.00 Wages @$96.00 per server $ 384.00 Beverage Cost @ 25% $ 600.00 Revenue remaining after wages and beverage costs...