Good Table design tutorials?

[msimonds]

I wanted to know if at all possible if anyone knew of any good tutorials out there that could help me learn database table creation:

Example:

MLB Standings

Divisions:
AL East
AL Central
AL West
NL East
NL Central
NL West

Teams would need to be assigned to a division

Team table:
Team name
Won
Lost
PCT
GB
Home
Road
record against East
record against Central
record against West
Streak
Last 10

I hope I am not confusing anyone, just want some tutorials so that I can know what type of value to assign to each field in the table and how to tie the two tables together

Thanks in advance!

Mike

[Piranha]

I think w3schools are pretty good to show basic stuff in a simple way: http://www.w3schools.com/sql/default.asp

[msimonds]

Thanks piranha, that was a good tutorial!

if the table was to have a row for "last 10" and the value of that table was "7-3", would it need to be VARCHAR or INT? Or does it really matter

[msimonds]

I was wondering if someone could look at this SQL dump and tell me if this would work. This is based off of standings coming from http://www.sportsrant.com/natch.php

-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Aug 07, 2006 at 03:22 PM
-- Server version: 5.0.21
-- PHP Version: 4.4.2-pl1
-- 
-- Database: `test`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `divison`
-- 

CREATE TABLE `divison` (
  `division_id` int(10) unsigned NOT NULL auto_increment,
  `division_name` varchar(100) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`division_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `divison`
-- 

INSERT INTO `divison` VALUES (1, 'AL West');

-- --------------------------------------------------------

-- 
-- Table structure for table `teams`
-- 

CREATE TABLE `teams` (
  `teamid` int(10) unsigned NOT NULL auto_increment,
  `division_id` int(10) unsigned NOT NULL default '0',
  `name` varchar(100) collate latin1_general_ci NOT NULL default '',
  `wins` int(10) unsigned NOT NULL default '0',
  `loss` int(10) unsigned NOT NULL default '0',
  `percent` int(10) unsigned NOT NULL default '0',
  `behind` varchar(10) collate latin1_general_ci NOT NULL default '',
  `hrecord` varchar(45) collate latin1_general_ci NOT NULL default '',
  `rrecord` varchar(45) collate latin1_general_ci NOT NULL default '',
  `erecord` varchar(45) collate latin1_general_ci NOT NULL default '',
  `crecord` varchar(45) collate latin1_general_ci NOT NULL default '',
  `wrecord` varchar(45) collate latin1_general_ci NOT NULL default '',
  `streak` varchar(45) collate latin1_general_ci NOT NULL default '',
  `last10` varchar(45) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`teamid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=3 ;

-- 
-- Dumping data for table `teams`
-- 

INSERT INTO `teams` VALUES (1, 1, 'Boston Red Sox', 10, 1, 0, '--', '5-0', '5-1', '10-1', '0-0', '0-0', 'Won 10', '10-0');
INSERT INTO `teams` VALUES (2, 1, 'New York Yankees', 5, 5, 0, '5', '5-0', '0-5', '5-5', '0-0', '0-0', 'Lost 5', '5-5');

I entered the date manually, I really want to know if the division_id is a good key and to know if I am doing the relationship correclty!

TIA

Mike

[msimonds]

Can anyone help me on this!!

[Dang]

I wanted to pipe in on the database design question.
I am "BRANDSPANKIN'" new to PHP/MySQL so I'm of no use as a resource there. But I do have a good amount of experience with Microsoft Access and the first thing to do is google "Normalization" that is where it all starts.
Here is a great MS Access formum, it is a great resource for table design, theory and even SOL questions...http://www.access-programmers.co.uk/forums/

Hope this gets you started