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

View previous topic View next topic Go down

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

Post  JR19 on Tue Mar 04, 2014 5:39 am

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

JR19

Posts : 2
Join date : 2014-03-04

View user profile

Back to top Go down

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

Post  nick_white on Tue Mar 04, 2014 10:42 am

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,

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

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

Post  ngalemmo on Tue Mar 04, 2014 1:44 pm

What is this for?
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

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

Post  BoxesAndLines on Tue Mar 04, 2014 3:53 pm

Do you have a Paypal account? ;-)
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

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

Post  BoxesAndLines on Tue Mar 04, 2014 8:40 pm

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!
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

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

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum