Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    10

    question about entity modeling

    hi
    i ve got problem wih understanding entity model as i get confused and think there must be a foreign key of each primery key in entity model (i think i am wrong because i should do that in actual database not in documentry )
    pic below is my entity model for fake company which called freds dance school and i found these are the entity ,can any one please give me help if i am wrong in some stage of it
    link for pic
    http://aycu09.webshots.com/image/497...7622040_rs.jpg
    but i think in booking entity apart from booking id and booking date i should have:
    payment id
    dance id
    student id
    which all of these could be foreginn key but i think i am wrong could u please explaina and help
    or other example
    i think i should have session id attribute from session entity in the tutor entity as foreign key but i am not sure if it is right as this is documentry not data base

    any help would be appriciated
    thanks
    Attached Thumbnails Attached Thumbnails entity.JPG  

  2. #2
    Join Date
    Apr 2008
    Posts
    29
    linux44,

    In entity/relationship modeling you model the RELATIONS among the several ENTITIES that make the database. In your pic the relationships don't add up to the entities....

    What you should put in each entity is up to you, however your model must have every entity and relationship you want to implement in the DB...

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    probably best to move this to the Database Concepts & Design

Posting Permissions

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