4754
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: 874559 Name: 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
Please show me how to make ERD diagram By:using crows foot notation &identify all required entities attributes, relationships (including cardinalities) and indicate a primary key for each entity.
Thanks
