See Attachment:

Prepare an ER diagram for the database described below (using crows foot notation). Be sure to identify all required entities,
attributes, and relationships (including cardinalities). State any assumptions you make, and indicate a primary key for each entity.

Assignment 2 - COP3703“One-Punch Anime Shop”One-Punch Anime Shop (20 pts)Prepare an ER diagram for the database described below (using crows foot notation). Be sure to identify all required entities,attributes, and relationships (including cardinalities). State any assumptions you make, and indicate a primary key for each entity.Mel Smith, the manager of the One-Punch Anime Shop wants you to design a database system that will enable a number of tasks. Oneproblem that Mel has is keeping track of inventory. Several times a week the store receives shipments from various vendors. Melwould like a system that can record these shipments. Most of the shipment information originates with an order to the vendor. Melcurrently records order information on an order form, which is shown below, along with the form currently used to record inventory.When shipments arrive, Mel wants the system to indicate that the order has been received. More importantly, Mel needs the system toupdate the store inventory. The system should also record basic information about each vendor, including their name, address, phonenumber, and a main contact name.Keeping track of inventory is a major headache for him under the current manual system. He's hoping that the new database can help.In order to track inventory, the system must also record sales to customers. The current sales form is provided below. When a sale ismade, the system must adjust the inventory to reflect the books included in the sale.ORDER FORMOrder No.:12548Date:1/15/15Vendor ID:87459Name:Japan ArtsAddress100 Newark Ave.Newark, CA94538Item-IDTitleQuantityCostExtended125807652Anime Key Chains - various1003.00300.00189765409Anime Posters–various508.00400.00143768431Anime Plush Dolls2010.25205.00TOTAL COST905.00INVENTORY RECORDISBNTitleQuantityOn handQuantityOn order125807652Anime Key Chains - various47100189765409Anime Posters–various3350143768431Anime Plush Dolls1520SALES FORMInvoice No:55897Customer No.:2589Date:12/22/15Name:Jose ThomasAddress:8057 Mills Ave.Orlando, FL32883ISBNTitleQuantityPriceExtended125807652SAO Key Chain26.0012.00189765409SAO Large Poster118.0018.00143768431One-Punch Plush122.0022.00TOTAL52.00

• 1496365128-Pg1 Lab2-Updated-May-2016-1.pdf

ComputerScienceExpert

(11)

Status NEW Posted 02 Jun 2017 12:06 AM My Price 8.00

-----------

Attachments

file 1496365130-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer