数据库原理习题课.pptVIP

主讲：王新颖 E-mail：xinying@;1、基本的关系代数运算 2、附加的关系代数运算 3、扩展的关系代数运算 4、数据库修改 ; employee(person-name,street,city) works(person-name,company-name,salary) company(company-name,city) manages(person-name,manager-name); 找出First Bank Corporation的所有员工的姓名 Πperson-name (?company-name=“First Bank Corporation” (works)) 找出First Bank Corporation的所有员工的姓名和居住城市 Πperson-name, city (?company-name=“First Bank Corporation” (employee works)) 找出First Bank Corporation的所有年收入在10,000美元一时的员工的姓名和居住的街道、城市 Πperson-name, street,city (?salary10000 (?company-name=“First Bank Corporation” (employee works))) 找出所有居住地与工作的公司在同一城市的员工姓名 Πperson-name (employee works company) ;找出与其经理居住在同一城市同一街道的所有员工的姓名 Πperson-name (? manager-name=employee2.person-name ∧manages.person-name=employee.person-name ∧ employee.street = employee2.street ∧ employee.city = employee2.city (employee ×(manages× (ρemployee2 (employee))))) 6. 找出比Small Bank Corporation所有员工收入都高的所有的员工的姓名 Πperson-name (works) ? (Πworks.person-name (?works.salary ≤ works2.salary ∧ pany-name=“Small Bank Corporation” (works ×(ρworks2(works)))) ;7.找出数据库中不在First Bank Corporation工作的所有员工的姓名 每个人只能在一个公司工作（不允许兼职） Πperson-name (?company-name≠“First Bank Corporation” (works)) 每个人可以在不只一个公司工作（允许兼职） Πperson-name (employee) ? Πperson-name (σcompany-name = “First Bank Corporation”(works)) ;8. 修改数据库，使Jones现在居住在NewTown employee ←employee -?person-name=“Jones”(employee) employee ←employee∪{(“Jones”, null, “Newtown”)} 9. 为工资不高于100,000的经理提高工资10%，高于100,000的提高工资3% t1 ←Π person-name, company-name, salary (?person-name= manager-name(employee×works)) t2 ←Π person-name, company-name, salary *1.1 (?salary ≤ 100000 (t1)) t3 ←Π person-name, company-name, salary*1.03 (? salary 100000 (t1)) works ← (works - t1) ∪ t2 ∪ t3 ;10. 删除works关系中Small Bank Corporation的员工的所有元组 t1 ←Π person-name, company-name, salary (? company-name=“Small Bank Corporation” (works)) works ← (works - t1) 11.找出员工最多的公司 r1 ← company-namegcount (person-name) as person-number (works) r2