I need crow ERD Model with PK, FK and Referential integrity 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.
I need crow ERD Model with PK, FK and Referential integrity
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
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
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.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 2 images
