parts suppliers and catalog

gistfile1.txt

group: suppliers_schema

Suppliers = {
	sid:number, sname:string, city:string
  1, 'Acme', 'Virgina'
  2, 'BlackMesa', 'Atlanta'
  3, 'ValveCorp', 'Seattle'
}

Parts = {
  pid:number, pname:string, color:string
  1, 'Lugermorph', 'blue'
  2, 'Flying Guillotine', 'grey'
  3, 'Batsaber', 'red'
}

Catalog = {
  sid:number, pid:number, cost:number
  1, 3, 14
  2, 1, 6
  3, 2, 7
}