Attributes with cardinality descriptions The company keeps track of each warehouse, inventory bin, product, receiving department, shipping department, supplier, customer, courier service. For each warehouse a unique warehouse ID, warehouse address, number of warehouse levels are recorded. For each inventory bin a unique bin ID, floor number, column ID, and shelf ID are recorded. For each product a unique product ID, product weight, inventory level, amount on order and forklift requirement is recorded. For the receiving department a unique receiver ID, order receiving date, and forklift certification are recorded. - For the shipping department a unique picker ID, forklift certification, and shipment processing is recorded. For suppliers a unique supplier ID, and sup sales representative is recorded. For customers a unique customer ID, purchasing rep, and preferred courier are recorded. - For courier service a unique courier ID, shipment method, and loading dock requirement is recorded. Relationships - Each warehouse has many bin's and each bin has only 1 warehouse. Each bin can have 1 or no product and each product has only 1 bin. Each product has 1 supplier and each supplier may have 1 or more products. The receiving may receive many or no products and each product must go through receiving 1 time. Each product may have no or 1 customer and each customer may have many or no products. Each product will go through the shipping department once and the shipping department may ship many or no products. Each customer will use only one courier service and each courier service may have no or many customers. The shipping department will deal with many or at least courier services and the courier services will deal with only one shipping department.
Attributes with cardinality descriptions The company keeps track of each warehouse, inventory bin, product, receiving department, shipping department, supplier, customer, courier service. For each warehouse a unique warehouse ID, warehouse address, number of warehouse levels are recorded. For each inventory bin a unique bin ID, floor number, column ID, and shelf ID are recorded. For each product a unique product ID, product weight, inventory level, amount on order and forklift requirement is recorded. For the receiving department a unique receiver ID, order receiving date, and forklift certification are recorded. - For the shipping department a unique picker ID, forklift certification, and shipment processing is recorded. For suppliers a unique supplier ID, and sup sales representative is recorded. For customers a unique customer ID, purchasing rep, and preferred courier are recorded. - For courier service a unique courier ID, shipment method, and loading dock requirement is recorded. Relationships - Each warehouse has many bin's and each bin has only 1 warehouse. Each bin can have 1 or no product and each product has only 1 bin. Each product has 1 supplier and each supplier may have 1 or more products. The receiving may receive many or no products and each product must go through receiving 1 time. Each product may have no or 1 customer and each customer may have many or no products. Each product will go through the shipping department once and the shipping department may ship many or no products. Each customer will use only one courier service and each courier service may have no or many customers. The shipping department will deal with many or at least courier services and the courier services will deal with only one shipping department.
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Entity Relationship Diagram based on the list of requirements. The ERD should be created using ERDplus tool.
Create ERD using the information attached in SS
Transcribed Image Text:Attributes with cardinality descriptions
- The company keeps track of each warehouse, inventory bin, product, receiving
department, shipping department, supplier, customer, courier service.
-
For each warehouse a unique warehouse ID, warehouse address, number of
warehouse levels are recorded.
For each inventory bin a unique bin ID, floor number, column ID, and shelf ID are
recorded.
For each product a unique product ID, product weight, inventory level, amount on
order and forklift requirement is recorded.
-
For the receiving department a unique receiver ID, order receiving date, and
forklift certification are recorded.
-
For the shipping department a unique picker ID, forklift certification, and shipment
processing is recorded.
For suppliers a unique supplier ID, and sup sales representative is recorded.
For customers a unique customer ID, purchasing rep, and preferred courier are
recorded.
For courier service a unique courier ID, shipment method, and loading dock
requirement is recorded.
Relationships
Each warehouse has many bin's and each bin has only 1 warehouse.
Each bin can have 1 or no product and each product has only 1 bin.
Each product has 1 supplier and each supplier may have 1 or more products.
The receiving may receive many or no products and each product must go
through receiving 1 time.
Each product may have no or 1 customer and each customer may have many or
no products.
-
Each product will go through the shipping department once and the shipping
department may ship many or no products.
-
Each customer will use only one courier service and each courier service may
have no or many customers.
The shipping department will deal with many or at least courier services and the
courier services will deal with only one shipping department.
Transcribed Image Text:1. Warehouse
a. Warehouse ID
b. Warehouse address
c. Number of warehouse levels
2. Inventory bin
a. Bin ID
b. Floor #
G.Galuma, ID
d. Shelf ID
3. Product
a. Product ID
b. Product weight
Javeaton, level
d. Amount on order
e. Forklift required
4. Receiving Department
a. Receiver ID
b. Order Receiving processing date
Forklift certified
5. Shipping Department
a. Picker ID
b. Forklift certified
6.Shipment processing date
6. Supplier
a. Supplier ID
b. Sup Sales rep
7. Customer
a. Customer ID
b. Purchasing Rep
G.Requested Courier
8. Courier Service
a. Courier ID
b. shipment method
Gjoading dock requirement
(Ctrl) -
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education