請問下面的數(shù)據(jù)庫 關(guān)系代數(shù)表達式怎么寫啊?
請問下面的數(shù)據(jù)庫 關(guān)系代數(shù)表達式怎么寫啊?
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.
英語人氣:494 ℃時間:2020-09-14 10:49:50
優(yōu)質(zhì)解答
1)查詢在XYZ工資工作的員工ID和姓名列表.SELECT a.EmployeeId,a.EmployeeName from Employee a,Working b,Company cwhere a.EmployeeId = b.EmployeeIdand b.CompanyId = c.CompanyIdand c.CompanyName = 'XYZ'2)查...請問,這個好像是SQL吧?不是relational algebra expressions。而且為什么這個SQL的寫法會有a?b?c?之前那個SQL問題有一個的回答也是有a,b,c的。麻煩你再解析解析啊~謝謝!a, b, c是表的別名。就是表本身叫一個什么名字,而現(xiàn)在我取了一個別名,用起來方便。至于關(guān)系代數(shù)表達式,從大學(xué)畢業(yè)后就沒寫過了。第一個應(yīng)該是π EMPLOYEEID, EMPLOYEENAME(EMPLOYEE連接符號WORKING)連接符號σcompanyname='XYZ'(COMPANY))以上的寫法,連接符號就是cross那樣的,兩豎線中間是個叉,我找不到這個符號。厲害啊!還記得這么清楚??!謝謝您的回答!SELECT語法咱們都已經(jīng)寫出來了,也就不怕分析關(guān)系代數(shù)表達式了。只要清楚這個寫法,應(yīng)該就可以寫出來。您看看吧,我也叫不準(zhǔn)了。好的~謝謝~有SQL的語法就能寫出分析關(guān)系代數(shù)表達式了~我再等等看,還有沒有回答~沒有人回答的話,您這個就是最好的答案啦~謝謝您的幫助??!您幫我解決了很多問題??!萬分的感激!
我來回答
類似推薦
- 數(shù)據(jù)庫關(guān)系代數(shù)表達式問題
- 關(guān)系代數(shù)式 數(shù)據(jù)庫
- 10.關(guān)系代數(shù)表達式的優(yōu)化策略中,首先要做的是( ) .
- 數(shù)學(xué)代數(shù)式:根據(jù)問題的的需要,用具體的()代替代數(shù)式中的(),按照代數(shù)式中的()關(guān)系計算出代數(shù)式的值
- 關(guān)于萬有引力定律的發(fā)現(xiàn),正確的是 A牛頓通過望遠鏡觀察天體運動發(fā)現(xiàn)的 B牛頓通過探究蘋果落地發(fā)現(xiàn)的
- 為什么紅細胞可攜帶二氧化碳
- I know I'm really in love with you..I care and I really don't want to lose you
- 0.8L=()dm3=()cm3
- 有沒有I like winter的作文?急用 .求你了!幫個忙!(>_
- 一臺電動機正常工作時,兩端的電壓為220V,通過線圈的電流為10A,若此線圈的電阻為2Ω,那么它的電功率是_W,這臺電動機1min內(nèi)產(chǎn)生的熱量是_J,這臺電動機的效率是_.(最后一空保留三位
- forget現(xiàn)分及形容詞 cook形容詞,名詞兩個
- 如圖,△ABC為等邊三角形,且BM=CN,AM與BN相交于點P,則∠APN=_.
猜你喜歡
- 1家用電器或線路著火,可用泡沫滅火器撲救是對的還是錯的?
- 2Shall we have some chicken wings?(同義句轉(zhuǎn)換)
- 3子彈在水平飛行時,其動能為Ek0=800J,某時它炸裂成質(zhì)量相等的兩塊,其中一塊的動能為Ek1=625J,求另一塊的動能Ek2.
- 4甲乙丙三個同學(xué)參加儲蓄,甲存款是乙的4/5,丙存款比乙少40%,已知甲存了500元,丙存了多少元?
- 5函數(shù)f(x)=sin(πx/2-π/4)的圖象是由函數(shù)y=sinx的圖象經(jīng)過怎樣的變換得到的?
- 6歷史題選擇題【詳細解析區(qū)分一下】THANK YOU
- 7英語單詞的過去式和反義詞
- 8設(shè)A是m*n矩陣,B是n*m矩陣.證明當(dāng)M>n時,必有|AB|=0
- 9a*b=a (a小于等于b) =b (a大于b)如果1*2=1,則函數(shù)2^x*2^(-x)的值域
- 10The twins____members of the school football team A are both B both are
- 11最小正周期和周期有什么區(qū)別?
- 125551用加減乘除,括號怎樣等于24