ERD for each of the following situations. Clearly state any additional assumption(s) for each of the situation: AIT Inc with Prof. Dzidonu as the President has a number of employees. The attributes of the EMPLOYEE include Employee_ID (identifier), Name, Address and Birthdate. The company has also several projects. Attributes of PROJECT include Project_ID,
Draw ERD for each of the following situations. Clearly state any additional
assumption(s) for each of the situation:
AIT Inc with Prof. Dzidonu as the President has a number of employees. The
attributes of the EMPLOYEE include Employee_ID (identifier), Name, Address
and Birthdate. The company has also several projects. Attributes of PROJECT
include Project_ID, (Identifier), Project_Name and Start_Date.
Each Employee may 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.
Do the attribute names in this description follow the guidelines for naming
attributes? If not, suggest better names
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
