數(shù)據(jù)庫作業(yè)題目-展示頁
2025-04-03 02:56本頁面
【正文】 group by , with T2(MAXSUMQTY) asselect max()from T1group by select from T1,T2,S T3where = and =作業(yè)四：關(guān)系規(guī)范化題目一：分別寫出關(guān)系代數(shù)和SQL語句，驗證關(guān)系R(ABC)上A174。 select , sum()*from SPJ , Jwhere = and = ’紅色’group by order by sum()9. 求供應(yīng)零件數(shù)量最多的供應(yīng)商姓名。select from Swhere not exists (select from Pwhere not exists ( select *from SPJwhere = and =and =’紅’))7. 列出每個城市的工程所使用的零件總的數(shù)量。 select distinct ,from S T4, SPJ T5,J T6where = and = and =exceptselect distinct ,from S T1, SPJ T2,J T3where = and = and !=5. 求供應(yīng)了所有零件的供應(yīng)商姓名。select SNAMEfrom Swhere not exists ( select from SPJwhere = and ( PNO=’p1’ or PNO=’ p 2’) 2. 列出所有供應(yīng)商的信息，包括供應(yīng)商姓名、所供應(yīng)的零件名（沒有供應(yīng)零件的供應(yīng)商也要列出，最后結(jié)果中不要出現(xiàn)重復(fù)元組）select distinct SNAME,from S right outer join ( select ,from SPJ,Pwhere =) as T1 on =3. 求只向與自己位于不同城市的工程供應(yīng)零件的供應(yīng)商姓名。作業(yè)三：基本SQLS(SNO, SNAME, STATUS, CITY)P(PNO, PNAME, COLOR, WEIGHT, CITY)J(JNO, JNAME,CITY)SPJ(SNO, PNO, JNO, QTY)S表示供應(yīng)商，各屬性依次為供應(yīng)商號，供應(yīng)商名，供應(yīng)商狀態(tài)值，供應(yīng)商所在城市；P表示零件，各屬性依次為零件號，零件名，零件顏色，零件重量，零件存放的城市；J表示工程，各屬性依次為工程號，工程名，工程所在城市；SPJ表示供貨關(guān)系，各屬性依次為供應(yīng)商號，零件號，工程號，供貨數(shù)量?！荢NO (SPJ) － ∏SNO (∏ SNO (SPJ) ∏PNO (s SNO=’s1’ (SPJ)) － ∏SNO, PNO (SPJ) ) － ∏SNO(∏SNO, PNO (SPJ) － ∏SNO(SPJ) ∏PNO (s SNO=’s1’(SPJ)) )題目二：對于關(guān)系R(A, B, C)，用關(guān)系代數(shù)來檢驗A是否取值唯一。∏SNO, PNO (SPJ) 247。∏(S? (∏,( SPJ) 247?！?S? (∏,( SPJ) 247?！?S? (=∧ ≠ (ρ X (SPJ) ρ Y (SPJ) ) )4. 求沒有供應(yīng)任何零件的供應(yīng)商姓名?！?=∧=’ 紅色’∧=’北京’ ( SPJSPJ))2. 求只向北京的工程供應(yīng)零件的供應(yīng)商姓名。日期編號業(yè)務(wù)員名稱提交供應(yīng)商訂單采購貨品貨品名稱狀態(tài)作業(yè)二：關(guān)系代數(shù)題目一：S(SNO, SNAME, STATUS
教學(xué)教案相關(guān)推薦
鄂ICP備17016276號-1