CREATE TABLE DB_Orario.Aule (
  CodAula VARCHAR(4) NOT NULL,
  Polo VARCHAR(2) NOT NULL,
  Piano INTEGER UNSIGNED NOT NULL DEFAULT 0,
  Numero INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY(CodAula)
)
ENGINE = InnoDB;

CREATE TABLE DB_Orario.Orario (
  CodAula VARCHAR(4) NOT NULL,
  Giorno VARCHAR(9) NOT NULL DEFAULT '',
  Ora VARCHAR(5)NOT NULL DEFAULT '',
  CodCorso INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY(CodAula, Giorno, Ora)
)
ENGINE = InnoDB;

CREATE TABLE DB_Orario.Corso (
  CodCorso INTEGER UNSIGNED NOT NULL DEFAULT 0,
  Nome VARCHAR(45) NOT NULL,
  CodLaurea INTEGER UNSIGNED NOT NULL DEFAULT 0,
  Gruppo VARCHAR(2), 
  Anno INTEGER UNSIGNED NOT NULL DEFAULT 0,
  MatricolaDocente INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY(CodCorso)
)
ENGINE = InnoDB;

CREATE TABLE DB_Orario.CorsoLaurea (
 CodLaurea INTEGER UNSIGNED NOT NULL DEFAULT 0,
 Nome VARCHAR(45) NOT NULL,
 MatrPresidente INTEGER UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY(CodLaurea)
)
ENGINE = InnoDB;

CREATE TABLE DB_Orario.Propedeuticita (
  CodCorsoPrima INTEGER UNSIGNED NOT NULL DEFAULT 0,
  CodCorsoDopo INTEGER UNSIGNED NOT NULL DEFAULT 0,
  PRIMARY KEY(CodCorsoPrima, CodCorsoDopo)
)
ENGINE = InnoDB;

CREATE TABLE DB_Orario.Professore (
  Matricola INTEGER UNSIGNED NOT NULL DEFAULT 0,
  Nome VARCHAR(45) NOT NULL,
  Dipartimento VARCHAR(45) NOT NULL,
  PRIMARY KEY(Matricola)
)
ENGINE = InnoDB;

INSERT INTO DB_Orario.CorsoLaurea
VALUES ('01', 'Ingegneria Elettronica', '020');
INSERT INTO DB_Orario.CorsoLaurea
VALUES ('02', 'Ingegneria Informatica', '019');


INSERT INTO DB_Orario.Aule
VALUES ('PN4', 'PN', '0', '4');
INSERT INTO DB_Orario.Aule
VALUES ('B21', 'B', '2', '1');
INSERT INTO DB_Orario.Aule
VALUES ('A28', 'A', '2', '8');
INSERT INTO DB_Orario.Aule
VALUES ('C01', 'C', '0', '1');
INSERT INTO DB_Orario.Aule
VALUES ('A23', 'A', '2', '3');
INSERT INTO DB_Orario.Aule
VALUES ('PN3', 'PN', '0', '3');
INSERT INTO DB_Orario.Aule
VALUES ('C32', 'C', '3', '2');
INSERT INTO DB_Orario.Aule
VALUES ('C41', 'C', '4', '1');
INSERT INTO DB_Orario.Aule
VALUES ('C43', 'C', '4', '3');
INSERT INTO DB_Orario.Aule
VALUES ('B31', 'B', '3', '1');
INSERT INTO DB_Orario.Aule
VALUES ('B32', 'B', '3', '2');
INSERT INTO DB_Orario.Aule
VALUES ('A31', 'A', '3', '1');
INSERT INTO DB_Orario.Aule
VALUES ('B24', 'B', '2', '4');
INSERT INTO DB_Orario.Aule
VALUES ('A21', 'A', '2', '1');
INSERT INTO DB_Orario.Aule
VALUES ('C21', 'C', '2', '1');
INSERT INTO DB_Orario.Aule
VALUES ('B11', 'B', '1', '1');
INSERT INTO DB_Orario.Aule
VALUES ('C31', 'C', '3', '1');
INSERT INTO DB_Orario.Aule
VALUES ('B25', 'B', '2', '5');
INSERT INTO DB_Orario.Aule
VALUES ('A22', 'A', '2', '2');
INSERT INTO DB_Orario.Aule
VALUES ('A25', 'A', '2', '5');
INSERT INTO DB_Orario.Aule
VALUES ('A26', 'A', '2', '6');
INSERT INTO DB_Orario.Aule
VALUES ('A27', 'A', '2', '7');
INSERT INTO DB_Orario.Aule
VALUES ('A13', 'A', '1', '3');
INSERT INTO DB_Orario.Aule
VALUES ('A14', 'A', '1', '4');
INSERT INTO DB_Orario.Aule
VALUES ('B22', 'B', '2', '2');
INSERT INTO DB_Orario.Aule
VALUES ('B26', 'B', '2', '6');
INSERT INTO DB_Orario.Aule
VALUES ('C42', 'C', '4', '2');
INSERT INTO DB_Orario.Aule
VALUES ('A32', 'A', '3', '2');
INSERT INTO DB_Orario.Aule
VALUES ('C12', 'C', '1', '2');
INSERT INTO DB_Orario.Aule
VALUES ('C11', 'C', '1', '1');
INSERT INTO DB_Orario.Aule
VALUES ('PN5', 'PN', '0', '5');
INSERT INTO DB_Orario.Aule
VALUES ('PN2', 'PN', '0', '2');

INSERT INTO DB_Orario.Corso
VALUES ('001', 'Elettrotecnica', '01', '00', '2', '002');
INSERT INTO DB_Orario.Corso
VALUES ('002', 'Informatica e Calcolatori', '01', '00', '2', '003');
INSERT INTO DB_Orario.Corso
VALUES ('003', 'Fondamenti di Automatica', '01', '00', '2', '004');
INSERT INTO DB_Orario.Corso
VALUES ('004', 'Componenti e Circuiti Elettronici', '01', '00', '2', '005');
INSERT INTO DB_Orario.Corso
VALUES ('006', 'Fisica Generale', '01', '00', '1', '006');
INSERT INTO DB_Orario.Corso
VALUES ('007', 'Architetture dei Sistemi Elettronici', '01', '00', '1', '007');
INSERT INTO DB_Orario.Corso
VALUES ('008', 'Analisi I e Algebra Lineare', '01', '00', '1', '001');
INSERT INTO DB_Orario.Corso
VALUES ('009', 'Circuiti Elettronici Analogici e Digitali', '01', '00', '3', '008');
INSERT INTO DB_Orario.Corso
VALUES ('010', 'Sistemi Elettronici Programmabili', '01', '00', '3', '009');
INSERT INTO DB_Orario.Corso
VALUES ('011', 'Campi Elettromagnetici', '01', '00', '3', '010');
INSERT INTO DB_Orario.Corso
VALUES ('012', 'Dispositivi e Tecnologie Elettroniche', '01', '00', '3', '011');
INSERT INTO DB_Orario.Corso
VALUES ('013', 'Complementi di Fisica', '01', '00', '3', '006');
INSERT INTO DB_Orario.Corso
VALUES ('014', 'Elettronica Industriale', '01', '00', '3', '012');
INSERT INTO DB_Orario.Corso
VALUES ('015', 'Matematica', '02', 'AK', '1', '013');
INSERT INTO DB_Orario.Corso
VALUES ('016', 'Fondamenti Informatica I', '02', 'AK', '1', '015');
INSERT INTO DB_Orario.Corso
VALUES ('017', 'Matematica', '02', 'LZ', '1', '014');
INSERT INTO DB_Orario.Corso
VALUES ('018', 'Fondamenti Informatica I', '02', 'LZ', '1', '016');
INSERT INTO DB_Orario.Corso
VALUES ('019', 'Reti Logiche', '02', '00', '2', '017');
INSERT INTO DB_Orario.Corso
VALUES ('020', 'Elettrotecnica', '02', '00', '2', '018');

INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '8.30', '001');
INSERT INTO DB_Orario.Orario
VALUES ('C31', 'Martedi', '10.30', '001');
INSERT INTO DB_Orario.Orario
VALUES ('C31', 'Martedi', '11.30', '001');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Venerdi', '8.30', '001');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Venerdi', '9.30', '001');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '9.30', '002');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '10.30', '002');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '12.30', '002');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Venerdi', '13.30', '002');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Venerdi', '14.30', '002');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '13.30', '003');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '14.30', '003');
INSERT INTO DB_Orario.Orario
VALUES ('PN4', 'Lunedii', '9.30', '003');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Venerdi', '10.30', '003');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Venerdi', '11.30', '003');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '15.30', '004');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '16.30', '004');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Lunedi', '17.30', '004');
INSERT INTO DB_Orario.Orario
VALUES ('C31', 'Martedi', '8.30', '004');
INSERT INTO DB_Orario.Orario
VALUES ('C31', 'Martedi', '9.30', '004');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Martedi', '9.30', '006');
INSERT INTO DB_Orario.Orario
VALUES ('PN5', 'Mercoledi', '8.30', '006');
INSERT INTO DB_Orario.Orario
VALUES ('PN5', 'Mercoledi', '9.30', '006');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '8.30', '006');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '9.30', '006');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Martedi', '13.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Martedi', '11.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Martedi', '12.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('B21', 'Mercoledi', '13.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('B21', 'Mercoledi', '14.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('B21', 'Mercoledi', '15.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '14.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '15.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Sabato', '10.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Sabato', '11.30', '007');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Martedi', '8.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '10.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '11.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '16.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Venerdi', '17.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Sabato', '8.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A31', 'Sabato', '9.30', '008');
INSERT INTO DB_Orario.Orario
VALUES ('A27', 'Lunedi', '8.30', '009');
INSERT INTO DB_Orario.Orario
VALUES ('A27', 'Lunedi', '9.30', '009');
INSERT INTO DB_Orario.Orario
VALUES ('A27', 'Lunedi', '10.30', '009');
INSERT INTO DB_Orario.Orario
VALUES ('A14', 'Mercoledi', '10.30', '009');
INSERT INTO DB_Orario.Orario
VALUES ('A14', 'Mercoledi', '11.30', '009');
INSERT INTO DB_Orario.Orario
VALUES ('A27', 'Lunedi', '11.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('A27', 'Lunedi', '12.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('B26', 'Mercoledi', '14.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('B26', 'Mercoledi', '15.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('B26', 'Mercoledi', '16.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('B26', 'Giovedi', '13.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('B26', 'Giovedi', '14.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('B26', 'Giovedi', '15.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('C12', 'Venerdi', '10.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('C12', 'Venerdi', '11.30', '010');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Lunedi', '14.30', '011');
INSERT INTO DB_Orario.Orario
VALUES ('C42', 'Giovedi', '10.30', '011');
INSERT INTO DB_Orario.Orario
VALUES ('C42', 'Giovedi', '11.30', '011');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Venerdi', '13.30', '011');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Venerdi', '14.30', '011');
INSERT INTO DB_Orario.Orario
VALUES ('B25', 'Martedi', '10.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('B25', 'Martedi', '11.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Mercoledi', '10.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Mercoledi', '11.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Giovedi', '13.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Giovedi', '14.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Venerdi', '15.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A25', 'Venerdi', '16.30', '012');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Martedi', '8.30', '013');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Mercoledi', '8.30', '013');
INSERT INTO DB_Orario.Orario
VALUES ('A13', 'Mercoledi', '9.30', '013');
INSERT INTO DB_Orario.Orario
VALUES ('C41', 'Giovedi', '8.30', '013');
INSERT INTO DB_Orario.Orario
VALUES ('C41', 'Giovedi', '9.30', '013');
INSERT INTO DB_Orario.Orario
VALUES ('B22', 'Mercoledi', '8.30', '014');
INSERT INTO DB_Orario.Orario
VALUES ('B22', 'Mercoledi', '9.30', '014');
INSERT INTO DB_Orario.Orario
VALUES ('C42', 'Giovedi', '9.30', '014');
INSERT INTO DB_Orario.Orario
VALUES ('A32', 'Venerdi', '8.30', '014');
INSERT INTO DB_Orario.Orario
VALUES ('A32', 'Venerdi', '9.30', '014');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Martedi', '8.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Martedi', '9.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Mercoledi', '14.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Mercoledi', '15.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Mercoledi', '16.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Giovedi', '13.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Giovedi', '14.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Sabato', '11.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Sabato', '12.30', '015');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Martedi', '10.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Martedi', '11.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Mercoledi', '10.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Mercoledi', '11.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Mercoledi', '12.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Sabato', '9.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A28', 'Sabato', '10.30', '016');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Martedi', '10.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Martedi', '11.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Mercoledi', '15.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Mercoledi', '16.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Giovedi', '10.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Giovedi', '11.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Giovedi', '12.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Sabato', '11.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Sabato', '12.30', '017');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Martedi', '14.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Martedi', '15.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Martedi', '16.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Mercoledi', '11.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Mercoledi', '12.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Sabato', '9.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('A26', 'Sabato', '10.30', '018');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Martedi', '9.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Martedi', '10.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Mercoledi', '9.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Mercoledi', '10.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Giovedi', '10.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Giovedi', '11.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Venerdi', '12.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Venerdi', '15.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Venerdi', '16.30', '019');
INSERT INTO DB_Orario.Orario
VALUES ('B11', 'Martedi', '11.30', '020');
INSERT INTO DB_Orario.Orario
VALUES ('B11', 'Martedi', '12.30', '020');
INSERT INTO DB_Orario.Orario
VALUES ('B11', 'Mercoledi', '11.30', '020');
INSERT INTO DB_Orario.Orario
VALUES ('B11', 'Mercoledi', '12.30', '020');
INSERT INTO DB_Orario.Orario
VALUES ('B11', 'Giovedi', '13.30', '020');
INSERT INTO DB_Orario.Orario
VALUES ('B11', 'Giovedi', '14.30', '020');
INSERT INTO DB_Orario.Orario
VALUES ('B31', 'Venerdi', '14.30', '020');

INSERT INTO DB_Orario.Propedeuticita
VALUES ('015', '020');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('017', '020');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('016', '019');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('018', '019');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('006', '001');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('002', '007');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('008', '003');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('006', '004');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('007', '009');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('007', '010');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('006', '011');
INSERT INTO DB_Orario.Propedeuticita
VALUES ('004', '012');

INSERT INTO DB_Orario.Professore
VALUES ('001', 'Mario Poletti', 'Matematica Applicata');
INSERT INTO DB_Orario.Professore
VALUES ('002', 'Antonio Longo', '000');
INSERT INTO DB_Orario.Professore
VALUES ('003', 'Lanfranco Lopriore', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('004', 'Alberto Landi', 'Sistemi Elettrici e Automazione');
INSERT INTO DB_Orario.Professore
VALUES ('005', 'Paolo Bruschi', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('006', 'Mauro Morganti', 'Fisica');
INSERT INTO DB_Orario.Professore
VALUES ('007', 'Pierangelo Terreni', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('008', 'Fernando De Bernardinis', '000');
INSERT INTO DB_Orario.Professore
VALUES ('009', 'Stefano Di Pascoli', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('010', 'Paolo Nepa', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('011', 'Alessandro Diligenti', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('012', 'Giovanni Marola', 'Inegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('013', 'Luigi Carlo Berselli', 'Matematica Applicata');
INSERT INTO DB_Orario.Professore
VALUES ('014', 'Placido Longo', 'Matematica Applicata');
INSERT INTO DB_Orario.Professore
VALUES ('015', 'Francesco Marcelloni', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('016', 'Cinzia Bernardeschi', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('017', 'Paolo Corsini', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('018', 'Antonino Musolino', 'Sistemi Elettrici e Automazione');
INSERT INTO DB_Orario.Professore
VALUES ('019', 'Graziano Frosini', 'Ingegneria Informazione');
INSERT INTO DB_Orario.Professore
VALUES ('020', 'Roberto Saletti', 'Ingegneria Informazione');






















