caso5

group: Recargas y viajes tarjeta SUBE

Tar = {
        num:number, monto:number, dni:number, nombre:string, prov:string
        001       , 100         , 39026     , 'Guille'       , 'San Juan'
        002       , 150         , 39027     , 'Franco'       , 'San Juan'
        003       , 75          , 40028     , 'Luis'         , 'San Luis'
        004       , 150         , 40029     , 'Martin'       , 'Mendoza'
        005       , 150         , 40402     , 'Eusebio'      , 'San Juan'
      }
      
LIN = {
       codlinea:string, cuit:number
       '17'  ,   2001
       '40'  ,   2001
       '36'  ,   2002
       '26A' ,   2004
       '16'  ,   2003
       '17'  ,   2003
       '26A' ,   2005
       }
       
EMP = { 
        cuit:number, nom_emp:string, direc:string, prov:string
        2001       , 'La Positiva', 'Brasil 123', 'San Juan'
        2002       , 'El Triunfo' , 'Ella 456'  , 'San Juan'
        2003       , 'Santa Maria', 'Japish 789' , 'San Luis'
        2004       , 'Mayo'       , '25 de mayo 321', 'San Juan'
        2005       , 'Fonobus'    , 'Av. San Martin 10' 'Cordoba'
        }
        
V = {
      num:number,fecha:date,hora:number,codlinea:string,cuit:number,importe:number
      001 , 2016-03-02, 15.03, '36', '2002', 3.20
      002 , 2016-03-02, 17.15, '26A', '2004', 13.12
      002 , 2016-03-02, 18.15, '26A', '2004', 13.12
      001 , 2016-03-02, 17.25, '26A', '2004', 3.20
      004 , 2016-03-02, 19.50, '17', '2001', 3.20
      004 , 2016-03-02, 21.30, '17', '2001', 3.20
      003 , 2016-04-02, 17.30, '17' , '2003', 4.30
      003 , 2016-04-02, 19.45, '17' , '2003', 4.30
      001 , 2016-05-02, 15.00, '40' , '2001', 3.20
      003 , 2016-06-02, 15.00, '26A', '2004', 3.20
      003 , 2016-06-02, 15.30, '26A', '2004', 3.20
      001 , 2016-07-02, 15.03, '17', '2001', 3.20
      001 , 2016-07-02, 16.03, '36', '2002', 3.20
      001 , 2016-08-02, 15.03, '26A', '2004', 3.20
      005 , 2016-08-02, 4.00, '26A', '2005', 3.20
      
      }