Question
Please help me create a data modeling diagram based on the following: Sure, here are the required details for the project deliverable: Must Haves: The
Please help me create a data modeling diagram based on the following:
Sure, here are the required details for the project deliverable:
Must Haves:
The database must be able to store and retrieve customer orders, including order details, payment information, and shipping information. It should also be able to manage inventory levels, customer data, and product data.
Business Rules:
Customers must provide a valid email address to create an account and place orders.
Customers cannot place an order if their selected products are out of stock.
Payment must be made at the time of order placement.
Customers can only cancel an order within 24 hours of placing it.
The system should automatically update inventory levels as orders are placed and shipped.
Entities:
Customer
Order
Product
Payment
Shipping
Attributes:
Customer:
Customer ID
Name
Order:
Order ID
Order Date
Order Status
Product:
Product ID
Product Name
Product Description
Payment:
Payment ID
Payment Date
Payment Amount
Shipping:
Shipping ID
Shipping Address
Shipping Date
Relationships:
One customer can place many orders.
One order can contain many products.
One order can have one payment.
One order can have one shipping.
One product can have many orders.
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