-- create a table
CREATE TABLE studente (
  matricola int  PRIMARY KEY,
  nome VARCHAR (100),
  cognome VARCHAR (100)
);

CREATE TABLE corsorecupero ( 
    codice int PRIMARY KEY,
    materia VARCHAR (100),
    professore VARCHAR (100)
);

CREATE TABLE sc (
    id INT Primary KEY,
    matricola INT,
    codice INT,
    FOREIGN KEY (matricola) REFERENCES studente(matricola),
    FOREIGN KEY (codice) REFERENCES corsorecupero(codice)

    );

INSERT INTO studente VALUES
(1001, 'Marco', 'Rossi'),
(1002, 'Laura', 'Bianchi'),
(1003, 'Andrea', 'Verdi'),
(1004, 'Giulia', 'Neri');

INSERT INTO corsorecupero VALUES
(201, 'Matematica', 'Prof. Alfa'),
(202, 'Italiano', 'Prof.ssa Beta'),
(203, 'Inglese', 'Prof. Gamma'),
(204, 'Storia', 'Prof.ssa Delta');

INSERT INTO sc VALUES
(1, 1001, 201),
(2, 1001, 203),
(3, 1002, 202),
(4, 1003, 201),
(5, 1003, 204),
(6, 1004, 202);
    
SELECT * FROM studente;
SELECT * FROM corsorecupero;
SELECT * FROM sc;