資源簡介
數據庫系統概念第六版答案（包括實踐習題，習題）例如3.11答案Exercises
?Write the following queries in SQL, using the university schema.
?Find the names of all students who have taken at least one Comp. Sci. course; make sure there are no duplicate names in the result.
?Find the IDs and names of all students who have not taken any course offering before Spring 2009.
11
?For each department, find the maximum salary of instructors in that department. You may assume that every department has at least one instructor.
?Find the lowest, across all departments, of the per-department max- imum salary computed by the preceding query.
Answer:
?SQL query:
select name
from student natural join takes natural join course
where course.dept = ’Comp. Sci.’
?SQL query:
select id, name from student except
select id, name
from student natural join takes
where year < 2009
Since the except operator eliminates duplicates, there is no need to use a select distinct clause, although doing so would not affect correctness of the query.
?SQL query:
select dept, max(salary) from instructor
group by dept
代碼片段和文件信息
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-10-23?00:02??6E\
?????目錄???????????0??2014-12-07?21:26??6E\數據庫習題解答\
?????文件??????502003??2011-12-14?13:00??6E\數據庫習題解答\10s.pdf
?????文件??????556075??2011-12-14?13:01??6E\數據庫習題解答\11s.pdf
?????文件??????515936??2011-12-14?13:03??6E\數據庫習題解答\12s.pdf
?????文件??????540533??2011-12-14?13:04??6E\數據庫習題解答\13s.pdf
?????文件??????489725??2011-12-14?13:05??6E\數據庫習題解答\14s.pdf
?????文件??????551118??2011-12-14?13:05??6E\數據庫習題解答\15s.pdf
?????文件??????517737??2011-12-14?13:06??6E\數據庫習題解答\16s.pdf
?????文件??????483196??2011-12-14?13:07??6E\數據庫習題解答\17s.pdf
?????文件??????501625??2011-12-14?13:07??6E\數據庫習題解答\18s.pdf
?????文件??????528959??2011-12-14?13:08??6E\數據庫習題解答\19s.pdf
?????文件??????484282??2011-12-14?11:48??6E\數據庫習題解答\1s.pdf
?????文件??????489927??2011-12-14?13:08??6E\數據庫習題解答\20s.pdf
?????文件??????492122??2011-12-14?13:09??6E\數據庫習題解答\21s.pdf
?????文件??????502090??2011-12-14?13:10??6E\數據庫習題解答\22s.pdf
?????文件??????505534??2011-12-14?13:10??6E\數據庫習題解答\23s.pdf
?????文件??????493159??2011-12-14?13:11??6E\數據庫習題解答\24s.pdf
?????文件??????503873??2011-12-14?13:12??6E\數據庫習題解答\25s.pdf
?????文件??????524689??2011-12-14?13:12??6E\數據庫習題解答\26s.pdf
?????文件??????499534??2011-12-14?11:49??6E\數據庫習題解答\2s.pdf
?????文件??????542699??2011-12-14?11:50??6E\數據庫習題解答\3s.pdf
?????文件??????506570??2011-12-14?11:51??6E\數據庫習題解答\4s.pdf
?????文件??????501369??2011-12-14?11:52??6E\數據庫習題解答\5s.pdf
?????文件??????522964??2011-12-14?11:52??6E\數據庫習題解答\6s.pdf
?????文件??????516439??2011-12-14?11:53??6E\數據庫習題解答\7s.pdf
?????文件??????538584??2011-12-14?11:54??6E\數據庫習題解答\8s.pdf
?????文件??????502641??2011-12-14?11:54??6E\數據庫習題解答\9s.pdf
?????目錄???????????0??2014-12-07?21:26??6E\數據庫答案\
?????文件??????514299??2012-08-16?09:49??6E\數據庫答案\數據庫CH??（10）.pdf
?????文件??????510478??2012-08-16?09:49??6E\數據庫答案\數據庫CH??（11）.pdf
............此處省略24個文件信息
-----------?---------??----------?-----??----
?????目錄???????????0??2014-10-23?00:02??6E\
?????目錄???????????0??2014-12-07?21:26??6E\數據庫習題解答\
?????文件??????502003??2011-12-14?13:00??6E\數據庫習題解答\10s.pdf
?????文件??????556075??2011-12-14?13:01??6E\數據庫習題解答\11s.pdf
?????文件??????515936??2011-12-14?13:03??6E\數據庫習題解答\12s.pdf
?????文件??????540533??2011-12-14?13:04??6E\數據庫習題解答\13s.pdf
?????文件??????489725??2011-12-14?13:05??6E\數據庫習題解答\14s.pdf
?????文件??????551118??2011-12-14?13:05??6E\數據庫習題解答\15s.pdf
?????文件??????517737??2011-12-14?13:06??6E\數據庫習題解答\16s.pdf
?????文件??????483196??2011-12-14?13:07??6E\數據庫習題解答\17s.pdf
?????文件??????501625??2011-12-14?13:07??6E\數據庫習題解答\18s.pdf
?????文件??????528959??2011-12-14?13:08??6E\數據庫習題解答\19s.pdf
?????文件??????484282??2011-12-14?11:48??6E\數據庫習題解答\1s.pdf
?????文件??????489927??2011-12-14?13:08??6E\數據庫習題解答\20s.pdf
?????文件??????492122??2011-12-14?13:09??6E\數據庫習題解答\21s.pdf
?????文件??????502090??2011-12-14?13:10??6E\數據庫習題解答\22s.pdf
?????文件??????505534??2011-12-14?13:10??6E\數據庫習題解答\23s.pdf
?????文件??????493159??2011-12-14?13:11??6E\數據庫習題解答\24s.pdf
?????文件??????503873??2011-12-14?13:12??6E\數據庫習題解答\25s.pdf
?????文件??????524689??2011-12-14?13:12??6E\數據庫習題解答\26s.pdf
?????文件??????499534??2011-12-14?11:49??6E\數據庫習題解答\2s.pdf
?????文件??????542699??2011-12-14?11:50??6E\數據庫習題解答\3s.pdf
?????文件??????506570??2011-12-14?11:51??6E\數據庫習題解答\4s.pdf
?????文件??????501369??2011-12-14?11:52??6E\數據庫習題解答\5s.pdf
?????文件??????522964??2011-12-14?11:52??6E\數據庫習題解答\6s.pdf
?????文件??????516439??2011-12-14?11:53??6E\數據庫習題解答\7s.pdf
?????文件??????538584??2011-12-14?11:54??6E\數據庫習題解答\8s.pdf
?????文件??????502641??2011-12-14?11:54??6E\數據庫習題解答\9s.pdf
?????目錄???????????0??2014-12-07?21:26??6E\數據庫答案\
?????文件??????514299??2012-08-16?09:49??6E\數據庫答案\數據庫CH??（10）.pdf
?????文件??????510478??2012-08-16?09:49??6E\數據庫答案\數據庫CH??（11）.pdf
............此處省略24個文件信息
評論
共有 條評論
川公網安備 51152502000135號