Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ethical Obligations and Decision Making in Accounting Text and Cases

Authors: Steven Mintz, Roselyn Morris

4th edition

978-1259543470, 1259543471, 978-1259730191

More Books

Students also viewed these Accounting questions

Question

Explain the concept of shear force and bending moment in beams.

Answered: 1 week ago