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
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.
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??? 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..
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