Hi, I could use help on making ERD's for this problem. It needs to be crows-foot notation. It must have entities, attributes, relationships, cardinalities, primary keys, and foreign keys. Please break this down so I can make sure I understand. Here is the description: Marsha Mobley, the manager of the ACME Anime Shop wants you to design a database system that will enable a number of tasks. One problem that Marsha has is keeping track of inventory. Several times a week the store receives shipments from various vendors. Marsha would like a system that can record these shipments. Most of the shipment information originates with an order to the vendor.Marsha currently records order information on an order form, which is shown below, along with the form currently used to record inventory. When shipments arrive, Marsha wants the system to indicate that the order has been received. More importantly, Marsha 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. 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 items included in the sale. You will need to determine the tables needed (like CUSTOMER, SALES, etc.) and then how the tables are related and their cardinality.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Hi, I could use help on making ERD's for this problem. It needs to be crows-foot notation. It must have entities, attributes, relationships, cardinalities, primary keys, and foreign keys. Please break this down so I can make sure I understand.

Here is the description:

Marsha Mobley, the manager of the ACME Anime Shop wants you to design a database system that will enable a number of tasks. One problem that Marsha has is keeping track of inventory. Several times a week the store receives shipments from various vendors.
Marsha would like a system that can record these shipments. Most of the shipment information originates with an order to the vendor.Marsha currently records order information on an order form, which is shown below, along with the form currently used to record inventory. When shipments arrive, Marsha wants the system to indicate that the order has been received.

More importantly, Marsha
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. 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 items included in the sale. You will need to determine the tables needed (like CUSTOMER, SALES, etc.) and then how the tables are related and their cardinality.