Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- BANDO-CONCORSO 1-N
- COMMISSIONE-CONCORSO 1-N
- CONCORSO-PROVA 1-N
- CANDIDATO-PROVA N-N HASOSTENUTO
- CONCORSO-CANDIDATO N-N FADOMANDA
- COMMISSIONE-COMMISSARIO 1-N
- <CREATE TABLE> Bando(
- CodBando INT(6) NOTNULL;
- DataPub INT(8);
- DataScad INT(8);
- PRIMARY KEY CodBando;
- ON DELETE RESTRICT;
- ON UPDATE RESTRICT;
- )
- <CREATE TABLE> Concorso(
- CodConc INT(6) NOTNULL;
- DataConc INT(8);
- NumVinc INT(4);
- PRIMARY KEY CodConc;
- FOREIGN KEY CodBando REFERENCES Bando(CodBando);
- FOREIGN KEY CodCommis REFERENCES Commissione(CodCommis);
- ON DELETE RESTRICT;
- ON UPDATE RESTRICT;
- )
- <CREATE TABLE> Commissione(
- CodCommis INT(6) NOTNULL;
- PRIMARY KEY CodCommis;
- ON DELETE RESTRICT;
- ON UPDATE RESTRICT;
- )
- <CREATE TABLE> Commissario(
- CodMembro INT(6) NOTNULL;
- NomeCommissario CHAR(20);
- CognomeCommissario CHAR(20);
- CodiceFiscaleCommissario CHAR(16);
- TelefonoCommissario INT(10);
- Qualifica CHAR(30);
- Indirizzo CHAR(30);
- PRIMARY KEY CodMembro;
- FOREIGN KEY CodCommis REFERENCES Commissione(CodCommis);
- ON DELETE RESTRICT;
- ON UPDATE RESTRICT;
- )
- <CREATE TABLE> Prova(
- CodPro INT(6) NOTNULL;
- DataProva INT(8);
- PuntiMax INT(3) CHECK (PuntiMax BETWEEN 0 AND 100);
- PRIMARY KEY CodPro;
- FOREIGN KEY CodConc REFERENCES Commissione(CodCommis);
- ON DELETE RESTRICT;
- ON UPDATE RESTRICT;
- )
- <CREATE TABLE> Candidato(
- CodCand INT(6) NOTNULL;
- Nome CHAR(20);
- Cognome CHAR(20);
- CodiceFiscale CHAR(16);
- PRIMARY KEY CodCand;
- ON DELETE RESTRICT;
- ON UPDATE RESTRICT;
- )
- <CREATE TABLE> HaSostenuto(
- PuntiProva INT(3) CHECK (PuntiProva) BETWEEN 0 AND 100;
- FOREIGN KEY CodPro REFERENCES Prova(CodPro);
- FOREIGN KEY CodCand REFERENCES Candidato(CodCand);
- )
- <CREATE TABLE> FaDomanda(
- FOREIGN KEY CodConc REFERENCES Concorso(CodConc);
- FOREIGN KEY CodCand REFERENCES Candidato(CodCand);
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement