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