Quote:
Originally Posted by mayjune
1) Do you underline the foreign key?
No only primary keys
Quote:
Originally Posted by mayjune
2) Do you show foreign key ?
No
Quote:
Originally Posted by mayjune
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
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
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
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
7) Do i show foreign key in all of them?
No
Quote:
Originally Posted by mayjune
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.