Sketch an entity relationship diagram erd for the given

Assignment Help Other Subject

Reference no: EM13463339

Draw an entity relationship diagram (ERD) for the following situation:

A company has a number of employees. Each employee is identified by an Employee_Id. The company wants to store Employee_Name, Employee_Address, and Employee_BirthDate in the database. The company also has several projects. Each project is identified by a Project_Id. The company wants to store Project_Name and Project_StartDate in the database. Each employee must be assigned to one or more projects, or may not be assigned to a project. A project must have at least one employee assigned and may have any number of employees assigned. An employee's billing rate may vary by project, and the company wishes to record the applicable billing rate (Billing_Rate) for each employee when assigned to a particular project.

Reference no: EM13463339

Questions Cloud

Sate and explain the following terms prejudice stereotype : define and describe the following terms prejudice stereotype discrimination and ingroup vs. outgroup. based on your own

He intends to use the computer for word processing e-mail : your friend ron has asked for your help in buying a home computer. he is skeptical of ads for computers that cost less

Women are frequently frowned upon if they choose younger : according to buss 1995 most men tend to prefer women who are younger due to their innate drive to reproduce. on the

Create a chart which demonstrates how sociological : generate a chart that demonstrates how the sociological environment influences the physical and mental health of

Sketch an entity relationship diagram erd for the given : draw an entity relationship diagram erd for the following situationa company has a number of employees. each employee

In what manners has this group contributed to rendering : sultz and young 2011 describe the various stakeholders in the u.s. health care system. choose one of these stakeholders

Analyze how ethics affect psychological knowledge and : completenbspthe ethics awareness inventory located on the student website.preparenbspa 700- to 1050-word summary of the

Explain some of pros and cons of this technology and : health and medical technologies available to both health care providers and administrators continue to advance rapidly.

How might technology be involved or effect the social : answer the following questions regarding social changebullhow do you think life in the united states will change in the

User Account

All Pages