Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2006
    Posts
    3

    Plz help~ER DIAGRAM DESIGN OF A SPORT HOUSE

    i need to design a ER DIAGRAM for a sport house (that mean selling sport products), but i dun know what entity type(s) and attributes should i put in, can anyone state a example? thx~!!!

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    For entity types, you could use normal entities. You don't need any special kind of entity type that I can think of for this job.

    For attributes, you probably want size, weight, and color among others.

    -PatP

  3. #3
    Join Date
    Dec 2006
    Posts
    3
    Quote Originally Posted by Pat Phelan
    For entity types, you could use normal entities. You don't need any special kind of entity type that I can think of for this job.

    For attributes, you probably want size, weight, and color among others.

    -PatP
    normal entites are?

    in fact, i need to design a huge project--POS SYSTEM for a chain of retail stores (computer's homework)...so i need to design a complicating ERD...
    so i think the attributes you suggested is too simple....
    wt should i mention in this? inventory? bill? customers? employee? order? sale?
    cry:...seem so difficult...

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    What have you learned in class so far?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Dec 2006
    Posts
    3
    Quote Originally Posted by blindman
    What have you learned in class so far?
    ....teacher just taught the basic things....he did not state any eg...so i search info. form websites only...

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Then you need to go to you teacher and complain that he didn't teach you anything about entities or attributes.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Jul 2003
    Posts
    74

    Getting started ...

    You need to show that you have done something before we help you.

    Here's a 'Kick-Start' Data Model on the Database Answers web site to get you thinking along the right lines :-
    http://www.databaseanswers.org/data_...tail/index.htm

    Here's a page on a Tutorial to help you understand the Database Model Schema :-
    http://www.databaseanswers.org/tutor...al_slide_5.htm

    Here's a page with a Data Model covering Customers and Orders :-
    http://www.databaseanswers.org/data_...ders/index.htm

    Here's a page listing more than 450 Data Models, including a whole lot for Customers and different kinds of Inventory :-
    http://www.databaseanswers.org/data_models/index.htm

    Look at them, think about them, produce a composite Data Model where you take the relevant Entities from other Models.

    Then get back to us.

    HTH

    B.Dimple
    Senior DBA

Posting Permissions

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