Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Database (http://www.go4expert.com/forums/database-forum/)
-   -   Help in ER Diagram and Schema Tables.. (http://www.go4expert.com/forums/help-er-diagram-schema-tables-t18850/)

mayjune 7Aug2009 06:44

Help in ER Diagram and Schema Tables..
 
2 Attachment(s)
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 :)

shabbir 7Aug2009 08:49

Re: Help in ER Diagram and Schema Tables..
 
Quote:

Originally Posted by mayjune (Post 54411)
1) Do you underline the foreign key?

No only primary keys

Quote:

Originally Posted by mayjune (Post 54411)
2) Do you show foreign key ?

No

Quote:

Originally Posted by mayjune (Post 54411)
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?

Yes

Quote:

Originally Posted by mayjune (Post 54411)
4) A Member crticizes a movie, but i didnt know how to show that in the diagram?

As a Review with may be a rating.

Quote:

Originally Posted by mayjune (Post 54411)
5) Are the relations shown correct? if not whats wrong?

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

Quote:

Originally Posted by mayjune (Post 54411)
6) How do I make a schema table out of it?

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

Quote:

Originally Posted by mayjune (Post 54411)
7) Do i show foreign key in all of them?

No

Quote:

Originally Posted by mayjune (Post 54411)
8) How do I show criticism in the schema table? as it itself is not a table but a relation!

Relations would also be a table.

I would suggest you start ER Diagram on smaller note.

mayjune 8Aug2009 22:42

Re: Help in ER Diagram and Schema Tables..
 
2 Attachment(s)
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.. :)

shabbir 9Aug2009 10:02

Re: Help in ER Diagram and Schema Tables..
 
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


All times are GMT +5.5. The time now is 03:33.