This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: summerschool | |
| Docenti = { idDocente Nome Cognome Dipartimento | |
| 106 Nicola Cesaria Fisica | |
| 105 Pompea Distante Lettere | |
| 104 Maria Guadalupi Matematica | |
| 103 Cristiana Indini Lettere | |
| 101 Luciano Schiavone Informatica | |
| } | |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: magazzino | |
| Prodotti = { idProdotto,Prezzo | |
| X,10 | |
| Y,12 | |
| Z,15 | |
| } | |
| Fornitori = { idFornitore, Nome | |
| A,'Pippo' |
lucianosch
/ banca
Last active
June 5, 2021 17:55
Db bancario con tre relazioni: Conto, Clienti e Movimenti
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: Banca | |
| Movimenti = {num,idConto,data,importo,causale | |
| 1,10,2011-03-15,1808.19,"stipendio" | |
| 2,10,2011-06-20,1092.24,"assegno" | |
| 3,10,2011-07-17,-162.06,"pagamento utenze" | |
| 4,10,2011-10-04,1253.19,"assegno" | |
| 5,10,2011-11-14,904.65,"bonifico" | |
| 6,10,2012-04-02,1880.34,"stipendio" | |
| 1,11,2011-11-08,-970.14,"prelievo" |
lucianosch
/ universita
Created
November 18, 2020 09:00
Database universitario: Studenti, Esami, Corsi
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: universita | |
| Corsi = { idCorso,nome,crediti | |
| 11,Biologia,3 | |
| 12,Chimica,3 | |
| 13,Fisica,2 | |
| 14,Matematica,2 | |
| 15,Diritto,1 | |
| 16,Inglese,1 | |
| 17,Informatica,3 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: Uni | |
| DOCENTI = { CodiceD, Citta, Dipartimento | |
| Knuth, Manhattan, CS | |
| Mead, Manhattan, EE | |
| Ferrari, Brooklin, CS | |
| Codd, Soho, CS | |
| Graham, Soho, EE | |
| } | |
| CORSO = {CodiceC, CodiceD |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: UniTO | |
| Docenti = { MatrDocente, NomeDoc, Dipartimento | |
| D102, Verdi, Informatica | |
| D105, Neri, Informatica | |
| D104, Bianchi, Elettronica | |
| } | |
| Corsi = { Codice, NomeCorso, Semestre, MatrDocente | |
| M2170, "Informatica 1", 1, D102 |
lucianosch
/ Esami
Last active
October 24, 2021 15:35
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: esami | |
| studenti= | |
| {matricola,cognome,nome | |
| 104,'Neri','Marco' | |
| 103,'Verdi','Ugo' | |
| 102,'Rossi','Mario' | |
| 101,'Bianchi','Aldo' | |
| } | |
| esami = {matricola,materia,voto,data |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: Magazzino | |
| P = { | |
| CodP NomeP Colore Taglia Magazzino | |
| P1 Maglia Rosso 40 Torino | |
| P2 Jeans Verde 48 Milano | |
| P3 Camicia Blu 48 Roma | |
| P4 Camicia Blu 44 Torino | |
| P5 Gonna Blu 40 Milano | |
| P6 Bermuda Rosso 42 Torino | |
| } |
lucianosch
/ Libreria
Last active
October 27, 2023 07:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: libreria | |
| Libri = { idLibro,autore, titolo | |
| 11,'Camilleri',"La forma dell'acqua" | |
| 12,'Verga','I malavoglia' | |
| 13,'Camilleri','La voce del violino' | |
| 14,'Pavese','La luna e i falò' | |
| 15,'Calvino','Il barone rampante' | |
| 16,'Camilleri','Il campo del vasaio' | |
| 17,'Calvino','Lezioni americane' |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| group: DBFilm | |
| Film = { | |
| CodiceFilm Titolo Regista Anno CodiceNoleggio | |
| F001 "Il Mago" Smith 2005 N001 | |
| F002 "L'Avventura" Johnson 2010 N002 | |
| F003 "Tempesta" Davis 2012 N003 | |
| F004 "L'Inizio" Miller 2008 N004 | |
| F005 "Notte Nera" Wilson 2019 N005 | |
| F006 "Il Segreto" Brown 2003 N006 |
OlderNewer