Caso Deportes

/*PERS (Personas)  =  {Dni, Nom, Sexo, Edad, Dir, Tel, Zona}
DEPO (Deportes)  = {Codd, Nomd, Clase}
CLUB (Clubes)    =  {Codc, Nomc, Dir, Tel, Cat, Zona}
PRAC (Practican) =  {Dni, Codd, Codc}*/

group: deporte
PERS = {Dni:number, Nom:string, Sexo:string, Edad:number,Dir:string,Tel:string,Zona:string
35678900,'Juan Perez','M',33,'Libertador 340 (E)','4234560','Capital'
40222333,'María Castro','F',28,'Salta 560(N)','4305060','Capital'
34567890, 'Ariel Gonzalez','M',25,'Mendoza 1780(S)','4209080','Rawson'
33444567, 'Ian Mendez','M',22,'Pringles 457(S)','4221190','Chimbas'
38444567, 'Morena Torrez','F',34,'San Luis 590(E)','4309077','Caucete'
37444567, 'Morena Torrez','F',35,'Córdoba 234(E)','4209027','Rivadavia'
40200400, 'Pedro Torrez','M',24,'Córdoba 234(E)','4209027','Rivadavia'
40500600, 'Camila Páez','F',23,'Las Moreras 3450(N)','4309027','Rivadavia'
41200900, 'Karen García','F',21,'San Lorenzo','4234511','Desamparados'
20498425,'Juan Perez','M',50,'Fray Justo 678(N)','4334455','Capital'
18498425,'Ana García','F',54,'Salta 560(N)','4335566','Capital'
17490495,'Felipe Castro','M',56,'Santiago del Estero 670 (o)','4300096','Ullúm'
  }

DEPO = {Codd:string, Nomd:string, Clase:string
'D01','Fútbol','Balón'
'D02','Básquet','Balón'
'D03','Hockey sobre césped','Balón'
'D04','Tenis','Balón'
'D05','Natación','Atlético'
'D06','Kitesurf','Agua'
'D10','Boxeo','Combate'
'D22','Kick Boxing','Combate'
'D30','Trekking','Montaña'
}

CLUB =  {Codc:number,Nomc:string, Dir:string,Tel:string, Cat:number, Zona:string
100,'Ausonia','Av. José Ignacio de la Roza Oeste 2174','4356090',1,'Rivadavia'
200,'Banco Hispano','Paula Albarracín de Sarmiento Sur','4231860',2,'Capital'
300,'Kayak Club','Ruta Del Sol','4406865',1,'Rivadavia'
400,'Sportivo Desamparados','Echeverría Norte 99','4456723',1,'Desamparados'
500,'Club Julio Mocoroa','Mendoza Norte 585-667','4212687',2,'Rawson'
600,'UVT','Abraham Tapia 1380','4214716',2,'Rawson'
}

PRAC =  {Dni:number,Codd:string,Codc:number
35678900,'D01',100
35678900,'D01',200
35678900,'D02',200
40222333,'D01',100
40222333,'D04',200
40222333,'D06',300
40500600,'D05',100
35678900,'D02',100
35678900,'D03',100
35678900,'D04',100
35678900,'D05',100
35678900,'D05',100
41200900,'D01',100
41200900,'D02',100
41200900,'D04',100
41200900,'D03',100
20498425,'D06',100
20498425,'D06',200
20498425,'D06',300
17490495,'D10',600
17490495,'D22',600
41200900,'D10',100
41200900,'D10',200
41200900,'D10',300
41200900,'D10',400
41200900,'D10',500
41200900,'D10',600
41200900,'D22',100
35678900,'D10',100
35678900,'D22',100
17490495,'D30',300
35678900,'D30',300
35678900,'D06',100
}