Database Struture Question

[toxictoad]

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

[Mchl]

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.