Prepare an ER diagram for the database described below (using crows-foot notation). Be sure to identify...

Transcribed Image Text:

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. Marsha Mobley, the manager of the ACME Anime Shop wants you to design a database system that will enable a number of t One problem that Marsha has is keeping track of inventory. Several times a week the store receives shipments from various ven: Marsha would like a system that can record these shipments. Most of the shipment information originates with an order to the ven Marsha currently records order information on an order form, which is shown below, along with the form currently used to re inventory. When shipments arrive, Marsha wants the system to indicate that the order has been received. More importantly, Ma needs the system to update the store inventory. The system should also record basic information about each vendor, including 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? To track inventory, the system must also record sales to customers. The current sales form is provided below. When a sale is made system must adjust the inventory to reflect the items included in the sale. You will need to determine the tables needed o CUSTOMER, SALES, etc.) and then how the tables are related and their cardinality. ORDER FORM Order No.: 98761 Vendor ID: 87459 Name: Address Item-ID 125807652 189765409 143768431 125807652 189765409 143768431 INVENTORY RECORD Item-ID SALES FORM Invoice No: Aito Arts 100 Newark Ave. Newark, CA 94538 Customer No.: Customer Name: Address: Item-ID 125807652 189765409 Title Anime Key Chains - various Anime Posters-various Anime Plush Dolls TOTAL COST Title Date: 1/15/19 Anime Key Chains - various Anime Posters-various Anime Plush Dolls 55897 2589 Alicia Thomas 8057 Mills Ave. Orlando, FL 32883 Title SAO Key Chain SAO Large Poster Date: 12/22/18 Quantity 100 50 20 Quantity 2 1 Cost 3.00 8.00 10.25 Quantity On hand 47 33 15 Price 6.00 18.00 Extended 300.00 400.00 205.00 905.00 Quantity On order 100 50 20 Extended 12.00 18.00 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. Marsha Mobley, the manager of the ACME Anime Shop wants you to design a database system that will enable a number of t One problem that Marsha has is keeping track of inventory. Several times a week the store receives shipments from various ven: Marsha would like a system that can record these shipments. Most of the shipment information originates with an order to the ven Marsha currently records order information on an order form, which is shown below, along with the form currently used to re inventory. When shipments arrive, Marsha wants the system to indicate that the order has been received. More importantly, Ma needs the system to update the store inventory. The system should also record basic information about each vendor, including 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? To track inventory, the system must also record sales to customers. The current sales form is provided below. When a sale is made system must adjust the inventory to reflect the items included in the sale. You will need to determine the tables needed o CUSTOMER, SALES, etc.) and then how the tables are related and their cardinality. ORDER FORM Order No.: 98761 Vendor ID: 87459 Name: Address Item-ID 125807652 189765409 143768431 125807652 189765409 143768431 INVENTORY RECORD Item-ID SALES FORM Invoice No: Aito Arts 100 Newark Ave. Newark, CA 94538 Customer No.: Customer Name: Address: Item-ID 125807652 189765409 Title Anime Key Chains - various Anime Posters-various Anime Plush Dolls TOTAL COST Title Date: 1/15/19 Anime Key Chains - various Anime Posters-various Anime Plush Dolls 55897 2589 Alicia Thomas 8057 Mills Ave. Orlando, FL 32883 Title SAO Key Chain SAO Large Poster Date: 12/22/18 Quantity 100 50 20 Quantity 2 1 Cost 3.00 8.00 10.25 Quantity On hand 47 33 15 Price 6.00 18.00 Extended 300.00 400.00 205.00 905.00 Quantity On order 100 50 20 Extended 12.00 18.00

Answer rating: 100% (QA)

Entities and Attributes Vendor Represents the vendors supplying products to the store Attributes inc... View the full answer