FK_tablefrom_tableto_fieldto
IDX_table_field
PK_table_field
PRIMARY = tablePRIMARY


* = PK
@ = FK
^ = Unique


Customer(CustID*, CustName)
Order(OrderID*, CustID@, Date)
SalesRep(EmpID*@,CustID*@)

Course(CrsCode*, DeptCode, Description)
Class(ClassId^,CrsCode@*, Section*, ClassTime…)
Student(StudentId*,StarID^,...)
Student_Class(StudentId*@,Classid*@,Grade,...)



20211 Sum1		Summer
20212 Sum2
20213 Fall		Fall
20214 Winter
20215 Spring	Spring

user(userId*,FirstName,MiddleName,Lastname,..)
userdata(userId*@,StudentId,StarID,...)

15:11:43	Server: localhost   Database: bookinfo  -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 21, 2010 at 05:08 AM -- 
Server version: 5.1.36 -- PHP Version: 5.3.0  SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"	
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Server: localhost   
Database: bookinfo  -- phpMyAdmin SQL Dump -- version 3.2.0.' at line 1	0.031 sec

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 
'Server: localhost   Database: bookinfo  -- phpMyAdmin SQL Dump -- version 3.2.0.' at line 1