Draw an entity relationship diagram

Assignment Help Database Management System

Reference no: EM13806592

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: EM13806592

Questions Cloud

Developing the software development plan : The final step in developing the software development plan is to conduct a risk assessment for the project. This is an area often overlooked in software development plans, but it can make a tremendous difference in the success of the plan

Determination of the reliability of the system : Determine the level of reliability required for each of the components if the engine is to have a reliability of 0.998.

Terrorism is defined by different people within vacillating : According to Alex Schmid, terrorism is defined by different people within vacillating social and political realities.

Discuss the value of hydration : Water: An Overlooked Essential Nutrient. A law firm has requested that you introduce yourself, explain why you are at the firm, and discuss the value of hydration.

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

The standard deviation of the waiting time : What percent of the patrons wait for more than 2 minute?

Interactions of members and increase productivity : Working with organizations to improve the interactions of members and increase productivity through collaborative behavior is an essential role of the organization development human resources specialist. You will need to pick an organization to us..

The variables of a regression analysis : What are the variables of a regression analysis, and how do they affect the results of the analysis?

Supplier for a medium-sized housewares company : Blanton Reeve is a supplier for a medium-sized housewares company. Jerry, the newly hired procurement manager for the housewares company, studied all of the files for information on all of the current suppliers.

User Account

All Pages