Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help please 1. SPECIFICATION of an ORDER PROCESSING database: Consider the following set of data requirements for an ORDER PROCESSING COMPANY which orders for items
help please
1. SPECIFICATION of an ORDER PROCESSING database: Consider the following set of data requirements for an ORDER PROCESSING COMPANY which orders for items are placed by customers and shipped from warehouses. - The order processing DB has customers, each identified by a unique customer number, first and last name, city, and ZIP code. - Each warehouse of the company is identified by a unique warehouse number, city, where it i located, and ZIP code. Each warehouse ships one or more orders. The ship date when an order is shipped from a warehouse is recorded. Assume that an order can be shipped from several warehouses. - Each item listed in an order is identified by a unique item number, an item name, and unit price. - Each order is placed by a customer and is given a unique order number. Each order contains specified quantities of one or more items. The total dollar amount of an order is recorded. Each order has an order date, when an order was placed; and a date of receint - (10 pts) Another ER diagram version, where the structural constraints are expressed using the altemative ( min,max ) notation (as on p. 22 in the notes for Ch. 7). - (10 pts) Include also the role names of each entity type participating in relationship into this version of the ER diagram Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started