Consider the following case for Aramco Company given the following Scenario:
A company has a number of employees. The attributes of EMPLOYEE include Employee ID (identifier), Name, Address. An employee can have more than one address at a time. The company also has 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 to it, and may have any number of employees assigned. For each project, there is always one employee assigned to manage that project. 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.
a) Clearly identified all the entities with their relevant attributes.
b) Create a relationship among the entities and specify the cardinality Ration
c) Draw an E-R diagram for a Company
d) Draw the corresponding EER diagram.
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount