-- select all and paste into the Group Editor of Relax
group: Lecture3

College = {
	cName:string, state:string, enr:number
	LSU, LA, 18000
	ASU, AZ, 12000
	OSU, OK, 22000
	FSU, FL, 18000
}

Player = {
  pID:number, pName:string, yCard:string, HS:number
	10001, Andy, no, 1200
	20002, Blake, no, 1600
	30003, Chuck, no, 600
	40004, Dave, yes, 1600
	50005, Ed, yes, 300
	60006, Ford, no, 250
}

Tryout = {
  pID:number, cName:string, pPos:string, dec:string
	10001, LSU, goalie, no
	10001, ASU, mid, yes
	20002, FSU, striker, yes
	30003, OSU, mid, no
	40004, ASU, goalie, no
	50005, LSU, mid, no
}

PlayerGoals = {
  pName:string, Goals:number, vName:string
	Joe, 1, Pepsi
	Ann, 1, TD-Garden
	Joe, 2, AA
	Jim, 3, United
	Ann, 2, Pepsi
	Joe, 1, TD-Garden
	Ann, 0, AA
	Joe, 2, United
	Jim, 0, Pepsi
	Ann, 1, United
}

Venues = {
  vName:string, City:string, State:string
	TD-Garden, Boston, MA
	United, Chicago, IL
	AA, Dallas, TX
	Pepsi, Denver, CO
}

PlayerSt = {
  pID:number, pName:string, yCard:string, HS:number, HSst:string
	10001, Andy, no, 1200, AZ
	20002, Blake, no, 1600, NH
	30003, Chuck, no, 600, OK
	40004, Dave, yes, 1600, TX
	50005, Ed, yes, 300, MD
	60006, Ford, no, 250, VT
}

PlayerStat = {
  Jersey:number, pName:string, Game:number, Pts:number
	10, "Andy", 1, 12
	12, "Blake", 1, 22
	14, "Chuck", 1, 8
	10, "Andy", 2, 14
	12, "Blake", 2, 24
	16, "Dave", 2, 25
}


Truck = {
  Type:string, MaxTow:number
	"Tundra", 10000
	"Sierra", 11200
	"Silverado", 11200
	"F-150", 7600
	"Titan", 9390
	"RAM1500", 8750
}

Trailer = {
  Model:string, Weight:number
	"Mech-10", 7800
	"Mech-20", 9200
	"Deca", 10000
	"Mini", 7200
}