Dont know how to go about database design

Hello

Im currently making a new website for my favorite tv series heroes. I have designed and coded the templates in html/css.

I know what the website database needs to do i just dont have a clue about how to go about designing the database. Once i got a layout of how the database is going to work then i can easily start coding the php to get the site working.

Basically the site is needing to be able to:

Provide list seasons i.e 1,2,3...
Provide list of episodes for each season.
Thats about it really.

But the episodes need to be able to hold information on:
1:Which season the episode belongs in.
2:Episode Number
3:Episode Name
4:Episode sumary
5:Episode Link

i just really dont have a clue about how to design the database, whats the primary key, how many tables its needing, what goes under each table ect...

Just wandering if someone could help me out a lil here? Have provided links to the three pages which i am using to help give you a rough idea.

1: Home Page
2: Page containing Video
3: Series/Episode Select

Please could someone help me here

 

Sorry friend,
I haven't any solution of your problem but I will consult with a expert about your problem and then I will tell you.
Thanks for sharing.

 

guessing no one can help??

 

Well, putting together a database takes some planning lets start with which database are you going to use? mysql, SQL sever, Access ....... Laying out the tables needed for the site and their interactions/relationships will take more explination than is appropriate for this forum. My quess is that you will be using mysql as the database since you were going code for it in PHP. I strongly suggest that go to your local book store and pick up a book on MySQL/PHP. This will give you an idea of what you have to do. If time is an issue for you, I would find a friend with DB skills to build for you.

hope this helps

 

its quest easy,

ID - Auto inrement
EpisodNumber -int
EpisodName -varchar
Episod_Sumary -text
Episod_Link - varchar
Season_Number - int


if you wanna select for example all episods from season 2 you run a query like this:

Select * from table_test where season_number = '2';

thats just a simple basic example.

 

episode number - (Auto increment)
season number - Int
episode name - Varchar
episode sumary - text
episode Link - Varchear

if you want add time of the episode, epideo heros, you will be add database.
if you want select for example all episods from season 4 you run a query like this:

Select * from table_test where season_number = '4';