Toy data set for Database Systems I at LMU Munich

LTP

group: LTP 


L = {
	lnr:string, lname:string, status:number, sitz:string
	l1, Meier, 20, Wetter
	l2, Mueller, 10, Berlin
	l3, Schmidt, 50, Berlin
	l4, Schulz, 30, Wetter
	l5, Krause, 40, Meschede
}

T = {
	tnr:string, tname:string, farbe:string, gewicht:number
	t1, Stecker, rot, 15
	t2, Kabel, blau, 27
	t3, Schalter, weiss, 05
	t4, 8080, rot, 02
	t5, Diskette, blau, 12
	t6, Schraube, rot, 03
}

P = {
	pnr:string, pname:string, ort:string
	p1, Ufo, Berlin
	p2, Pleite, Bonn
	p3, CPU, Meschede
	p4, Kaese, Meschede
	p5, Post, Wetter
	p6, Software, Essen
	p7, Knall, Wetter
	P8, Umzug, Berlin
}

LTP = {
	lnr:string, tnr:string, pnr:string, menge:number
	l1, t1, p8, 1200
	l1, t1, p1, 200
	l1, t1, p4, 700
	l1, t4, p1, 300
	l1, t6, p1, 200
	l2, t3, p1, 400
	l2, t3, p2, 200
	l2, t3, p3, 200
	l2, t3, p4, 500
	l2, t3, p5, 600
	l2, t3, p6, 400
	l2, t3, p7, 800
	l2, t3, p8, 300
	l2, t5, p2, 100
	l3, t3, p1, 200
	l3, t4, p2, 500
	l4, t6, p3, 300
	l4, t6, p7, 300
	l5, t2, p2, 200
	l5, t2, p4, 100
	l5, t5, p5, 500
	l5, t5, p7, 100
	l5, t6, p2, 200
	l5, t1, p4, 1000
	l5, t3, p4, 1200
	l5, t4, p4, 800
	l5, t5, p4, 400
	l5, t6, p4, 500
}