re 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 billi
A company has a number of employees. Each employee is identified by an Emplyee_Id. The company
wants to store Employee_Name, Employee_Address, and Employee_BirthDate in 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.
Draw an entity relationship diagram (ERD) using crows foot notation for the following situation. Show visible analyst.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images