数据库系统概念第六版答案包括实践习题，习题

数据库系统概念第六版答案（包括实践习题，习题）例如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个文件信息