In real need of help

[themovieman]

Hi all,

 

I'm very new to the whole sql database game. I've been watching and reading a whole lot of tutorials online about the subject and I'm now ready to give it a shot. I think I'm gonna use Microsoft SQL, as most of the tutorials I've read have been based on it. Also I read a lot of people saying its actually easier to use. Anyway, I'm gonna have a go at making a simple (or so it sounds) game cheat site.

 

My idea for the database is as follows...

 

table 1 - GameID | Gamename | PublisherID | Date | PlatformID

 

table 2 - PublisherID | Publisher

 

table 4 - PlatformID | Platform

 

table 5 - GameID | Cheatname | Cheat

 

table 6 - GameID | Trainername | trainer

 

table 7 - GameID | Walkname | Walkthroughlink

 

 

Um, this would be my first sql database, so I'd really like to know what people think. Am I using the right tables, titles, etc?

 

I then plan to have a simple 1 page website with a search box and 2 drop down menus. I'd like the drop downs to be platforms and type (cheat, trainer or walk through). I have Dreamweaver, but I'm getting a little lost on how to connect the two and make things work. I'm hoping things will become easier one the DB is made.

 

Thanks in advance

 

Any help would be great

 

 

[kernelgpf]

I wouldn't name your tables "table 1" "table 2" or any of that, I'd actually use descriptive titles, but otherwise, the layout looks great.