I need to create a database for a simple website with films collection. I decided I need following columns in the table:
I made some reading and after getting familiar wit normalization rulez I decided to divide this in four tables:
1st table "Basic info"with columns: movieID,titleID, directorID, yearID
2nd table:"Artists ID" with colums: movieID, titleID, artist1_ID, artist2_ID,artist3_ID,artist4_ID
3rd table "CategoryID" with columns: movieID, titleID, category1_ID, category2_ID, category3_ID, moodID
4th table "DescriptionID" with columns: movieID, titleID, trailerID, descriptionID
Im having problem with creation relations. I know it should be one-to-many relation but I dont know how to draw it in diagram. Can anybody help me with this please ? Also are tables above look alright ?
Thanks in advance