--
-- nel Calculator, sostituire alla url attiva la seguente:
-- https://dbis-uibk.github.io/relax/calc/gist/73daa49ea7b05f5ea30acad21b1e0e83
-- in questo modo vien caricato il database PROVA 
-- 
-- creazione del database PROVA
group: DatabasePROVA 
DIPART = {
NUM_DIPART:number, NOME_DIPART:string, CITTA:string
15,'SICUREZZA','FIRENZE'
12,'AMBIENTE','MANTOVA'
10,'DIREZIONE','ROMA'
20,'RICERCHE','FIRENZE'
30,'VENDITE','MILANO'
40,'CONTABILITA','TORINO'
11,'PIANIFICAZIONE','ROMA'
50,'CONTROLLO','TORINO'
}
-- creazione della relazione DIPENDENTI
DIPENDENTI = {
MATRICOLA:number, NOME_IMP:string, MANSIONE:string, SUP:number, DATA_ASS:date, STIPENDIO:number, COMMISS:number, NUM_DIPART:number 
7369,'ORTU','IMPIEGATO',7902,1980-12-17,800000,NULL,20
7499,'VILLANI','VENDITORE',NULL,1981-02-20,1600000,300000,30
7521,'VILLA','VENDITORE',7698,1981-02-12,1250000,500000,30
7566,'FIRMANI','DIRIGENTE',7839,1981-12-31,2975000,NULL,20
7654,'MAGRINI','VENDITORE',7698,2001-09-30,1250000,1400000,30
7698,'ROSSI','DIRIGENTE',NULL,1981-05-15,2850000,NULL,30
7782,'NOVELLI','DIRIGENTE',7839,2006-03-24,2450000,NULL,10
7788,'GAGGI','ANALISTA',7566,1999-12-23,3000000,NULL,20
7839,'GIGLIO','PRESIDENTE',NULL,2001-12-12,5000000,NULL,10
7844,'ADRIANI','VENDITORE',7698,1981-05-24,1500000,0,30
7902,'ORLANDI','ANALISTA',7566,1982-08-30,900000,NULL,20
7934,'ZUCCHI','IMPIEGATO',7782,1980-11-12,1300000,NULL,10
7370,'ROSSI','FUNZIONARIO',7470,2003-01-23,850000,NULL,11
7470,'VERDI','FUNZIONARIO',7654,2000-10-10,1650000,300000,15
7471,'VILLA','VENDITORE',7788,1993-03-21,1250000,500000,11
7570,'VILLARI','DIRIGENTE',7370,1981-11-12,2975000,NULL,20
7670,'NEGRINI','FUNZIONARIO',NULL,1981-12-31,1250000,1400000,50
7675,'ROSSI','DIRIGENTE',NULL,1989-01-25,2850000,NULL,15
7770,'NERINI','DIRIGENTE',NULL,2002-05-21,2450000,NULL,50
7790,'GAGGIULO','DIRIGENTE',7566,2005-04-14,3000000,NULL,11
7800,'GIGLIOLI','PRESIDENTE',NULL,2001-01-12,5000000,NULL,11
7870,'ADRIANU','DIRIGENTE',7698,2005-08-31,1500000,0,50
7971,'ORLANDINI','ANALISTA',7566,2006-02-27,900000,NULL,20
7970,'ETTI','IMPIEGATO',7782,2003-10-11,1300000,NULL,10
7972,'MILANESI','ANALISTA',NULL,2010-10-11,1350000,NULL,NULL
}
-- creazione della relazione FORNITORI
FORNITORI = {COD:string, NOME:string, CITTA:string
'F001','ROSSI','MILANO'
'F002','NERI','ROMA'
'F003','BIANCHI','MILANO'
'F004','DONATI','ROMA'
'F015','MARIANO','VENEZIA'
'F116','GILARDI','VENEZIA'
'F217','VERDI','PARMA'
'F328','PUCCINI','LUCCA'
'F339','CUGINI',NULL
'F110','LUCINI','TORINO'
'F211','BIANCHI','TORINO'
'F130','BIZET','PAVIA'
'F313','MOSCONI','TORINO'
'F314','ANDREI',NULL
'F315','MONTELATICI','FIRENZE'
'F316','OTTOZ','AOSTA'
'F317','FRENI','MODENA'
'F218','VILLA','ROMA'
'F230','MOSCONI','ROMA'
'F332','ILLO','ROMA'
}
-- creazione della relazione PARTI
PARTI = {COD:STRING, NOME:string, COLORE:string, PESO:number, CITTA:string
'P034','RUOTA1', 'NERO', 120000, 'PARMA'
'P002','BULLONE','ROSSO', NULL, 'MILANO'
'P005','MICROFONO','BIANCO' , 340, 'GENOVA'
'P006','AURICOLARE','NERO' , 120, 'MILANO'
'P009','CORPO_TASTIERA','BEIGE' , 400, 'MILANO'
'P033','RUOTA2','ROSSO' , 140000, NULL
'P001','VITE','ROSSO', 10, 'ROMA'
'P004','CORNETTA',NULL, 900, 'ROMA'
'P007','TASTO','NERO' , 120, 'PAVIA'
'P008','TASTO','BIANCO' , 120, 'PAVIA'
'P010','APPOGGIO_TAST','BEIGE' , 920000, NULL
'P003','PENNINO','ROSSO' , 100, 'TORINO'
'P011','ADESIVO','METALLO' , 9, 'TORINO'
}
-- creazione della relazione PRODOTTI
PRODOTTI = {COD:string, NOME:string, CITTA:string
'PR01','TASTIERA_IBM','TORINO'
'PR02','TASTIERA_DEC',NULL
'PR03','SCHEDA_PC','MILANO'
'PR04','SCHEDA_COMP','ROMA'
'PR05','XT_IBM','ROMA'
'PR06','M24','TORINO'
'PR07','AT_IBM','PAVIA'
'PR08','MAC','TORINO'
'PR11','TASTIERA_WIRE','TORINO'
'PR12','TASTIERA_FLES','MILANO'
'PR13','SCHEDA_AUDIO','MILANO'
'PR14','SCHEDA_VIDEO','PAVIA'
'PR15','VAIO','LATINA'
'PR26','DELL','VENEZIA'
'PR37','CANON','PAVIA'
'PR58','NOKIA_SET','FIRENZE'
}
-- creazione della relazione FORNITURE
FORNITURE = {FCOD:string, PCOD:string, PRCOD:string, QUANTITA:number
'F003','P004','PR05', 100
'F001','P001','PR01', 100
'F001','P001','PR02', 50
'F218','P001','PR08', 200
'F230','P001','PR01', 3000
'F315','P001','PR01', 104
'F003','P006','PR07', 1980
'F003','P001','PR08', 9000
'F003','P001','PR01', 4000
'F313','P002','PR04', 204
'F313','P002','PR05', 124
'F130','P005','PR06', 440
'F317','P002','PR07', 6003
'F003','P002','PR08', 1400
'F116','P001','PR04', 1030
'F004','P001','PR06', 1003
'F004','P001','PR01', 1020
'F116','P001','PR01', 1008
'F230','P002','PR01', 344
'F230','P003','PR02', 2008
'F314','P001','PR03', 9008
'F314','P003','PR07', 1008
'F315','P006','PR01', 10000
'F316','P003','PR02', 90020
'F217','P004','PR03', 10
'F317','P007','PR04', 456899
'F116','P002','PR04', 1030
'F116','P001','PR03', 1003
'F116','P002','PR02', 1020
'F116','P007','PR01', 1008
'F315','P003','PR03', 344
'F230','P033','PR02', 2008
'F314','P033','PR03', 9008
'F314','P033','PR07', 1008
'F315','P033','PR01', 10000
'F001','P033','PR58', 90020
'F217','P001','PR58', 10
'F317','P008','PR58', 456899
}
-- creazione della relazione SPEDIZIONI
SPEDIZIONI = {SPCOD:string, DATASP:date, CITTADEST:string, CITTAPART:string, QTA_TOTALE:number
'SP01',2005-10-01,'MILANO','MILANO',200
'SP02',2005-11-01,'MILANO','TORINO',150
'SP03',2005-12-01,'TORINO','MILANO',300
'SP04',2005-10-02,'VENEZIA','BOLOGNA',10
'SP05',2006-10-01,'BOLOGNA','BOLOGNA',330
'SP06',2006-10-01,'VENEZIA','ROMA',50
'SP07',2007-01-01,'ROMA','NAPOLI',NULL
'SP08',2007-02-17,'ROMA','VENEZIA',1000
'SP09',2007-03-11,'NAPOLI','NAPOLI',2000}
-- creazione della relazione SPED__DETTAGLI
SPED_DETTAGLI = {SPCOD:string, FCOD:string, PCOD:string, PRCOD:string
'SP01','F003','P004','PR05'
'SP01','F001','P001','PR01'
'SP01','F001','P001','PR02'
'SP01','F218','P001','PR08'
'SP01','F230','P001','PR01'
'SP02','F315','P001','PR01'
'SP02','F003','P006','PR07'
'SP03','F003','P001','PR08'
'SP03','F003','P001','PR01'
'SP04','F313','P002','PR04'
'SP04','F313','P002','PR05'
'SP04','F130','P005','PR06'
'SP04','F317','P002','PR07'
'SP04','F003','P002','PR08'
'SP04','F116','P001','PR04'
'SP04','F004','P001','PR06'
'SP04','F004','P001','PR01'
'SP04','F116','P001','PR01'
'SP04','F230','P002','PR01'
'SP05','F230','P003','PR02'
'SP05','F314','P001','PR03'
'SP05','F314','P003','PR07'
'SP05','F315','P006','PR01'
'SP05','F316','P003','PR02'
'SP05','F217','P004','PR03'
'SP05','F317','P007','PR04'
'SP05','F116','P002','PR04'
'SP05','F116','P001','PR03'
'SP05','F116','P002','PR02'
'SP05','F116','P001','PR01'
'SP05','F315','P003','PR03'
'SP06','F230','P033','PR02'
'SP07','F314','P033','PR03'
'SP07','F314','P033','PR07'
'SP07','F315','P033','PR01'
'SP07','F001','P033','PR58'
'SP08','F217','P001','PR58'
'SP08','F317','P008','PR58'
}