IU S24 Databases. Lab3. Example

gistfile1.txt

group: IU Databases. Lab 3. Example
description: Example database for the "Databases" course in Innopolis University.

Supplier = {
  SID:number, Name:string, City:string
  1, Robert, Moscow
  2, Denis, Saratov
  3, Patrick, Moscow
  4, Bailey, Kazan
}

Product = {
  PID:number, Item:string, Color:string
	1, door, brown
	2, table, yellow
	3, chair, red
	4, vase, red
}

Catalogue = {
  SID:number, PID:number, Quantity:number
  1, 1, 50
  1, 2, 69
  1, 4, 33
  2, 1, 42
  2, 3, 85
  3, 2, 12
  3, 3, 24
  3, 4, 36
  4, 3, 11
}