Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an ER diagram for the following An email from your project liason at Warehouse 13 is given below. Our company, Warehouse 13, has several

Create an ER diagram for the following

An email from your project liason at Warehouse 13 is given below.

Our company, Warehouse 13, has several warehouses. Each warehouse is designated by a unique 4-letter code. Each warehouse has several bins that are identified by numbers, i.e., each warehouse has bins 0, 1, 2, 3, and so on. Each bin has a particular capacity. Bins store part instances (also called items). An item has a part type.

Items arrive in batches. All items in a batch will be of the same part type. Each batch has a unique batch number and arrives on a particular date. Each batch has a size, i.e., the number of items in the batch. All items from the same batch are stored together in the same bin (no batch is stored in more than 1 bin). Each item in a batch is uniquely identified by an part type number, a batch number, and an item number, e.g., part 1001/batch 27/item 1 or part 2567/batch 23/item 1. When a batch arrives, its date-in is recorded. A particular manager checks its arrival, and this fact should be recorded in the database.

Some part types may be backordered. A part type can be backordered only by a manager. The manager, the date of the backorder, and also the quantity backordered are recorded. When a backorder shipment arrives, the backorders remaining quantity is updated (the number of items arrived is subtracted from the remaining quantity), and if it is less than or equal to 0, the backorder is deleted. There may be only a single current (active) backorder for any part types.

When an item is shipped out of the warehouse, its date-out is recorded together with the manager who checked its shipping.

Each manager has a unique employee number, 0 or more phone number(s), name(s) (first name, middle name, and last name), 1 or more addresses (street number, street name, city name, and a 2-character state abbreviation).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administration The Complete Guide To Dba Practices And Procedures

Authors: Craig S. Mullins

2nd Edition

0321822943, 978-0321822949

More Books

Students also viewed these Databases questions

Question

b. Explain how you initially felt about the communication.

Answered: 1 week ago