Forums
This topic is locked
very new - need sql database help
Posted 13 May 2007 06:00:40
1
has voted
13 May 2007 06:00:40 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<b></b><b></b><b></b>