题目
请问下面的数据库 关系代数表达式怎么写啊?
Employee(EmployeeId,EmployeeName,Block,UnitNo,Street,City)
Working(EmployeeId,CompanyId,Salary)
Company(CompanyId,CompanyName,City)
Managing(EmployeeId,ManagerID)
Write relational algebra expressions for the following queries:
(1) Find the list of EmployeeIds and EmployeeNames working in the company XYZ.
(2) Find all Employees who live in the same city as the company in which they work.
(3) Find all employees who work for City Bank and earn more than $30000.
(4) Find the number of employees working in each company and the average salary.
Employee(EmployeeId,EmployeeName,Block,UnitNo,Street,City)
Working(EmployeeId,CompanyId,Salary)
Company(CompanyId,CompanyName,City)
Managing(EmployeeId,ManagerID)
Write relational algebra expressions for the following queries:
(1) Find the list of EmployeeIds and EmployeeNames working in the company XYZ.
(2) Find all Employees who live in the same city as the company in which they work.
(3) Find all employees who work for City Bank and earn more than $30000.
(4) Find the number of employees working in each company and the average salary.
提问时间:2021-04-12
答案
举一反三
已知函数f(x)=x,g(x)=alnx,a∈R.若曲线y=f(x)与曲线y=g(x)相交,且在交点处有相同的切线,求a的值和该切线方程.
我想写一篇关于奥巴马的演讲的文章,写哪一篇好呢?为什么好
奥巴马演讲不用看稿子.为什么中国领导演讲要看?
想找英语初三上学期的首字母填空练习……
英语翻译
最新试题
热门考点
- 1用大象.兔子.狐狸.百灵鸟编一个童话故事,并告诉人们一个道理.
- 2《黄鹤楼送孟浩然之广陵》写成叙文 400个字
- 3These are your watch I know you name is Anna Those is an black pen These are my good friend,Bob
- 4配置1000毫升溶质质量分数为10%的稀硫酸,需要溶质质量分数为98%的浓硫酸多少毫升?
- 5下列溶液中,酸度最大的是:( ) A.0.1 mol·L-1HAc 溶液 B.0.1 mol·L-1HAc 溶液和
- 6如果把正方体的棱n等分,然后沿等分线把正方体切开,得到n的三次方个小正方体,那么.
- 7一头狮子的年龄是21岁,是一头大象年龄的7/20,这头大象的年龄是多少岁?(用方程解)
- 8第一秒内,前三秒内,第二秒内分别指第几秒到第几秒
- 9一个三角形的面积是8平方米,和它等底等高的平行四边形的面积是几?
- 10解方程:0.3x分之2x减5分之x-3=0.4