Question: Based on the case below, draw an ERD using Chen s notation with cardinality and participation. ( You can use multivalued attribute symbols. ) Submit

Based on the case below, draw an ERD using Chens notation with cardinality and participation. (You can use multivalued attribute symbols.) Submit your Visio/drawio (.vsdx/.drawio) file (other file types are not accepted).
Nirmala Gandhi is the HR manager at Felix Partners (FP), a law firm. She asked you to design a database to manage FPs employees, who are classified as either staff, managers, or partners. Each employee has a unique 4-digit employee ID. FP wants to record full name (first name, MI, last name), phone numbers, home address, and email addresses. FP also wants to keep track of who is the supervisor of an employee.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!