toxictoad Posted November 17, 2008 Share Posted November 17, 2008 Hey all, I'm new to MySQL and currently have been working with a one table db that works ok but now want to expand this so there are different tables. This is what I was thinking. db name: mymovies table name: movie_info fields: movieID (PK) | title | year | stars | country | plot | certification table name: actors fields: actorID (PK) | actor1 | actor2 | actor3 | actor4 | actor5 table name: directors fields: directorID (PK) | director1 | director2 table name: genre fields: genreID (PK) | genre1 | genre2 table name: links fields: linksID (PK) | coverLK | trailerLK | detailsLK Is my table/field structure good? I dont know how atm how to make the connection between the tables but think this must be done in the php page? Thnaks Quote Link to comment Share on other sites More sharing options...
Mchl Posted November 17, 2008 Share Posted November 17, 2008 It is not good. It seems like you;ve just split a single table design into five tables. What you need is a process called normalization. Look it up in Google. I think you could also read this. Don't be shy to ask further questions. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.