Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes Order: has one or many items; half by member half by anonymous member (no member number) Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped. Order-Item (one of the 1600 products): to identify: useorder number as well as a small “item sequence number” (which is unique within each order). product number, quantity ordered and the actial "unit price paid" If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used. The average order includes 11 distinct order-items. Member (places 5 orders per month on avg): last name, given names, email address and five mailing-address fields, consisting of two street address fields (eg. Address-line1, Address-line2), municipality, province and postal code. member number, also each member is assigned the number of a sales representative employee with whom they can discuss complaints. Account-id number: Each account is associated with only one member, and also tracks the account’s start-date and credit-limit. Each member could have many such accounts Store (800 memebers per store): store number, date it was first opened and its loading-dock size in square meters, 5 standard mailing-address attributes. employee number of the one store-manager (one manager-employee could manage many stores). Product: unique product-id number, descriptive name, the id-number of its producer, unit-weight in grams, sales target amount for the current year, whether it is exempt from GST product belongs to one of 40 product-lines; ‘stationery’, ‘auto supplies’, ‘produce’ or ‘meats’ Producers (280 total): name, municipality and province/state code
Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes
Order: has one or many items; half by member half by anonymous member (no member number)
Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped.
Order-Item (one of the 1600 products):
to identify: useorder number as well as a small “item sequence number” (which is unique within each order).
product number, quantity ordered and the actial "unit price paid"
If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used.
The average order includes 11 distinct order-items.
Member (places 5 orders per month on avg):
last name, given names, email address and five mailing-address fields, consisting of two street address fields (eg. Address-line1, Address-line2), municipality, province and postal code.
member number, also each member is assigned the number of a sales representative employee with whom they can discuss complaints.
Account-id number: Each account is associated with only one member, and also tracks the account’s start-date and credit-limit. Each member could have many such accounts
Store (800 memebers per store): store number, date it was first opened and its loading-dock size in square meters, 5 standard mailing-address attributes.
employee number of the one store-manager (one manager-employee could manage many stores).
Product: unique product-id number, descriptive name, the id-number of its producer, unit-weight in grams, sales target amount for the current year, whether it is exempt from GST
product belongs to one of 40 product-lines; ‘stationery’, ‘auto supplies’, ‘produce’ or ‘meats’
Producers (280 total): name, municipality and province/state code.
Employee (310 total): an employee number, a supervisor (who is also an employee)
Step by step
Solved in 4 steps with 1 images
