Draw an Entity Relationship Diagram (ERD) for the scenario described in this question Include all the entities, attributes and relationships described in the scenario in your ERD You need to show the minimum and maximum cardinality and use a verb to describe each relationship in your ERD State any reasonable assumptions that you make when drawing your ERD Scenario Building Supplies has many sales representatives and a few warehouses where it stores building material To ensure high quality of service, a business rule in Building Supplies is that a sales representative must be assigned to each customer Sales orders submitted by customers are processed by a sales representative who locates which warehouse the required material is stored and ensures that orders are met within three working days The order is usually processed by the sales representative assigned to the customer The selling price for material in an order could vary depending on the customer An example of an order is shown below Order No 017321Order Date 15 08 20 Customer No 0324Customer Name Best Builders Sales Rep for Customer Bobby Bones Staff ID 089 Sales Rep for Order Tony Roma Staff ID 077 Material code Description Selling Price ($) Quantity Warehouse Street Address Warehouse Suburb BR129 Brick Red 6 100 5 Main Way Belmont TW129 Tile White 7 100 6 Side Way Cockburn Draw an Entity Relationship Diagram (ERD) for the scenario described in this question Include all the entities, attributes and relationships described in the scenario in your ERD You need to show the minimum and maximum cardinality and use a verb to describe each relationship in your ERD State any reasonable assumptions that you make when drawing your ERD Scenario Building Supplies has many sales representatives and a few warehouses where it stores building material To ensure high quality of service, a business rule in Building Supplies is that a sales representative must be assigned to each customer Sales orders submitted by customers are processed by a sales representative who locates which warehouse the required material is stored and ensures that orders are met within three working days The order is usually processed by the sales representative assigned to the customer The selling price for material in an order could vary depending on the customer An example of an order is shown below Order No 017321 Order Date 15 08 20 Customer No 0324 Customer Name Best Builders Sales Rep for Customer Bobby Bones Staff ID 089 Sales Rep for Order Tony Roma Staff ID 077 Material Description Selling Price Quantity Warehouse Warehouse code ($) Street Address Suburb BR129 Brick Red 6 100 5 Main Way Belmont TW129 Tile White 7 100 6 Side Way Cockburn

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 28, 2024

Draw an Entity-Relationship Diagram (ERD) for the scenario described in this question. Include all the entities, attributes and relationships described in the scenario in your

Draw an Entity-Relationship Diagram (ERD) for the scenario described in this question. Include all the entities, attributes and relationships described in the scenario in your ERD. You need to show the minimum and maximum cardinality and use a verb to describe each relationship in your ERD. State any reasonable assumptions that you make when drawing your ERD.

Scenario:

Building Supplies has many sales representatives and a few warehouses where it stores building material. To ensure high quality of service, a business rule in Building Supplies is that a sales representative must be assigned to each customer. Sales orders submitted by customers are processed by a sales representative who locates which warehouse the required material is stored and ensures that orders are met within three working days. The order is usually processed by the sales representative assigned to the customer. The selling price for material in an order could vary depending on the customer.

An example of an order is shown below:

Order No: 017321Order Date 15/08/20

Customer No: 0324Customer Name: Best Builders

Sales Rep for Customer: Bobby Bones Staff ID: 089

Sales Rep for Order: Tony Roma Staff ID: 077

Material code

Description

Selling Price ($)

Quantity

Warehouse

Street Address

Warehouse

Suburb

BR129

Brick - Red

100

5 Main Way

Belmont

TW129

Tile - White

100

6 Side Way

Cockburn

Draw an Entity-Relationship Diagram (ERD) for the scenario described in this question. Include all the entities, attributes and relationships described in the scenario in your ERD. You need to show the minimum and maximum cardinality and use a verb to describe each relationship in your ERD. State any reasonable assumptions that you make when drawing your ERD. Scenario: Building Supplies has many sales representatives and a few warehouses where it stores building material. To ensure high quality of service, a business rule in Building Supplies is that a sales representative must be assigned to each customer. Sales orders submitted by customers are processed by a sales representative who locates which warehouse the required material is stored and ensures that orders are met within three working days. The order is usually processed by the sales representative assigned to the customer. The selling price for material in an order could vary depending on the customer. An example of an order is shown below: Order No: 017321 Order Date 15/08/20 Customer No: 0324 Customer Name: Best Builders Sales Rep for Customer: Bobby Bones Staff ID: 089 Sales Rep for Order: Tony Roma Staff ID: 077 Material Description Selling Price Quantity Warehouse Warehouse code ($) Street Address Suburb BR129 Brick - Red 6 100 5 Main Way Belmont TW129 Tile - White 7 100 6 Side Way Cockburn