Question: Mini Case (MC) 1 @ 35 points Please develop an Entity-Relationship Diagram (ERD) for mini case below. Please use ERD plus to develop your ERD.

 Mini Case (MC) 1 @ 35 points Please develop an Entity-Relationship

Mini Case (MC) 1 @ 35 points Please develop an Entity-Relationship Diagram (ERD) for mini case below. Please use ERD plus to develop your ERD. Please label your final work as PRJI_MC1_YourLast FirstName and submit your finalized ER diagrams via the PRJI assignment either as a .png file. Advance Science Incorporated is a science and technology company. Create the ER diagram for the Advance Science Inc. Database, based on the following requirements. The Advance Science Incorporated Database will keep track of employees, facilities, and devices. For each employee, Advance Science Incorporated will keep track of a unique employee identifier as well as his or her name. For each facility, Advance Science Incorporated will keep track of a unique facility identifier as well as the facility type. For each device, Advance Science Incorporated will keep track of a unique device identifier as well as the device type. Each employee can access one or more facilities. Each facility can be accessed by one or more employees. Each device is issued to exactly one employee. Each employee can have between zero and many devices issued to him or her

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!