Need an Entity-Relationship (ER) Diagram (that describe the relationship between entities)

Hi,
I need an Entity-Relationship (ER) Diagram (that describe the relationship between entities)for the below requirement. Please help me as I am a newbie

Client Information: ABC

1) Many stores across many countries

2) Each store employ staff (that could move across stores)

3) Each store sells hundreds of products across 3 product lines

  a)Magazines

  b)Newspapers

  c)Stationary

4) All stores sell the same product lines but may have different quantities available in their warehouses

5) Payment can be made by either POS terminal or online

  a)Via cash/debit or credit card

  b)Cheques not allowed

Please provide a ER diagram which describe the relationship between entities

Hi - producing an E-R diagram for a dimensional model is the end result of a significant amount of work: requirements analysis, creating a Bus Matrix, defining the dimensional model, etc. I doubt anyone you contact on a forum has the time to produce an ER model for you and even if they did it would probably be of little use as they wouldn't know enough about your requirements to produce a useful model - plus, as you wouldn't have been through the design process, you would not be able to critique it

Can I suggest that you read a book on Dimensional Modelling and/or the process for implementing a data warehouse? As this is a Kimball forum the obvious place to start are the Kimball books:

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
The Data Warehouse Lifecycle Toolkit

Regards,

What is this for?

Do you have a Paypal account? ;-)

OK, I'll pick out some candidate entities to get you started. All you have to do is connect the boxes.
Store
Product
Product Line
Staff
Location (Warehouse or Store)
Payment
Payment Method

Good luck!