civera2

group: controlparcial2
EMP = {
cod:number,nombre:string,nomp:string
1,"Muxo","Argentina"
2,"Photojam","Ireland"
3,"Myworks","Argentina"
4,"Tavu","United States"
5,"Oyondu","Argentina"
6,"Latz","United Kingdom"
7,"Feedfire","United Kingdom"

civera2

group:anuncios
AnuncioEmp={num:number,fecha:date,descripcion:string,cantv:number,edadmax:number,edadmin:number,monto:number,canth:number, provincia:string,cuit:string,pais:string,cod:number
100,2020-02-14,'Tareas de mantenimiento',3,45,18,35000,8,'San Juan','20-12349094-3','Argentina', 1
101,2020-02-14,'Relevamiento-Pruebas',2,30,20,47000,8,'San Juan','20-12349094-3','Argentina', 2
102,2020-06-19,'Tareas de mantenimiento',1,40,22,36000,6,'Mendoza','20-12349094-3','Argentina', 1
103,2020-06-19,'Tareas administrativas',3,35,18,47000,8,'San Juan','20-12349094-3','Argentina', 3
200,2020-02-14,'Tareas de mantenimiento',3,40,21,38000,7,'Mendoza','21-24890234-1','Argentina', 1 
201,2020-02-14,'Tareas de mantenimiento',1,35,21,49000,8,'Córdoba','21-24890234-1','Argentina', 1
301,2020-02-14,'Tareas de mantenimiento',10,35,21,39000,8,'Córdoba','23-23345678-0','Chile', 1
}

civera2

group: Parcial2
Persona= {nom:string,  fechanac:date
 'Keanu Reeves', 1964-03-23
 'Carrie-Anne Moss', 1967-03-29
  'Hugo Weaving', 1960-03-30
  'Emil Eifrem', 1978-10-20
  'Al Pacino', 1940-10-20
   'Charlize Theron', 1975-10-20
   'Lilly Wachowski', 1967-05-27
   'Taylor Hackford', 1944-08-13

civera2

group:algebra

X = {P, Q, R
10,a,5
15,b,8
25,a,6
}
Z = {A, B, C
10,b,6
25,c,3

civera2

group:empresa
Sucursal= {num:number, direcc:string,tel:string,provincia:string
100,'San Luis 104(E)','264-6555000','San Juan'
101,'Av Libertador 450(O)','264-6345022','San Juan'
200,'Salta 3109(E)','261-6555002','Mendoza'
201,'Caseros 45(S)','261-6555000','Mendoza'
300,'Victoria 489(N)','2652-6555000','San Luis'
301,'Rioja 104(E)','2652-5644001','San Luis'
400,'Estado de Israel(E)','351-5644351','Córdoba'
}

civera2

group: evaluaciones 

alu = {regi:number, nyap:string, local:string, sexo:string
1,'mariano','capital','m'
2,'guadalupe','capital','f'
3,'florencia','santa lucia','f'
4,'miguel','rawson','m'
5,'elmo','rivadavia','m'
}

civera2

group: Caso2 

alu = {
	dni:number, nomAlu:string, dir:string, tel:string 
	10, Jose, "Rioja 234 (s)", 154054675
	20, Ana, "Mendoza 23 (n)", 154054679
	30, Luis, "Gral Paz 56(e)", 154054676
        40, Leonel, "Gral Acha 33 (n)", 15567895
        50, Sabrina, "Pedro de Valdivia 78", 15567892
        60, Trump, "Catamarca 44", 15567896

civera2

group: caso6
Tar = {
num:number, monto:number, dni:number, nombre:string, prov:string
100, 450, 35678900, 'Juan Perez', 'San Juan'
102, 678, 40222333, 'María Castro', 'Córdoba'
103, 450, 34567890, 'Ariel Gonzalez', 'San Juan'
344, 234, 33444567, 'Ian Mendez', 'San Juan'
345, 239, 38444567, 'Morena Torrez', 'San Luis'
500, 450, 34567890, 'Ariel Gonzalez', 'San Juan'
  }

civera2

group: Caso6

Eq = {
	codeq:number, nombre:string,cant_copas:number, pais:string
	10, "Real Madrid", 26, "España"
	20, "AL-AHLY", 24, "Egipto" 
	30, "Boca Juniors", 18, "Argentina"
	40, "Milan", 18, "Italia"
	50, "Independiente", 18, "Argentina"
	60, "Barcelona", 17, "España"

civera2

/*
Pla (Planeta) = {nomp, fechadesc (fecha de descubrimiento), cantal(cantidad de años luz del sol)}
As(Astrónomo) = {nomas, paisnac, fecha-nac, uni (universidad)}
D(Descubrió) = {nomp (planeta), nomas (astrónomo)}
S (Satélite) = {cods, nom (nombre), nomas (nombre del astrónomo que lo bautizó), fechadesc (fecha de descubrimiento), planeta (nombre del planeta)}

*/
group:Planetas
Pla  = {nomp:string, fechadesc:date, cantal:number
        'TRAPPIST-1b',2017-03-23,10