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 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
Get step-by-step solutions from verified subject matter experts
