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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!