Question: Create database models utilizing E-R Diagrams. Conceptual Pretend University (CPU) is a public university located within the state of Georgia. CPU has recently discovered that

Create database models utilizing E-R Diagrams. Create database models utilizing E-R Diagrams.Create database models utilizing E-R Diagrams.

Conceptual Pretend University (CPU) is a public university located within the state of Georgia. CPU has recently discovered that there is a need to track various types of computer viruses. In order to address this issue, CPU plans on constructing a new database system. CPU currently has 5,000 employees. Ideally, the database system will provide IT employees to enter potential viruses into a "Potential Virus" column. However, only Information Security staff will be allowed to enter information into the "Confirmed Virus" column. While employees outside of Information Security would be responsible for reporting anything that looks suspicious, Information Security staff would be responsible for both reporting potential viruses and confirming potential viruses. To facilitate tracking each potential virus will possess a unique "Potential Virus ID" (Potvir|D). This project will be completed using Microsoft Access. Entity-Relationship Diagram [The ERD should show all entities, relationships between entities and cardinality including mandatory-optional requirements.] STORE Store SK StoreName City Country Phone Fax Email Contact PURCHASE PurchaseSK Date ok Description Category PriceUSD SHIPMENT ITEM InsuredValue SHIPPER ShipperName Phone Fax Email Contact SHIPMENT ShipmentSK ShipDate Ok ShipperinvoiceNumber Origin Destination Conceptual Pretend University (CPU) is a public university located within the state of Georgia. CPU has recently discovered that there is a need to track various types of computer viruses. In order to address this issue, CPU plans on constructing a new database system. CPU currently has 5,000 employees. Ideally, the database system will provide IT employees to enter potential viruses into a "Potential Virus" column. However, only Information Security staff will be allowed to enter information into the "Confirmed Virus" column. While employees outside of Information Security would be responsible for reporting anything that looks suspicious, Information Security staff would be responsible for both reporting potential viruses and confirming potential viruses. To facilitate tracking each potential virus will possess a unique "Potential Virus ID" (Potvir|D). This project will be completed using Microsoft Access. Entity-Relationship Diagram [The ERD should show all entities, relationships between entities and cardinality including mandatory-optional requirements.] STORE Store SK StoreName City Country Phone Fax Email Contact PURCHASE PurchaseSK Date ok Description Category PriceUSD SHIPMENT ITEM InsuredValue SHIPPER ShipperName Phone Fax Email Contact SHIPMENT ShipmentSK ShipDate Ok ShipperinvoiceNumber Origin Destination

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 General Management Questions!