Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2008
    Posts
    38

    Newbie In DataModelling!! Help Needed with design

    Click image for larger version. 

Name:	example1.jpg 
Views:	73 
Size:	42.0 KB 
ID:	8718
    Iam trying to create a database for the following requirement.
    can anyone please tell me if the design is correct or where I went wrong!!

    The case is to create a database for a company that has 3 branches (A,B,C) located in a very small
    geographic location (at the same street). The branches are selling the same goods, electronic stuff.
    The goal of the database is to create database for the products and enabling real-time updates of goods
    delivered between the branches. Each branch can view another branches inventory in real time.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    nice assignment

    you have a ways to go before your ER model is ready to hand in

    first of all, take each of your entities, and give some sample rows for them

    for example, some sample rows for the product table are

    Code:
    prod_id  prod_price
    widget     9.37
    doodad    12.98
    thingie   35.00
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Sep 2008
    Posts
    38
    This is not my assignment. Iam trying to learn database design on my own.
    so please can u explain me what this statement means, coz I think I was wrong in understanding what it means!!

    "The goal of the database is to create database for the products and enabling real-time updates of goods delivered between the branches. Each branch can view another branches inventory in real time".

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    it means there will be a table with products in it, and some way of identifying the branch that the products belong to
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Sep 2008
    Posts
    38
    does it mean M:M relation between products and Branch and a table like delivered_goods for connecting both products and branch table?

  6. #6
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i don't think so

    from the description, each item belongs to only one branch at a time

    by the way, ~what~ electronic goods are we talking about?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  7. #7
    Join Date
    Sep 2008
    Posts
    38
    sorry rudy,
    I cannot answer your question because this is not something like an assignment that is given to me. I found this question in dbforums and Iam trying to model as I found the question interesting and I think it was left unresolved.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •