数据库系统概念》第六版的实验数据。把这些数据导入数据库,就可以做书上的例题和习题。另外附带一个详细的表关系图,方便大家理解表。
2019-12-21 19:49:13 716KB 数据库 系统概念 SQL
1
数据库系统概念第六版书后习题全部答案(英文)Database_System_Concepts_6th_edition-solutions to practice exercises and exercises (answers)
2019-12-21 19:38:39 24.99MB Database System Concepts 6th
1
数据库系统概念第六版习题答案,包括实践习题和习题,英文版官方原版
2019-12-21 19:34:20 25.01MB 答案 第六版 数据库
1
数据库系统概念课后习题官方参考答案 对应版本第6版 内容为英文
2019-12-21 19:24:12 1.94MB 数据库 答案
1
数据库系统概念第六版答案(包括实践习题,习题)例如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
2019-12-21 18:53:11 24.98MB 数据库系统 第六版 答案
1
数据库系统概念-原书第六版,全部示例表、数据sql文件(如instructor,department建表sql和数据)。之前将实例数据表一行一行打字,搞了一天,后来找到全部的建表、数据初始化的sql文件,转给大家下载了,节省各位时间。
2019-12-21 18:50:29 254KB 数据库
1
数据库系统概念 (第五版 影印版 )中文版
2012-05-19 00:00:00 15.48MB 数据库
1