Creating ERD’s for "One-Punch Anime Shop" and "Florida Now Real Estate" One-Punch Anime Shop (30 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 No: 12548 date: 1/15/15
Vendor ID: 87459
Name: Japan Arts
Address 100 newark Ave.
Newark. CA 94538
Item-ID Title Quantity Cost Extended
125807652 Animal Key Chains-various 100 3.00 300.00
189765409 Animal Poster-various 50 8.00 400.00
143768431 Animal Plush Dolls 20 10.25 205.00
TOTAL COST 905.00
INVENTORY RECORD
ISBN Title Quantity on hand
Quantity on order
125807652 Animal Key Chains-various 47 100
189765409 Animal Poster-various 33 50
143768431 Animal Plush Dolls 15 20
SALES FORM
Invoice No: 55897
Customer No: 2589 Date:12/22/15
Name: Jose Thomas
Address: 8057 Mills Ave. Orlando, FL 32883
ISBN Title Quantity Price Extended
125807652 SAO Key Chain 2 6.00 12.00
189765409 SAO Large Poster 1 18.00 18.00
143768431 One-Punch Plush 1 22.00 22.00
TOTAL 52.00