-- This is an example

group: amazon

Customer = {
	CID:number, Name:string, City:string, State:string
	100, Mike, NY, NY
  	200, Dave, LA, CA
  	300, Joe, SF, CA
  	400, Denise, SP, NJ
  	500, Jessica, Newark, NJ
  	600, Mikey, Newark, NJ
}

Order = {
	OID:number, CID:number, Date:number
  	100, 100, 180101
  	200, 100, 180101
  	300, 200, 180131
  	400, 300, 180201
  	500, 400, 170201
  	600, 400, 170301
  	700, 500, 180115
  	800, 600, 130209
}

Product = {
	PID:number, ProductName:string, Price:number
	1000, computer, 50
  	1001, phone, 49
  	1002, television, 10
  	1003, camera, 47
	1004, ipad, 46
}

LineItem = {
	LID:number, OID:number, PID:number, Number:number, TotalPrice:number
	10, 100, 1000, 2, 100
  	11, 200, 1001, 1, 49
  	12, 300, 1002, 3, 30
  	13, 400, 1003, 1, 47
	14, 500, 1000, 1, 50
	16, 700, 1001, 1, 49
	17, 800, 1002, 1, 10
	18, 700, 1004, 1, 46
	19, 700, 1002, 1, 10
}