Question: Task: Consider a retail database in which customers place orders. The data requirements are summarized as follows: The company's customers are uniquely identified by their
Task:
Consider a retail database in which customers place orders. The data requirements are
summarized as follows:
The company's customers are uniquely identified by their identifier custID In
addition, their first and last names, password, and phone numbers are recorded.
A customer may place orders, and each order must be placed by exactly one
customer.
A unique item identifier iID is used to identify the company's items. In addition, the
item name, price, and quantity in stock are tracked.
Each order placed by a customer is given a unique order identifier oID Besides the
order identifier, the order date, shipping date, receiving date, pay amount, and
payment method should be documented.
Each order must include some items of a specific quantity and sale price. An item
may be included in an order.
Based on the above information, draw an ER diagram using a datamodeling tool like
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
