caso6-diego

group: Caso6


Pers = {
	dni:number, telp:number, mail:string
	1, 10, 1.com
	2, 20, 2.com
	3, 30, 3.com
	4, 40, 4.com
	5,50,5.com
}

Teatro = {
	codt:number, nomt:string, dirt:string, telt:number, cap:number, prov:string
	1, TetroDelBicentnario, dir1, 11, 500, SanJuan
	2, LaQuintanilla, dir1, 11, 500, Mendoza
	3, teatro3, dir1, 11, 200, SanLuis
	4, teatro4, dir1, 11, 100, LaRioja
	5, teatro5, dir1, 11, 500, Cordoba
}

Esp = {
	code:number, nome:string, autor:string, tipo:string
	1, Unpianistabrillante, autor1, obra
	2, e2, autor1, concierto
	3, e3, autor1, concierto
	4, e4, autor1, tipo1
}
Tiene = {
	codt:number, code:number, fi:date, ff:date, precio:number
	1,1,2012-12-12, 2012-12-13, 500
	1,2,2012-12-12, 2012-12-13, 600
	1,3,2012-12-12, 2012-12-13, 500
	2,1,2018-04-12, 2018-05-13, 600
	2,3,2012-12-12, 2012-12-13, 550
	3,2,2012-12-12, 2012-12-13, 500
	4,2,2012-12-12, 2012-12-13, 500
	5,4,2012-12-12, 2012-12-13, 500
}

Compra = {
	dni:number, codt:number, code:number, fc:date, precio:number
	1,1,1,2012-12-13,500
	1,1,2,2012-12-13,500
	1,2,1,2012-12-13,500
	4,1,3,2012-12-13,500
	2,3,1,2012-12-13,500
	4,2,3,2013-12-12,800
	5,1,1,2012-12-12,500
	5,1,2,2012-12-12,600
	5,1,3,2012-12-12,550
	5,2,1,2012-12-12,500
	5,2,3,2012-12-12,550
	5,3,2,2012-12-12,600
	5,4,2,2012-12-12,600
	5,5,4,2012-12-12,500
}