Question
In your database, customers are tracked by a unique customer ID. Your database records each customers information: username, password, and the role at Duke. Similarly,
In your database, customers are tracked by a unique customer ID. Your database records each customers information: username, password, and the role at Duke. Similarly, each product that you are selling is tracked by a unique product ID. Your database also records the product name, manufacturing cost ($), listing price ($) and max profit ($) of each product.
A customer can place many orders. Each order has a unique order ID, and is tracked by the customer ID. An order should have an order time, a shipping address, a credit card number, and an expiration date of the credit card. Each order can use one coupon, and a coupon is tracked by the coupon code and has a discount percentage.
An order can include more than one product, and a product can be purchased by different orders. The order details that connect orders with products are recorded as order lines. Each order line has a unique order line ID, and should be tracked by order ID and product ID. Your database also records the purchase quantity of a product in an order line.
- Please create a class diagram for Dukes Merchandise Webstore based on the business rules.
- Please include the classes, attributes, primary keys, attribute types, relationships, and multiplicities in your diagram.
- You can upload a file, a photo, a scan, or a screenshot of the your class 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