I need ERD Model Arrow Electronics is a consumer electronics retailer operating in the United States. Arrow follows a business-to-consumer (B to C) business model with 2016 annual sales of 18.6 million. Arrow Electronics produces monthly print catalogs it distributes to customers. Arrow also distributes a bi-yearly "clearance catalog" it sends to targeted households.Arrow recently completed construction of a new central warehouse and distribution center in Lincoln, Nebraska. The new distribution center will allow Arrow to process a significantly larger volume of customer orders. Arrow's management team realizes they must increase the number of customer orders to take advantage of capabilities provided by the new distribution center.Arrow is currently using an outdated database system which is hindering the tracking of data and E-Commerce sales. Arrow has requested that you design a relational database that will allow data tracking and seamless data flow. Currently, 78% of all orders come from customers calling in from the print catalog and only 22% of all orders come from the E-Commerce website. Arrow's management team believes Internet sales will increase with time as more customers become aware of the updated E-Commerce option.With the new distribution center and E-Commerce site, Arrow hopes it has created the winning combination to secure its place in the consumer electronics industry.Needs Assessment & Database DesignIn order to process customer orders from the E-Commerce site, Arrow needs a database. By reviewing Arrow’s operations and business rules, a database design is identified.The database must support the following eight entities:1. Customers - The system must support traditional customer telephone orders (print catalog) as well as web-based customers (E-Commerce site). The system shall allow a single customer to place orders on both systems by a unique user ID.2. Employees - Arrow employees working in the call center will record customer orders under a unique employee ID that identifies the employee processing the customer's order.3. Shipping - The system must provide a lookup and storage mechanism to accommodate shipping needs for customer orders.4. Products - The system must accommodate the extensive listing of Arrow's products.5. Suppliers - The system shall provide a lookup and storage mechanism to accommodate the suppliers of Arrow's products.6. Categories - The system shall provide a broad classification of products for product lookup capabilities.7. Orders - The system shall manage customer orders for products.8. Order Items - The system shall accommodate many individual products (Order Items) to be purchased and referenced on one order number.

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
icon
Related questions
Question

I need ERD Model

Arrow Electronics is a consumer electronics retailer operating in the United States. Arrow follows a business-to-consumer (B to C) business model with 2016 annual sales of 18.6 million. Arrow Electronics produces monthly print catalogs it distributes to customers. Arrow also distributes a bi-yearly "clearance catalog" it sends to targeted households.
Arrow recently completed construction of a new central warehouse and distribution center in Lincoln, Nebraska. The new distribution center will allow Arrow to process a significantly larger volume of customer orders. Arrow's management team realizes they must increase the number of customer orders to take advantage of capabilities provided by the new distribution center.
Arrow is currently using an outdated database system which is hindering the tracking of data and E-Commerce sales. Arrow has requested that you design a relational database that will allow data tracking and seamless data flow. Currently, 78% of all orders come from customers calling in from the print catalog and only 22% of all orders come from the E-Commerce website. Arrow's management team believes Internet sales will increase with time as more customers become aware of the updated E-Commerce option.
With the new distribution center and E-Commerce site, Arrow hopes it has created the winning combination to secure its place in the consumer electronics industry.
Needs Assessment & Database Design
In order to process customer orders from the E-Commerce site, Arrow needs a database. By reviewing Arrow’s operations and business rules, a database design is identified.
The database must support the following eight entities:
1. Customers - The system must support traditional customer telephone orders (print catalog) as well as web-based customers (E-Commerce site). The system shall allow a single customer to place orders on both systems by a unique user ID.
2. Employees - Arrow employees working in the call center will record customer orders under a unique employee ID that identifies the employee processing the customer's order.
3. Shipping - The system must provide a lookup and storage mechanism to accommodate shipping needs for customer orders.
4. Products - The system must accommodate the extensive listing of Arrow's products.
5. Suppliers - The system shall provide a lookup and storage mechanism to accommodate the suppliers of Arrow's products.
6. Categories - The system shall provide a broad classification of products for product lookup capabilities.
7. Orders - The system shall manage customer orders for products.
8. Order Items - The system shall accommodate many individual products (Order Items) to be purchased and referenced on one order number.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Business to Business
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education