Forums

This topic is locked

really need help - sql DB - newbie....

Posted 13 May 2007 06:02:02
1
has voted
13 May 2007 06:02:02 Rhodri Davies posted:
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

Reply to this topic