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. One problem that Mel has is keeping track of inventory. Several times a week the store receives shipments from various vendors. Mel would like a system that can record these shipments. Most of the shipment information originates with an order to the vendor. Mel currently 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 to update the store inventory. The system should also record basic information about each vendor, including their name, address, phone number, 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 is made, the system must adjust the inventory to reflect the books included in the sale.

ORDER FORM Order No12548 Vendor ID 87459 Name: Address Date: 1/15/15 Japan Arts 100 Newark Ave. Newark, CA 94538 125807652Anime Key Chains. various Quantity Cost Extended 3.00 8.00 10.25 Item-ID Title 100 50 20 300.00 400.00 205.00 905.00 189765409 143768431 Anime Posters- various Anime Plush Dolls TOTAL COST INVENTORY RECORD ISBN Quantity On hand 47 Quantity On order 100 50 20 Title 125807652 189765409 143768431 Anime Key Chains-various Anime Posters- various Anime Plush Dolls SALES FORM Invoice No: Customer No.: 2589 Name: Address: 55897 Date: 12/22/15 Jose Thormas 8057 Mills Ave. Orlando, FL 32883 Quantity Price ISBN 125807652 189765409 143768431 Title SAO Key Chain SAO Large Poster One-Punch Plush TOTAL Extended 6.00 18.00 22.00 12.00 18.00 22.00 52.00