显示效果:
σ
s
n
o
=
1
(
S
t
u
d
e
n
t
)
\sigma_{sno = 1}(Student)
σsno=1(Student)
σsno=1(Student)
σ
s
n
o
=
1
∧
s
a
g
e
>
18
∨
s
s
e
x
=
"
F
"
(
S
t
u
d
e
n
t
)
\sigma_{sno = 1 \wedge sage >18 \vee ssex="F"}(Student)
σsno=1∧sage>18∨ssex="F"(Student)
σsno=1∧sage>18∨ssex=“F” (Student)
Π
s
n
o
,
c
n
o
(
S
t
u
d
e
n
t
)
\Pi_{sno,cno}(Student)
Πsno,cno(Student)
πsno,cno (Student)
S
t
u
d
e
n
t
⋈
S
C
Student \Join SC
Student⋈SC
S
t
u
d
e
n
t
⋈
S
C
Student \bowtie SC
Student⋈SC
Student⋈SC
S
t
u
d
e
n
t
⋈
S
t
u
d
e
n
t
.
S
n
o
=
S
C
.
S
n
o
S
C
Student \underset{Student.Sno=SC.Sno}\Join SC
StudentStudent.Sno=SC.Sno⋈SC
Student ⟗ SC
Student ⟕ SC
Student ⟖ SC
S
t
u
d
e
n
t
×
S
C
Student \times SC
Student×SC
Student × SC
S
C
÷
K
SC \div K
SC÷K
SC ÷ K
R
∪
S
R \cup S
R∪S
R∪S
R
∩
S
R \cap S
R∩S
R∩S
R
−
S
R - S
R−S
R−S
Π
S
n
a
m
e
(
Π
s
n
o
(
σ
C
p
n
o
=
′
5
′
(
C
o
u
r
s
e
)
⋈
S
C
)
⋈
Π
S
n
o
,
S
n
a
m
e
(
S
t
u
d
e
n
t
)
)
\Pi_{Sname}(\Pi_{sno}(\sigma_{Cpno='5'}(Course)\Join SC)\Join \Pi_{Sno,Sname}(Student))
ΠSname(Πsno(σCpno=′5′(Course)⋈SC)⋈ΠSno,Sname(Student))
πSname (πsno (σCpno=′5′(Course) ⋈ SC) ⋈ π Sno,Sname (Student))
对应的代码:
$\sigma_{sno = 1}(Student)$
σ~sno=1~(Student)
$\sigma_{sno = 1 \wedge sage >18 \vee ssex="F"}(Student)$
σ~sno=1∧sage>18∨ssex="F"~ (Student)
$\Pi_{sno,cno}(Student)$
π~sno,cno~ (Student)
$Student \Join SC$
$Student \bowtie SC$
Student⋈SC
$Student \underset{Student.Sno=SC.Sno}\Join SC$
Student ⟗ SC
Student ⟕ SC
Student ⟖ SC
$Student \times SC$
Student × SC
$SC \div K$
SC ÷ K
$R \cup S$
R∪S
$R \cap S$
R∩S
$R - S$
R−S
$\Pi_{Sname}(\Pi_{sno}(\sigma_{Cpno='5'}(Course)\Join SC)\Join \Pi_{Sno,Sname}(Student))$
π~Sname~ (π~sno~ (σ~Cpno=′5′~(Course) ⋈ SC) ⋈ π ~Sno,Sname~ (Student))