-- MySQL dump 10.13  Distrib 5.7.10, for Win64 (x86_64)
--
-- Host: localhost    Database: scuola
-- ------------------------------------------------------
-- Server version	5.7.10-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `argomento`
--
CREATE SCHEMA IF NOT EXISTS scuola_es11_popolato;
USE scuola_es11_popolato;

DROP TABLE IF EXISTS `argomento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `argomento` (
  `codice` int(11) NOT NULL AUTO_INCREMENT,
  `codice_materia` int(11) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `ore` tinyint(4) NOT NULL,
  PRIMARY KEY (`codice`,`codice_materia`),
  KEY `MateriaArgomento_idx` (`codice_materia`),
  CONSTRAINT `MateriaArgomento` FOREIGN KEY (`codice_materia`) REFERENCES `materia` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `argomento`
--

LOCK TABLES `argomento` WRITE;
/*!40000 ALTER TABLE `argomento` DISABLE KEYS */;
INSERT INTO `argomento` VALUES (1,1,'Algebra',20),(1,2,'Meccanica',50),(1,3,'Filosofia antica',60),(1,4,'Grammatica',80),(1,5,'Preistoria',20),(2,1,'Trigonometria',30),(2,2,'Termologia',20),(2,3,'Filosofia del Rinascimento',40),(2,4,'Letteratura',60),(2,5,'Storia romana',30),(3,1,'Geometria analitica',50),(3,2,'Elettricità e magnetismo',30),(3,4,'Filosofia moderna',50),(3,5,'Storia greca',50),(4,2,'Ottica',10);
/*!40000 ALTER TABLE `argomento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `classe`
--

DROP TABLE IF EXISTS `classe`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `classe` (
  `anno` tinyint(4) NOT NULL,
  `sezione` char(1) NOT NULL,
  PRIMARY KEY (`anno`,`sezione`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `classe`
--

LOCK TABLES `classe` WRITE;
/*!40000 ALTER TABLE `classe` DISABLE KEYS */;
INSERT INTO `classe` VALUES (1,'A'),(1,'B'),(1,'C'),(2,'A'),(2,'B'),(2,'C'),(3,'A'),(3,'B'),(3,'C'),(4,'A'),(4,'B'),(4,'C'),(5,'A'),(5,'B'),(5,'C');
/*!40000 ALTER TABLE `classe` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comune`
--

DROP TABLE IF EXISTS `comune`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comune` (
  `codice` int(11) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `regione` varchar(45) NOT NULL,
  PRIMARY KEY (`codice`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comune`
--

LOCK TABLES `comune` WRITE;
/*!40000 ALTER TABLE `comune` DISABLE KEYS */;
INSERT INTO `comune` VALUES (1,'Milano','Lombardia'),(2,'Sesto San Giovanni','Lombardia'),(3,'Cernusco sul Naviglio','Lombardia'),(4,'Cinisello Balsamo','Lombardia'),(5,'Bresso','Lombardia');
/*!40000 ALTER TABLE `comune` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `insegnamento`
--

DROP TABLE IF EXISTS `insegnamento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insegnamento` (
  `insegnante` char(16) NOT NULL,
  `codice_materia` int(11) NOT NULL,
  `classe_anno` tinyint(4) NOT NULL,
  `classe_sezione` char(1) NOT NULL,
  `ore_settimanali` tinyint(4) NOT NULL,
  PRIMARY KEY (`insegnante`,`codice_materia`,`classe_anno`,`classe_sezione`),
  KEY `DocenteMateriaClasse1_idx` (`insegnante`),
  KEY `DocenteMateriaClasse2_idx` (`codice_materia`),
  KEY `ClasseAnnoFK_1_idx` (`classe_anno`,`classe_sezione`),
  CONSTRAINT `ClasseAnnoFK_1` FOREIGN KEY (`classe_anno`, `classe_sezione`) REFERENCES `classe` (`anno`, `sezione`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `DocenteMateriaClasse1` FOREIGN KEY (`insegnante`) REFERENCES `insegnante` (`codice_fiscale`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `DocenteMateriaClasse2` FOREIGN KEY (`codice_materia`) REFERENCES `materia` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `insegnamento`
--

LOCK TABLES `insegnamento` WRITE;
/*!40000 ALTER TABLE `insegnamento` DISABLE KEYS */;
INSERT INTO `insegnamento` VALUES ('AGCKTZ76Z49X058M',5,3,'C',2),('OJXCLN61Q91T384M',4,2,'A',4),('VXEOHC51Y27Q747X',3,1,'B',3),('VXEOHC51Y27Q747X',5,1,'B',4),('YZHGKN69Z05Y066R',2,5,'B',3);
/*!40000 ALTER TABLE `insegnamento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `insegnamento_altra_scuola`
--

DROP TABLE IF EXISTS `insegnamento_altra_scuola`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insegnamento_altra_scuola` (
  `insegnante` char(16) NOT NULL,
  `codice_scuola` int(11) NOT NULL,
  PRIMARY KEY (`insegnante`,`codice_scuola`),
  KEY `InsegnanteAltraScuola_idx` (`insegnante`),
  KEY `AltraScuola_idx` (`codice_scuola`),
  CONSTRAINT `AltraScuola` FOREIGN KEY (`codice_scuola`) REFERENCES `scuola` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `InsegnanteAltraScuola` FOREIGN KEY (`insegnante`) REFERENCES `insegnante` (`codice_fiscale`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `insegnamento_altra_scuola`
--

LOCK TABLES `insegnamento_altra_scuola` WRITE;
/*!40000 ALTER TABLE `insegnamento_altra_scuola` DISABLE KEYS */;
INSERT INTO `insegnamento_altra_scuola` VALUES ('OJXCLN61Q91T384M',1);
/*!40000 ALTER TABLE `insegnamento_altra_scuola` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `insegnante`
--

DROP TABLE IF EXISTS `insegnante`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `insegnante` (
  `codice_fiscale` char(16) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `cognome` varchar(45) NOT NULL,
  `comune_residenza` int(11) NOT NULL,
  `comune_nascita` int(11) NOT NULL,
  PRIMARY KEY (`codice_fiscale`),
  KEY `ResidenzaInsegnante_idx` (`comune_residenza`),
  KEY `NascitaInsegnante_idx` (`comune_nascita`),
  CONSTRAINT `NascitaInsegnante` FOREIGN KEY (`comune_nascita`) REFERENCES `comune` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ResidenzaInsegnante` FOREIGN KEY (`comune_residenza`) REFERENCES `comune` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `insegnante`
--

LOCK TABLES `insegnante` WRITE;
/*!40000 ALTER TABLE `insegnante` DISABLE KEYS */;
INSERT INTO `insegnante` VALUES ('AGCKTZ76Z49X058M','Laura','Zuni',2,1),('OJXCLN61Q91T384M','Andrea','Liquori',1,4),('VXEOHC51Y27Q747X','Valerio','Scafati',1,3),('YZHGKN69Z05Y066R','Alice','Buzzi',2,2);
/*!40000 ALTER TABLE `insegnante` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `materia`
--

DROP TABLE IF EXISTS `materia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `materia` (
  `codice` int(11) NOT NULL,
  `nome` varchar(45) NOT NULL,
  PRIMARY KEY (`codice`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `materia`
--

LOCK TABLES `materia` WRITE;
/*!40000 ALTER TABLE `materia` DISABLE KEYS */;
INSERT INTO `materia` VALUES (1,'Matematica'),(2,'Fisica'),(3,'Filosofia'),(4,'Latino'),(5,'Storia');
/*!40000 ALTER TABLE `materia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parentela`
--

DROP TABLE IF EXISTS `parentela`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parentela` (
  `studente1` char(16) NOT NULL,
  `studente2` char(16) NOT NULL,
  `grado` varchar(45) NOT NULL,
  PRIMARY KEY (`studente1`,`studente2`),
  KEY `StudenteParente1_idx` (`studente1`),
  KEY `StudenteParente2_idx` (`studente2`),
  CONSTRAINT `StudenteParente1` FOREIGN KEY (`studente1`) REFERENCES `studente` (`codice_fiscale`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `StudenteParente2` FOREIGN KEY (`studente2`) REFERENCES `studente` (`codice_fiscale`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parentela`
--

LOCK TABLES `parentela` WRITE;
/*!40000 ALTER TABLE `parentela` DISABLE KEYS */;
/*!40000 ALTER TABLE `parentela` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `propedeuticita`
--

DROP TABLE IF EXISTS `propedeuticita`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `propedeuticita` (
  `materia` int(11) NOT NULL,
  `argomento_prima` int(11) NOT NULL,
  `argomento_dopo` int(11) NOT NULL,
  PRIMARY KEY (`materia`,`argomento_prima`,`argomento_dopo`),
  KEY `Argomento_prima_idx` (`materia`,`argomento_dopo`),
  KEY `Argomento_dopo_idx` (`materia`,`argomento_prima`),
  KEY `Argomento_prima` (`argomento_prima`,`materia`),
  KEY `Argomento_dopo` (`argomento_dopo`,`materia`),
  CONSTRAINT `Argomento_dopo` FOREIGN KEY (`argomento_dopo`, `materia`) REFERENCES `argomento` (`codice`, `codice_materia`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `Argomento_prima` FOREIGN KEY (`argomento_prima`, `materia`) REFERENCES `argomento` (`codice`, `codice_materia`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `propedeuticita`
--

LOCK TABLES `propedeuticita` WRITE;
/*!40000 ALTER TABLE `propedeuticita` DISABLE KEYS */;
INSERT INTO `propedeuticita` VALUES (1,2,3),(5,1,2);
/*!40000 ALTER TABLE `propedeuticita` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scuola`
--

DROP TABLE IF EXISTS `scuola`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scuola` (
  `codice` int(11) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `comune` int(11) NOT NULL,
  PRIMARY KEY (`codice`),
  KEY `ScuolaRisiede_idx` (`comune`),
  CONSTRAINT `ScuolaRisiede` FOREIGN KEY (`comune`) REFERENCES `comune` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scuola`
--

LOCK TABLES `scuola` WRITE;
/*!40000 ALTER TABLE `scuola` DISABLE KEYS */;
INSERT INTO `scuola` VALUES (1,'ITIS Primo Levi',1);
/*!40000 ALTER TABLE `scuola` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `studente`
--

DROP TABLE IF EXISTS `studente`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `studente` (
  `codice_fiscale` char(16) NOT NULL,
  `nome` varchar(45) NOT NULL,
  `cognome` varchar(45) NOT NULL,
  `comune_residenza` int(11) NOT NULL,
  `classe_anno` tinyint(4) NOT NULL,
  `classe_sezione` char(1) NOT NULL,
  `nazione` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`codice_fiscale`),
  KEY `ResidenzaStudente_idx` (`comune_residenza`),
  KEY `ClasseFK_idx` (`classe_anno`,`classe_sezione`),
  CONSTRAINT `ClasseFK` FOREIGN KEY (`classe_anno`, `classe_sezione`) REFERENCES `classe` (`anno`, `sezione`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ResidenzaStudente` FOREIGN KEY (`comune_residenza`) REFERENCES `comune` (`codice`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `studente`
--

LOCK TABLES `studente` WRITE;
/*!40000 ALTER TABLE `studente` DISABLE KEYS */;
INSERT INTO `studente` VALUES ('ADBIOL81A30S796J','Giovanni','Bianchi',3,5,'B',''),('ADWECF77B07Y866C','Marco','Brambilla',1,2,'B',''),('AGUKTZ66Z49X058M','Antonio','Iglesias',4,4,'B','Spagna'),('AKISNG83X18O788D','Lucia','Castelli',2,4,'C',''),('AWXLBM61E54F069O','Lucia','Castelli',2,1,'C',''),('AXMIKJ74X87A095O','Mario','Belli',3,5,'B',NULL),('AXMIUJ74X87A095O','Stefania','Belli',4,4,'B',''),('AZCLTP58M96R422C','Laura','Esposito',3,3,'C',''),('BFCSJZ59Q01B800H','Marco','Agostino',2,3,'B',''),('BKXPUY55X52L222Q','Marco','Belli',1,3,'A','Spagna'),('BLIGEQ08G30Q299Z','Alice','Agostino',5,1,'A',''),('BSDUEJ52B13M281F','Giovanni','Castelli',5,5,'C','Cina'),('BTZGCD94D44E846U','Stefania','Castelli',2,4,'B','Cina'),('BVJKPF36N28Q028Q','Giovanni','Esposito',5,4,'B',''),('BZAPQK76P67E657M','Mario','Rossi',5,4,'A',''),('CLHPUD31Y19U543V','Martina','Verdi',4,1,'C',''),('CUHTWF92A16A336A','Luca','Biondi',5,3,'A','Spagna'),('DAFVUB31W78Y456K','Alice Maria','Agostino',1,3,'B',NULL),('DAWVUB31W78Y456K','Alice','Agostino',1,2,'B',''),('DFVBIS89S46Q676O','Alice','Biondi',1,5,'B',''),('DUFPXK21F31H520F','Alice','Rossi',4,4,'C','Marocco'),('DURYME56V01K759Q','Marco','Esposito',1,3,'C',NULL),('DXORUT52S44I467Q','Giacomo','Esposito',4,4,'B',''),('ECWZRJ10D90W275Z','Giacomo','Verdi',4,4,'C',''),('ENUXPD21X83C537O','Mario','Belli',4,4,'B',''),('FCBKLY04H33A799K','Andrea','Castelli',2,1,'C',''),('FCYKLY04H33A799K','Andrea','Castelli',2,2,'C',NULL),('FIZYSO57Q27F116C','Stefania','Rossi',5,2,'C',''),('FPDYJL94O44Z480E','Martina','Biondi',1,2,'C',''),('FTAVJB53K73G296J','Giacomo','Agostino',2,3,'A',''),('GPSHMI95K19Z042E','Andrea','Rossi',3,1,'A','Spagna'),('GXIQDA98P52C156P','Marta','Rossi',3,3,'C','Albania'),('GYFQKU14V77K023F','Andrea','Bianchi',2,4,'C','Spagna'),('GZPFUC01I51N292S','Lucia','Belli',3,2,'A',''),('HGMASF41Y49T943C','Andrea','Belli',3,5,'A',''),('HUVBLP97H21B562I','Luca','Biondi',1,5,'A',''),('HVCOUQ16H56Z358C','Antonio','Brambilla',3,4,'A',''),('HVGOUQ16H56Z358C','Laura','Brambilla',4,5,'A',NULL),('HWKYIG25N54X649Y','Simone','Agostino',2,3,'A',''),('IDREGQ36N87U669Z','Giulia','Verdi',3,4,'B',''),('IGEZOQ48I48X171J','Martina','Biondi',4,5,'A',''),('IOBWKZ95D86A063A','Luca','Brambilla',5,5,'C',''),('IOGTVD21I38T179H','Giovanni','Verdi',2,5,'C',''),('IPOBQY34S76F997I','Alice','Esposito',3,5,'C',''),('IPSBGR64T77F726N','Andrea','Belli',3,3,'A',''),('IQSUMO44C78N777A','Giovanni','Agostino',5,1,'B',''),('IUKDJB75L59H082S','Lucia','Biondi',2,5,'B','Marocco'),('IVKMBW20W25V694H','Simone','Belli',2,4,'C',''),('JAFDKR50A73I902Z','Luca','Bianchi',5,5,'C',''),('JEBKQS95O69E867N','Marta','Belli',2,1,'B',''),('JKSBDO77N10I025P','Laura','Esposito',1,4,'C','Spagna'),('KUMVWO26O86R466Y','Lucia','Verdi',2,2,'C',''),('KUMVWO86O86R466Y','Lucia','Verdi',2,3,'C',NULL),('KVXFBA37G21T338W','Mario','Bianchi',5,5,'A',''),('LBUTYG33W25A254J','Marta','Agostino',4,4,'A',''),('LEIABV38L20S690G','Martina','Belli',4,4,'C',''),('LEUTYG33W25A254J','Marta','Agostino',3,5,'A',NULL),('LHQVPT11N08V884M','Stefania','Brambilla',1,4,'B',''),('LHRNMT29F89N706W','Stefania','Biondi',2,3,'A','Cina'),('LNPGXA87I97C615P','Stefania','Brambilla',5,1,'C',''),('LUZAXD58K26G246S','Alice','Brambilla',2,4,'B',''),('LVQTYC92N15Y771T','Luca','Biondi',2,1,'C',''),('MGBITX43W11M373E','Lucia','Verdi',4,2,'A',''),('MYAHEU34O53J064B','Martina','Brambilla',5,5,'B',''),('MZOIST70Z76L146H','Simone','Bianchi',1,2,'A',''),('NMHSAC96O69I033A','Luca','Biondi',4,2,'C',''),('NVQHSR20I62D339Q','Antonio','Rossi',4,1,'C',''),('NVQISR20I62D339Q','Antonio','Rossi',3,2,'C',NULL),('OGUKTZ66Z49X058M','Giulia','Agostino',3,3,'B',''),('OJXCLN51Q91T384N','Laura','Verdi',1,2,'A',''),('OJXCLN81Q91T384N','Antonio','Verdi',1,3,'A',NULL),('OQVZPR37O89K845E','Martina','Esposito',1,1,'B',''),('OWTLCS74X69X281W','Giacomo','Biondi',5,2,'C',''),('PKTBSQ60W80E050Q','Antonio','Brambilla',3,4,'A',''),('PKYNBT01N38T817Z','Andrea','Rossi',2,5,'C',''),('PVNFOZ00J05K396J','Antonio','Agostino',4,4,'A',''),('PZOJBL44Z58E910T','Giacomo','Rossi',5,2,'C',''),('QJLKUP49Y42L190K','Stefania','Esposito',4,4,'C',''),('QJLKUP99Y42L190K','Stefania','Esposito',4,5,'C',NULL),('QKNRPH69H48N615O','Mario','Agostino',5,4,'C',''),('RCDFKQ28G86F270O','Marta','Brambilla',5,2,'B',''),('RIJWEZ51N56E818K','Marco','Bianchi',1,1,'A',''),('RLNFJB58G89A959Z','Giovanni','Agostino',3,4,'B',''),('RNFMWA45F56H119Q','Marco','Esposito',5,3,'B',''),('RNIGUT14C35J314C','Luca','Belli',3,5,'C',''),('RWUYAF93S25C112Q','Martina','Biondi',4,3,'C',''),('SCNTHB56H40A190B','Laura','Esposito',3,3,'C',''),('SEMINB56I78N459P','Stefania','Verdi',1,4,'A',''),('SKHQWY81Z74P737M','Antonio','Rossi',5,4,'B',''),('SMJTZW28A52X025G','Laura','Belli',3,2,'B',''),('TNOCWL67C42K493T','Giulia','Esposito',2,5,'A',''),('UCGPML62K07K634S','Marco','Castelli',1,2,'C',''),('UCPONI43Z62P626L','Antonio','Brambilla',3,5,'B',''),('UDPZCX23Q22O635I','Mario','Belli',3,5,'C',''),('UHRYVC64W80J952F','Mario','Esposito',3,5,'A',''),('UWIBLA75L50B928R','Marco','Brambilla',4,2,'C',''),('VACNXP46G76H154M','Giovanni','Biondi',3,4,'C',''),('VEBJPA79O21R562S','Lucia','Esposito',3,2,'B',''),('VIMDRN55Z48X154B','Martina','Biondi',3,2,'B',''),('VXEAHC01Y27Q747J','Lucia','Biondi',2,1,'C',''),('VXEOHC01Y27Q747J','Lucia','Biondi',2,2,'C',NULL),('WCGTFE25L47Y569U','Giulia','Bianchi',3,1,'B','Marocco'),('WCRPOS55T22H305C','Giulia','Castelli',2,2,'B',''),('WDRPOS55T22H305C','Giulia','Castelli',2,3,'B',NULL),('WITDOC38O52T956O','Luca','Agostino',1,5,'B',''),('XDWUSB05P08G327Q','Giacomo','Brambilla',3,2,'A',''),('YROAIH49Q74D932O','Antonio','Brambilla',2,5,'B',''),('YSIGBE06A22P667E','Giovanni','Rossi',5,3,'A',''),('YZHGKN29Z05Y066R','Luca','Rossi',3,4,'B',''),('YZHGKN79Z05Y066R','Luca','Rossi',4,5,'B',NULL),('ZELYSF19Q65O941H','Giovanni','Verdi',5,4,'C',''),('ZERWLM39M65A835S','Giovanni','Castelli',1,4,'B',NULL),('ZERWLN39M65A835S','Giovanni','Castelli',1,3,'B',''),('ZPWHCF58O37J461F','Luca','Rossi',5,5,'C',''),('ZURYME56V01K759Q','Marco','Esposito',1,2,'C','');
/*!40000 ALTER TABLE `studente` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `valutazione`
--

DROP TABLE IF EXISTS `valutazione`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `valutazione` (
  `codice_argomento` int(11) NOT NULL,
  `codice_materia` int(11) NOT NULL,
  `studente` char(16) NOT NULL,
  `voto` decimal(10,0) NOT NULL,
  PRIMARY KEY (`codice_argomento`,`codice_materia`,`studente`),
  KEY `ArgomentoStudente1_idx1` (`codice_argomento`,`codice_materia`),
  KEY `ArgomentoStudente3_idx` (`studente`),
  CONSTRAINT `ArgomentoStudente1` FOREIGN KEY (`codice_argomento`, `codice_materia`) REFERENCES `argomento` (`codice`, `codice_materia`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `ArgomentoStudente3` FOREIGN KEY (`studente`) REFERENCES `studente` (`codice_fiscale`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `valutazione`
--

LOCK TABLES `valutazione` WRITE;
/*!40000 ALTER TABLE `valutazione` DISABLE KEYS */;
INSERT INTO `valutazione` VALUES (1,2,'DURYME56V01K759Q',8),(1,3,'AGUKTZ66Z49X058M',9),(1,3,'DAFVUB31W78Y456K',8),(1,3,'ZERWLM39M65A835S',7),(1,4,'AGUKTZ66Z49X058M',8),(1,5,'DAFVUB31W78Y456K',7),(2,2,'DURYME56V01K759Q',7),(2,4,'ZERWLM39M65A835S',8);
/*!40000 ALTER TABLE `valutazione` ENABLE KEYS */;
UNLOCK TABLES;


-- Dump completed on 2019-06-06 11:11:37
