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

    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

    No only primary keys



    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.


    Relations would also be a table.

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

    mayjune New Member

    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
      File size:
      107.9 KB
    • schema.jpg
      File size:
      66.9 KB
  4. shabbir

    shabbir Administrator Staff Member

    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