! "
#$%&
""
'
(
'
+
,
+( ,
)*(
- /(
.(
. "0 ' 1
'
"
!
'"
1 ∈
#
#
67
#
# 3
4
43 4
#
1# 1 3 1
3 1 ∈
28
6 7 (8
2
*
5 1# ∈
#
67
498
4 4 2 6 7# 4
4 2
# (4
(4 2 (4 # 9
2 9 # (9
(9 2 (98
4
9
2
1
3
#
'
"
#
34
#
#
67
#
28
6 7 (8
4 4 2 6 7#
2 (4 # 9
⊆
#
9 2
4
2
4
67
498
2
4
4
4
4 2 4 # (4
(4
9 # (9
(9 2 (98
67
4 2
4 2 (98
:
.'
"
.
- 67
- 67
- >6
<' "" 8
5 =
!
-
8
'
'
.
4 4>6 7
#
3
5 #
5
3
=
#
=
3
<' ""
# <' ""
3
<' ""
5 # <' ""
5
3
<' "" =
# <' "" =
3 8
;
.'
"
.
- 67
- 67
- >6
<' "" 8
5 =
8
'
'
+
)@
-
⊆
7
,
.
4 4>6
5 :& <' ""
5
<' ""
2? 8
:&
2?
?
2
('
''
'
5
A
:&
<' ""
⊆
2?
4 4>
'
3
5
:&
<' ""
2?
A
%
(' .
3
''
5
<' ""
(
A"0
:&
<' ""
2?
2?
5
:&
"'C1
""
5
<' ""
'
A
'
.
:&
2?
5.
B
/(
D
(
A'
<' ""
2?
5
F
<
'
""
''
=
'5
:&
:;
;&
"
'
E
$
3
)
". '
1
(
#B: :&&# 2
##G
#&G
#$%&
+
!
#&G
&?G&&2
" D (
,
2&
# G
&%G&&2
<
&?G
#&G&&2
%
5
&$G
# G&&2
B
F
2&
#&
'
(
"0
/
/(
( .. '
'
<' ""
1
5
=
#B: :&&# 2
##G
#&G
#$%&
#B: :&&&#
# G
&#G
#$%
#B: :&&#$B
3
#
/
/(
( .. )
)
#B: :&&# 2
3
#B: :&&# 2
3
#B: :&&# 2
3
#B: :&&&#
3
#B: :&&&#
3
#B: :&&#$B
3
'
"
'
"
2&
<
5
%
B
%
F
5
2&
?
##
5
D
*
!
(
A ' H' '
1
1
A
Tabella_1
Tabella_1 == Studenti(Nome,Cognome,Matricola,DataDiNascita)
Studenti(Nome,Cognome,Matricola,DataDiNascita)
Tabella_2
Tabella_2 == EsamiSuperati(Matricola,Data,Materia,Voto)
EsamiSuperati(Matricola,Data,Materia,Voto)
RR == {Studenti(Nome,Cognome,Matricola,DataDiNascita),
{Studenti(Nome,Cognome,Matricola,DataDiNascita),
EsamiSuperati(Matricola,Data,Materia,Voto)}
EsamiSuperati(Matricola,Data,Materia,Voto)}
#
4
5
.
-'
'
('
#
.
#
I6 7 # 3
8
EsamiSuperati(Matricola,Data,Materia,Voto)
EsamiSuperati(Matricola,Data,Materia,Voto)
5
(
-
.
5
.
6 7 # I#
JIJ8
RR == {Studenti(Nome,Cognome,Matricola,DataDiNascita),
{Studenti(Nome,Cognome,Matricola,DataDiNascita),
EsamiSuperati(Matricola,Data,Materia,Voto)}
EsamiSuperati(Matricola,Data,Materia,Voto)}
#2
K
)
".
51
F '
# 2:;
#$
"
#
!D!
2
K
#
'
=
L2%&&&
L&22
#%,
L#2&&&
#:
K
/
/(
( ..
#
# 2:;
<' ""
1
5
=
# 2::
/
/(
( .. F
F '
'
:;:2
#
"
# 2:;
2
K
# 2:;
#
!D!
# 2:;
#
# 2::
*
A
'H'
" ((
!
1
L&22
'
L2%&&&
#%,
L#2&&&
L%&&&
5
#;
5
K
/
/(
( ..
#
# 2:;
<' ""
5
1
# 2::
=
/
/(
( .. F
F '
'
:;:2
#
"
'
.
'
5 "
*
'
'
5
# 2:;
%
2
K
# 2:;
&
#
!D!
# 2:;
'
#
# 2::
&
# 2::
%
!
#
L&22
'
L2%&&&
#%,
L#2&&&
1
L%&&&
M /)
L#;&&&
'
#?
=
)* 1
"
>'
(
"
"
'
5
'
A
'
"
'
/
/(
( .. N
N
(
5
<' ""
1
)
= =
%
EEE
=
N
N
= )
2
2:: # 22:;
## &B #$::
222 &$B%?;
# &$ #$:;
EEE
EEE
#%
=
>
A"
#$%&
K
'
>'
( '
' 1
* ('
'
1
' 1
"
+
>D
(
5
<' ""
1
1 ,
)
= =
%
>D
=
""
+
,& &# &#
= )
2
2:: # 22:;
## &B #$::
222 &$B%?;
# &$ #$:;
>D
>D
#B
6
=
@
(
1
5
"
*
=
1
."
-=
+
'
@
(
'
'
'"
'"
=
1
- 51
(' 5 "
'
*
'1
'"
-=
=
('
(
#$
=
=
/'"
1
'
'"
#B: :&&# 2
3
#B: :&&# 2
3
<
2&
%
>
#B: :&&&#
3
F
2&
>
#B: :&&#$B
3
?
>
5
,
##
=
=
=
=
O
6
O
6#B
#B
6
62&
2&
=
6
= P
P
62&
2&
6
>
6Q
Q
>*
*
3
#?
3
%
3
2#
>
&
=
/'"
#
"
# 2:;
#
# 2:;
# 2:;
2
# 2::
#
# 2::
2
K
#
!D!
#
!
#
##
>
>
L&22
L&$$
L2%&&& L;&&&
L2 &&&
#%,
L#2&&& L#&&&
L# &&&
L%&&&
L&&&
L#:&&&
L#;&&& L&&&
L#;&&&
1
M /)
D
D
L&&&
'
D
D
R
RS
S@
@6
6!
!
6
D
6>
>
D
#
7
51
D
!
'"
-
A'
!
!
.'
'
1
'"
#B: :&&# 2
(' 5 "
'*
'
.
'
"
#&&2 &:
#B: :&&# 2
## &: &:
#B: :&&&#
&&$ &2
#B: :&&&#
&$ # &2
#B: :&&#$B
&B ## &2
(' A
('
T
5
'
=
=
2&
<
'""
"
'*
%
%
F
'1
@ '"
2&
5
?
51
TA!
.
'
'*
A' '" 5 1
'" 5 1 T*
5 T*⊂ T
(
5
<' ""
1
)
= =
%
= < (
=
= )
2
2:: # 22:;
# 2:
# 222 &$B%?;
$&$$
&$; # 22:;
2:
>
>
'" 5 1
/
/
>
>
51
/
/
/
/
!
6
6
*"
>
>
+
/
/
2
=
=
('
(
1
/0 5 1
&7'%89
%8:&5:5'
892
77
7 87'%
892
432887
%9:&5:5'
789
'7
7 87'%
789
432882
%9:&5:5'
789
'7
955329
&8:&5:5'
789
8'
8'4389
%5:5&:57
892
77
(
%12345
(
%12345
)6
%12345
>
(
> )
)
(
(
(
6
(1
1 =
=
(
6(
(
(
;&&
<
"
)
6
"
)
6
!
;&5
;&5
7 87'%
(
%12345
)6
%12345
:
8
<
1
' 1
-
1
1
" .
' '"
'"
'
&7'%89
%8:&5:5'
892
77
7 87'%
892
432887
%9:&5:5'
789
'7
7 87'%
789
432882
%9:&5:5'
789
'7
(
955329
&8:&5:5'
789
8'
(
%12345
8'4389
%5:5&:57
892
77
)6
%12345
(
(
6
(1
1 =
=
(
6(
(
%12345
>
(
> )
)
(
(
;&&
<
!
7 87'%
;&5
"
)
6
"
)
6
;&5
(
%12345
)6
%12345
;
<
1
!
!
#. >
.! "
-
G
*"
*
'"
&7'%89
%8:&5:5'
892
77
7 87'%
892
432887
%9:&5:5'
789
'7
7 87'%
789
432882
%9:&5:5'
789
'7
955329
&8:&5:5'
789
8'
8'4389
%5:5&:57
892
77
(
(
6
(1
1 =
=
(
6(
(
(
%12345
(
%12345
)6
%12345
>
(
> )
)
(
(
;&&
<
!
7 87'%
;&5
"
)
6
"
)
6
;&5
(
%12345
)6
%12345
?
<
1
!
2.
-
1 H'
5
'
1
"0
&7'%89
%8:&5:5'
892
77
432887
%9:&5:5'
"
'7
432882
%9:&5:5'
"
'7
955329
&8:&5:5'
"
8'
8'4389
%5:5&:57
892
77
(
(
6
(1
1 =
=
(
6(
(
1
>D
' H'
1
7 87'%
892
7 87'%
789
(
%12345
(
%12345
)6
%12345
*
>
(
> )
)
(
(
;&&
<
"
)
6
"
)
6
!
;&5
;&5
7 87'%
(
%12345
)6
%12345
%
9
)
#
)
#
(
<
"
' ((
" "
"
(
'
K
A
'
"
1
(
S'
"
' (
"
'
"
"
' (
"
" 1
'
- D
5
51
('
"
1
'*
"
(
B
)
)
<
(
1
""
1
'
"
'
!
"
. '
"
@
-D
5
51
'*
('
" 1
"
1
"
(
$
10
Scarica

Il Modello Relazionale - Dipartimento di Matematica e Informatica