Reference no: EM13307092

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.

Jane Hemingway, the manager of the Ye Ole bookstore wants you to design a database system that will enable a number of tasks. One problem that Jane has is keeping track of inventory. Several times a week the store receives shipments from various vendors. Jane would like a system that can record these shipments. Most of the shipment information originates with an order to the vendor. Jane currently records order information on an order form, which is shown below, along with the form currently used to record inventory.

When shipments arrive, Jane wants the system to indicate that the order has been received. More importantly, Jane 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 her under the current manual system. She'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.

Attachment:- Practice Exercise 2.pdf