Skip to content

Instantly share code, notes, and snippets.

@rubik
Last active November 4, 2015 10:54
Show Gist options
  • Save rubik/4aa0e7346c8137dd6c05 to your computer and use it in GitHub Desktop.
Save rubik/4aa0e7346c8137dd6c05 to your computer and use it in GitHub Desktop.
group: esempio alberghi
Cliente = { CodC, NomeC
1, Mario
2, Giuseppe
3, Laura
4, Angela
}
Albergo = { CodA, NomeA, Comune, NumStelle:number
A1, Hotello, Taranto, 3
A2, Marechiaro, Follonica, 1
A3, CiaoMare, Taranto, 4
A4, Venere, Follonica, 5
A5, Mercurio, Taranto 2
A6, Eden, Ivrea, 2
A7, Ritz, Londra, 5
A8, Boo, Londra 1
}
CameraAlbergo = { NumCamera, CodA, TipoCamera
100, A1, Singola
101, A1, Doppia
102, A1, Tripla
103, A2, Singola
104, A2, Singola
105, A2, Singola
106, A2, Doppia
107, A3, Singola
108, A3, Doppia
109, A3, Doppia
110, A4, Singola
111, A4, Doppia
112, A4, Tripla
113, A5, Singola
114, A5, Singola
115, A6, Tripla
116, A6, Tripla
117, A7, Singola
118, A7, Singola
119, A8, Singola
120, A8, Doppia
}
Prenotazione = { CodA, NumCamera, CodC
A1, 100, 1
A1, 102, 1
A1, 102, 2
A2, 103, 3
A2, 104, 3
A3, 109, 1
A3, 109, 1
A3, 109, 2
A4, 110, 4
A4, 112, 3
A5, 113, 4
A5, 114, 4
A5, 113, 1
A6, 115, 2
A7, 117, 3
A7, 118, 4
A8, 119, 1
A8, 120, 1
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment