6.11
考虑下图所示的关系数据库,主码加了下划线。给出关系代数表达式来表达下列的每一个查询:
a.找出First Bank Corporation的所有员工姓名
b.找出First Bank Corporation所有员工的姓名和居住城市
c.找出First Bank Corporation所有年收入在10000美元以上的员工姓名和居住的街道、城市。
d.找出所有居住地与工作的公司在同一城市的员工姓名
e.假设公司可以位于几个城市中。找出满足下面条件的所有公司,它位于Small Bank Corporation所位于的每一个城市。
a.
∏
p
e
r
s
o
n
_
n
a
m
e
(
σ
c
o
m
p
a
n
y
_
n
a
m
e
=
“
F
i
r
s
t
B
a
n
k
C
o
r
p
o
r
a
t
i
o
n
”
(
w
o
r
k
s
)
)
\prod_{}{person\_name} (\sigma_{company\_name = “First Bank Corporation” }(works))
∏person_name(σcompany_name=“FirstBankCorporation”(works))
b.
∏
p
e
r
s
o
n
_
n
a
m
e
,
c
i
t
y
(
e
m
p
l
o
y
e
e
⋈
(
σ
c
o
m
p
a
n
y
_
n
a
m
e
=
“
F
i
r
s
t
B
a
n
k
C
o
r
p
o
r
a
t
i
o
n
”
(
w
o
r
k
s
)
)
)
\prod_{}{person\_name,city }{ }(employee \Join(\sigma_{company\_name = “First Bank Corporation”} (works)))
∏person_name,city(employee⋈(σcompany_name=“FirstBankCorporation”(works)))
c.
∏
p
e
r
s
o
n
_
n
a
m
e
,
s
t
r
e
e
t
,
c
i
t
y
(
σ
(
c
o
m
p
a
n
y
_
n
a
m
e
=
“
F
i
r
s
t
B
a
n
k
C
o
r
p
o
r
a
t
i
o
n
”
∧
s
a
l
a
r
y
>
10000
)
w
o
r
k
s
⋈
e
m
p
l
o
y
e
e
)
\prod_{}person\_name, street, city(\sigma_{(company\_name = “First Bank Corporation” ∧ salar y > 10000)}works \Join employee)
∏person_name,street,city(σ(company_name=“FirstBankCorporation”∧salary>10000)works⋈employee)
d.
∏
p
e
r
s
o
n
_
n
a
m
e
(
e
m
p
l
o
y
e
e
⋈
w
o
r
k
s
⋈
c
o
m
p
a
n
y
)
\prod_{}person\_name (employee \Join works \Join company)
∏person_name(employee⋈works⋈company)
e.
∏
c
o
m
p
a
n
y
_
n
a
m
e
(
c
o
m
p
a
n
y
÷
(
∏
c
i
t
y
(
σ
c
o
m
p
a
n
y
_
n
a
m
e
=
“
S
m
a
l
l
B
a
n
k
C
o
r
p
o
r
a
t
i
o
n
”
(
c
o
m
p
a
n
y
)
)
)
)
\prod_{}company\_name (company ÷(\prod_{}city (\sigma_{company\_name =“Small Bank Corporation”} (company))))
∏company_name(company÷(∏city(σcompany_name=“SmallBankCorporation”(company))))
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)