Draw an entity relationship diagram

Assignment Help Database Management System

Reference no: EM13812476

1. 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: EM13812476

Questions Cloud

The part of theology that is technically known as theodicy : the part of theology that is technically known as theodicy

Examples of inventory control systems : The warehouse manager and his staff have been very impressed with your presentation thus far. They are very interested in applying more of your recommendations to their department. They have asked for you to provide them with a few examples of inv..

Future of qualified plan influence : Discuss the importance of qualified plans and the economic and societal importance of these plans. Further, discuss how the decline of specific defined benefit plans has altered the retirement landscape and the influence this will have on future reti..

Examine the duration and convexity of three bond issuances : Examine the duration and convexity of three bond issuances. Determine how sensitive the bond valuations are to changes in interest rates. Value the bonds if interest rates rise, fall, or remain unchanged.

Draw an entity relationship diagram : 1. 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 da..

Determine a proper control chart. : Determine a proper control chart. Use a spreadsheet to calculate the upper and lowercontrol limits for the control chart and draw it. Suppose that the next carpet sample of100 yards has 14 flaws. What can you say about the process?

Bar-codescanners and conveyors to facilitate finding : Managing an order processing facility where employees pick the customer ordersfrom the warehouse, package, and deliver them to postal services. There are bar-codescanners and conveyors to facilitate finding and moving items through the facility.Deliv..

Corporations and limited liability companies : Explain in detail the advantages vs. disadvantages of: sole proprietorship, general and limited partnerships, limited liability partners, corporations and limited liability companies.

Write a term paper about ralph lauren : Write a term paper about Ralph Lauren.

User Account

All Pages