furniture company maintains a large database of home furnishing products,
such as furniture, carpets, lamps, rugs, etc, which are bought by its customers.
Due to the difference in size of the
products that they sell, products are either for delivery or collection in the store.
All products have a price and a
description along with other details, whilst if an item is for delivery then the company needs to hold the dimensions of
the product (for calculating postage costs) and for items for collection it holds the weight.
The company has many stores across the country and each store has a number of employees.
Certain employees deal
with the delivery of products bought online, such as organising and posting, while other employees deal with the
products for collection.
Customers have unique accounts with the company and the company wants to hold details of
past purchases so that they may in the future build up a picture of the items purchased by customers for marketing
purposes.
The company needs to hold details relating to products purchased online, either for delivery or, if for
collection, then it needs to hold details of the collection arrangements with the customer.
Each store has a number of
suppliers who deliver the products for sale in the store.
Really need help on creating the diagram for this, cant seem to fit all the relationships in the diagram