1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Help in ER Diagram and Schema Tables..

Discussion in 'Database' started by mayjune, Aug 7, 2009.

  1. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    Hi,
    I have to make a vb+sql project. I am making it on IMDB (Internet Movie Database - check wiki for more info) Its basically a site which manages a huge database for movies, its reviews, ratings etc.

    I am so confused in it. I made an ER diagram, with whatever info i got, but i have so many confusions.

    1) Do you underline the foreign key?
    2) Do you show foreign key ?
    3) In the diagram, I have subbed Actors address as a seperate entity, do i have to show actors id in it as a foreign key?
    4) A Member crticizes a movie, but i didnt know how to show that in the diagram?
    5) Are the relations shown correct? if not whats wrong?
    6) How do I make a schema table out of it?
    7) Do i show foreign key in all of them?
    8) How do I show criticism in the schema table? as it itself is not a table but a relation!

    I am so confused...i have to show something so i made something, im attaching both ER and Schema, have a look at it and give your feedbacks. Thanks a ton :)
     

    Attached Files:

  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    No only primary keys

    No

    Yes

    As a Review with may be a rating.

    No. You have movie and Actor but there may be many actors in a movie.

    If you have the ER Diagram correct each unit would be a table.

    No

    Relations would also be a table.

    I would suggest you start ER Diagram on smaller note.
     
  3. mayjune

    mayjune New Member

    Joined:
    Jun 14, 2009
    Messages:
    817
    Likes Received:
    33
    Trophy Points:
    0
    Occupation:
    Student
    Location:
    Pune,Delhi
    Ok, i have made a new ER and Schema diagram, please see and tell me if its correct.
    Although this project has been rejected on the basis that its for web application...:cryin:
    although it makes no sense as to whats the problem if it is??? :confused::confused:
    Anyway, i still made it to understand and learn how to make them...

    Also...What confuses me is there can be many ways to represent the same project...so how do i know which one teacher would think is correct? as its very subjective....in theory paper i have to make them....

    Please see and tell me the relations are correct or not, as i spent whole day in understanding them..thanks.. :)
     

    Attached Files:

    • ER.jpg
      ER.jpg
      File size:
      107.9 KB
      Views:
      120
    • schema.jpg
      schema.jpg
      File size:
      66.9 KB
      Views:
      103
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,276
    Likes Received:
    364
    Trophy Points:
    83
    In the ER Diagram Primary Key should be underlined.
    I do not understand the reason for Member Table. It should be combined into Account.
    Criticism Table should not have Movie Name
     

Share This Page