Consider the following case for Aramco Company given the following Scenario:
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
