如何下载 数据库系统教程 第6版 大学模式sql文件

不念不忘少年蓝@ 2023-06-07 08:06 11阅读 0赞

如何下载 数据库系统教程 第6版 大学模式sql文件

先来介绍如何下载源码,或者可往下翻复制我下载好的代码也行,不要去CSDN上用积分下载.

在书上找到本书配套网站

一般技术书都会给光盘,或者给一个随书的网站来给大家下载源码
所以先翻书,找到书籍对应的站点:
在这里插入图片描述现在得到这本书的配套站点如下:
http://www.db-book.com

进入配套站点

在这里插入图片描述

找到对应的书籍

这里,配套站点上列出了两本书,一般都会给出书的封面,如果不知道选那本,可以看自己手上书的封面:
在这里插入图片描述
显然是第一个:

https://www.db-book.com/db6/index.html
在这里插入图片描述
英文不好的可以使用翻译插件:
在这里插入图片描述

进入书籍页面

点击Laboratory Material进入书籍所在的页面,

进入源码下载页面

然后点击Sample Tables进入源码下载页面
在这里插入图片描述

下载.sql文件

下载对应数据库的.sql文件,我用的是MySQL所以下载的MySQL的,点击下图的四个链接即可:

在这里插入图片描述下载将得到如下四个.sql文件:
在这里插入图片描述

源码

下面给出我下载好的源码,懒得下载的话可以直接复制下面的内容,

DDL-MySQL.sql

  1. create table classroom
  2.     (building        varchar(15),
  3.      room_number        varchar(7),
  4.      capacity        numeric(4,0),
  5.      primary key (building, room_number)
  6.     );
  7. create table department
  8.     (dept_name        varchar(20), 
  9.      building        varchar(15), 
  10.      budget                numeric(12,2) check (budget > 0),
  11.      primary key (dept_name)
  12.     );
  13. create table course
  14.     (course_id        varchar(8), 
  15.      title            varchar(50), 
  16.      dept_name        varchar(20),
  17.      credits        numeric(2,0) check (credits > 0),
  18.      primary key (course_id),
  19.      foreign key (dept_name) references department(dept_name)
  20.         on delete set null
  21.     );
  22. create table instructor
  23.     (ID            varchar(5), 
  24.      name            varchar(20) not null, 
  25.      dept_name        varchar(20), 
  26.      salary            numeric(8,2) check (salary > 29000),
  27.      primary key (ID),
  28.      foreign key (dept_name) references department(dept_name)
  29.         on delete set null
  30.     );
  31. create table section
  32.     (course_id        varchar(8), 
  33.          sec_id            varchar(8),
  34.      semester        varchar(6)
  35.         check (semester in ('Fall', 'Winter', 'Spring', 'Summer')), 
  36.      year            numeric(4,0) check (year > 1701 and year < 2100), 
  37.      building        varchar(15),
  38.      room_number        varchar(7),
  39.      time_slot_id        varchar(4),
  40.      primary key (course_id, sec_id, semester, year),
  41.      foreign key (course_id) references course(course_id)
  42.         on delete cascade,
  43.      foreign key (building, room_number) references classroom(building, room_number)
  44.         on delete set null
  45.     );
  46. create table teaches
  47.     (ID            varchar(5), 
  48.      course_id        varchar(8),
  49.      sec_id            varchar(8), 
  50.      semester        varchar(6),
  51.      year            numeric(4,0),
  52.      primary key (ID, course_id, sec_id, semester, year),
  53.      foreign key (course_id,sec_id, semester, year) references section(course_id,sec_id, semester, year)
  54.         on delete cascade,
  55.      foreign key (ID) references instructor(ID)
  56.         on delete cascade
  57.     );
  58. create table student
  59.     (ID            varchar(5), 
  60.      name            varchar(20) not null, 
  61.      dept_name        varchar(20), 
  62.      tot_cred        numeric(3,0) check (tot_cred >= 0),
  63.      primary key (ID),
  64.      foreign key (dept_name) references department(dept_name)
  65.         on delete set null
  66.     );
  67. create table takes
  68.     (ID            varchar(5), 
  69.      course_id        varchar(8),
  70.      sec_id            varchar(8), 
  71.      semester        varchar(6),
  72.      year            numeric(4,0),
  73.      grade                varchar(2),
  74.      primary key (ID, course_id, sec_id, semester, year),
  75.      foreign key (course_id,sec_id, semester, year) references section(course_id,sec_id, semester, year)
  76.         on delete cascade,
  77.      foreign key (ID) references student(ID)
  78.         on delete cascade
  79.     );
  80. create table advisor
  81.     (s_ID            varchar(5),
  82.      i_ID            varchar(5),
  83.      primary key (s_ID),
  84.      foreign key (i_ID) references instructor (ID)
  85.         on delete set null,
  86.      foreign key (s_ID) references student (ID)
  87.         on delete cascade
  88.     );
  89. create table time_slot
  90.     (time_slot_id        varchar(4),
  91.      day            varchar(1),
  92.      start_hr        numeric(2) check (start_hr >= 0 and start_hr < 24),
  93.      start_min        numeric(2) check (start_min >= 0 and start_min < 60),
  94.      end_hr            numeric(2) check (end_hr >= 0 and end_hr < 24),
  95.      end_min        numeric(2) check (end_min >= 0 and end_min < 60),
  96.      primary key (time_slot_id, day, start_hr, start_min)
  97.     );
  98. create table prereq
  99.     (course_id        varchar(8), 
  100.      prereq_id        varchar(8),
  101.      primary key (course_id, prereq_id),
  102.      foreign key (course_id) references course(course_id)
  103.         on delete cascade,
  104.      foreign key (prereq_id) references course(course_id)
  105.     )

DDL-MySQL+drop.sql

  1. drop table prereq;
  2. drop table time_slot;
  3. drop table advisor;
  4. drop table takes;
  5. drop table student;
  6. drop table teaches;
  7. drop table section;
  8. drop table instructor;
  9. drop table course;
  10. drop table department;
  11. drop table classroom;
  14. create table classroom
  15.     (building        varchar(15),
  16.      room_number        varchar(7),
  17.      capacity        numeric(4,0),
  18.      primary key (building, room_number)
  19.     );
  20. create table department
  21.     (dept_name        varchar(20), 
  22.      building        varchar(15), 
  23.      budget                numeric(12,2) check (budget > 0),
  24.      primary key (dept_name)
  25.     );
  26. create table course
  27.     (course_id        varchar(8), 
  28.      title            varchar(50), 
  29.      dept_name        varchar(20),
  30.      credits        numeric(2,0) check (credits > 0),
  31.      primary key (course_id),
  32.      foreign key (dept_name) references department(dept_name)
  33.         on delete set null
  34.     );
  35. create table instructor
  36.     (ID            varchar(5), 
  37.      name            varchar(20) not null, 
  38.      dept_name        varchar(20), 
  39.      salary            numeric(8,2) check (salary > 29000),
  40.      primary key (ID),
  41.      foreign key (dept_name) references department(dept_name)
  42.         on delete set null
  43.     );
  44. create table section
  45.     (course_id        varchar(8), 
  46.          sec_id            varchar(8),
  47.      semester        varchar(6)
  48.         check (semester in ('Fall', 'Winter', 'Spring', 'Summer')), 
  49.      year            numeric(4,0) check (year > 1701 and year < 2100), 
  50.      building        varchar(15),
  51.      room_number        varchar(7),
  52.      time_slot_id        varchar(4),
  53.      primary key (course_id, sec_id, semester, year),
  54.      foreign key (course_id) references course(course_id)
  55.         on delete cascade,
  56.      foreign key (building, room_number) references classroom(building, room_number)
  57.         on delete set null
  58.     );
  59. create table teaches
  60.     (ID            varchar(5), 
  61.      course_id        varchar(8),
  62.      sec_id            varchar(8), 
  63.      semester        varchar(6),
  64.      year            numeric(4,0),
  65.      primary key (ID, course_id, sec_id, semester, year),
  66.      foreign key (course_id,sec_id, semester, year) references section(course_id,sec_id, semester, year)
  67.         on delete cascade,
  68.      foreign key (ID) references instructor(ID)
  69.         on delete cascade
  70.     );
  71. create table student
  72.     (ID            varchar(5), 
  73.      name            varchar(20) not null, 
  74.      dept_name        varchar(20), 
  75.      tot_cred        numeric(3,0) check (tot_cred >= 0),
  76.      primary key (ID),
  77.      foreign key (dept_name) references department(dept_name)
  78.         on delete set null
  79.     );
  80. create table takes
  81.     (ID            varchar(5), 
  82.      course_id        varchar(8),
  83.      sec_id            varchar(8), 
  84.      semester        varchar(6),
  85.      year            numeric(4,0),
  86.      grade                varchar(2),
  87.      primary key (ID, course_id, sec_id, semester, year),
  88.      foreign key (course_id,sec_id, semester, year) references section(course_id,sec_id, semester, year)
  89.         on delete cascade,
  90.      foreign key (ID) references student(ID)
  91.         on delete cascade
  92.     );
  93. create table advisor
  94.     (s_ID            varchar(5),
  95.      i_ID            varchar(5),
  96.      primary key (s_ID),
  97.      foreign key (i_ID) references instructor (ID)
  98.         on delete set null,
  99.      foreign key (s_ID) references student (ID)
  100.         on delete cascade
  101.     );
  102. create table time_slot
  103.     (time_slot_id        varchar(4),
  104.      day            varchar(1),
  105.      start_hr        numeric(2) check (start_hr >= 0 and start_hr < 24),
  106.      start_min        numeric(2) check (start_min >= 0 and start_min < 60),
  107.      end_hr            numeric(2) check (end_hr >= 0 and end_hr < 24),
  108.      end_min        numeric(2) check (end_min >= 0 and end_min < 60),
  109.      primary key (time_slot_id, day, start_hr, start_min)
  110.     );
  111. create table prereq
  112.     (course_id        varchar(8), 
  113.      prereq_id        varchar(8),
  114.      primary key (course_id, prereq_id),
  115.      foreign key (course_id) references course(course_id)
  116.         on delete cascade,
  117.      foreign key (prereq_id) references course(course_id)
  118.     )

smallRelationsInsertFile.sql

  1. delete from prereq;
  2. delete from time_slot;
  3. delete from advisor;
  4. delete from takes;
  5. delete from student;
  6. delete from teaches;
  7. delete from section;
  8. delete from instructor;
  9. delete from course;
  10. delete from department;
  11. delete from classroom;
  12. insert into classroom values ('Packard', '101', '500');
  13. insert into classroom values ('Painter', '514', '10');
  14. insert into classroom values ('Taylor', '3128', '70');
  15. insert into classroom values ('Watson', '100', '30');
  16. insert into classroom values ('Watson', '120', '50');
  17. insert into department values ('Biology', 'Watson', '90000');
  18. insert into department values ('Comp. Sci.', 'Taylor', '100000');
  19. insert into department values ('Elec. Eng.', 'Taylor', '85000');
  20. insert into department values ('Finance', 'Painter', '120000');
  21. insert into department values ('History', 'Painter', '50000');
  22. insert into department values ('Music', 'Packard', '80000');
  23. insert into department values ('Physics', 'Watson', '70000');
  24. insert into course values ('BIO-101', 'Intro. to Biology', 'Biology', '4');
  25. insert into course values ('BIO-301', 'Genetics', 'Biology', '4');
  26. insert into course values ('BIO-399', 'Computational Biology', 'Biology', '3');
  27. insert into course values ('CS-101', 'Intro. to Computer Science', 'Comp. Sci.', '4');
  28. insert into course values ('CS-190', 'Game Design', 'Comp. Sci.', '4');
  29. insert into course values ('CS-315', 'Robotics', 'Comp. Sci.', '3');
  30. insert into course values ('CS-319', 'Image Processing', 'Comp. Sci.', '3');
  31. insert into course values ('CS-347', 'Database System Concepts', 'Comp. Sci.', '3');
  32. insert into course values ('EE-181', 'Intro. to Digital Systems', 'Elec. Eng.', '3');
  33. insert into course values ('FIN-201', 'Investment Banking', 'Finance', '3');
  34. insert into course values ('HIS-351', 'World History', 'History', '3');
  35. insert into course values ('MU-199', 'Music Video Production', 'Music', '3');
  36. insert into course values ('PHY-101', 'Physical Principles', 'Physics', '4');
  37. insert into instructor values ('10101', 'Srinivasan', 'Comp. Sci.', '65000');
  38. insert into instructor values ('12121', 'Wu', 'Finance', '90000');
  39. insert into instructor values ('15151', 'Mozart', 'Music', '40000');
  40. insert into instructor values ('22222', 'Einstein', 'Physics', '95000');
  41. insert into instructor values ('32343', 'El Said', 'History', '60000');
  42. insert into instructor values ('33456', 'Gold', 'Physics', '87000');
  43. insert into instructor values ('45565', 'Katz', 'Comp. Sci.', '75000');
  44. insert into instructor values ('58583', 'Califieri', 'History', '62000');
  45. insert into instructor values ('76543', 'Singh', 'Finance', '80000');
  46. insert into instructor values ('76766', 'Crick', 'Biology', '72000');
  47. insert into instructor values ('83821', 'Brandt', 'Comp. Sci.', '92000');
  48. insert into instructor values ('98345', 'Kim', 'Elec. Eng.', '80000');
  49. insert into section values ('BIO-101', '1', 'Summer', '2009', 'Painter', '514', 'B');
  50. insert into section values ('BIO-301', '1', 'Summer', '2010', 'Painter', '514', 'A');
  51. insert into section values ('CS-101', '1', 'Fall', '2009', 'Packard', '101', 'H');
  52. insert into section values ('CS-101', '1', 'Spring', '2010', 'Packard', '101', 'F');
  53. insert into section values ('CS-190', '1', 'Spring', '2009', 'Taylor', '3128', 'E');
  54. insert into section values ('CS-190', '2', 'Spring', '2009', 'Taylor', '3128', 'A');
  55. insert into section values ('CS-315', '1', 'Spring', '2010', 'Watson', '120', 'D');
  56. insert into section values ('CS-319', '1', 'Spring', '2010', 'Watson', '100', 'B');
  57. insert into section values ('CS-319', '2', 'Spring', '2010', 'Taylor', '3128', 'C');
  58. insert into section values ('CS-347', '1', 'Fall', '2009', 'Taylor', '3128', 'A');
  59. insert into section values ('EE-181', '1', 'Spring', '2009', 'Taylor', '3128', 'C');
  60. insert into section values ('FIN-201', '1', 'Spring', '2010', 'Packard', '101', 'B');
  61. insert into section values ('HIS-351', '1', 'Spring', '2010', 'Painter', '514', 'C');
  62. insert into section values ('MU-199', '1', 'Spring', '2010', 'Packard', '101', 'D');
  63. insert into section values ('PHY-101', '1', 'Fall', '2009', 'Watson', '100', 'A');
  64. insert into teaches values ('10101', 'CS-101', '1', 'Fall', '2009');
  65. insert into teaches values ('10101', 'CS-315', '1', 'Spring', '2010');
  66. insert into teaches values ('10101', 'CS-347', '1', 'Fall', '2009');
  67. insert into teaches values ('12121', 'FIN-201', '1', 'Spring', '2010');
  68. insert into teaches values ('15151', 'MU-199', '1', 'Spring', '2010');
  69. insert into teaches values ('22222', 'PHY-101', '1', 'Fall', '2009');
  70. insert into teaches values ('32343', 'HIS-351', '1', 'Spring', '2010');
  71. insert into teaches values ('45565', 'CS-101', '1', 'Spring', '2010');
  72. insert into teaches values ('45565', 'CS-319', '1', 'Spring', '2010');
  73. insert into teaches values ('76766', 'BIO-101', '1', 'Summer', '2009');
  74. insert into teaches values ('76766', 'BIO-301', '1', 'Summer', '2010');
  75. insert into teaches values ('83821', 'CS-190', '1', 'Spring', '2009');
  76. insert into teaches values ('83821', 'CS-190', '2', 'Spring', '2009');
  77. insert into teaches values ('83821', 'CS-319', '2', 'Spring', '2010');
  78. insert into teaches values ('98345', 'EE-181', '1', 'Spring', '2009');
  79. insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102');
  80. insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32');
  81. insert into student values ('19991', 'Brandt', 'History', '80');
  82. insert into student values ('23121', 'Chavez', 'Finance', '110');
  83. insert into student values ('44553', 'Peltier', 'Physics', '56');
  84. insert into student values ('45678', 'Levy', 'Physics', '46');
  85. insert into student values ('54321', 'Williams', 'Comp. Sci.', '54');
  86. insert into student values ('55739', 'Sanchez', 'Music', '38');
  87. insert into student values ('70557', 'Snow', 'Physics', '0');
  88. insert into student values ('76543', 'Brown', 'Comp. Sci.', '58');
  89. insert into student values ('76653', 'Aoi', 'Elec. Eng.', '60');
  90. insert into student values ('98765', 'Bourikas', 'Elec. Eng.', '98');
  91. insert into student values ('98988', 'Tanaka', 'Biology', '120');
  92. insert into takes values ('00128', 'CS-101', '1', 'Fall', '2009', 'A');
  93. insert into takes values ('00128', 'CS-347', '1', 'Fall', '2009', 'A-');
  94. insert into takes values ('12345', 'CS-101', '1', 'Fall', '2009', 'C');
  95. insert into takes values ('12345', 'CS-190', '2', 'Spring', '2009', 'A');
  96. insert into takes values ('12345', 'CS-315', '1', 'Spring', '2010', 'A');
  97. insert into takes values ('12345', 'CS-347', '1', 'Fall', '2009', 'A');
  98. insert into takes values ('19991', 'HIS-351', '1', 'Spring', '2010', 'B');
  99. insert into takes values ('23121', 'FIN-201', '1', 'Spring', '2010', 'C+');
  100. insert into takes values ('44553', 'PHY-101', '1', 'Fall', '2009', 'B-');
  101. insert into takes values ('45678', 'CS-101', '1', 'Fall', '2009', 'F');
  102. insert into takes values ('45678', 'CS-101', '1', 'Spring', '2010', 'B+');
  103. insert into takes values ('45678', 'CS-319', '1', 'Spring', '2010', 'B');
  104. insert into takes values ('54321', 'CS-101', '1', 'Fall', '2009', 'A-');
  105. insert into takes values ('54321', 'CS-190', '2', 'Spring', '2009', 'B+');
  106. insert into takes values ('55739', 'MU-199', '1', 'Spring', '2010', 'A-');
  107. insert into takes values ('76543', 'CS-101', '1', 'Fall', '2009', 'A');
  108. insert into takes values ('76543', 'CS-319', '2', 'Spring', '2010', 'A');
  109. insert into takes values ('76653', 'EE-181', '1', 'Spring', '2009', 'C');
  110. insert into takes values ('98765', 'CS-101', '1', 'Fall', '2009', 'C-');
  111. insert into takes values ('98765', 'CS-315', '1', 'Spring', '2010', 'B');
  112. insert into takes values ('98988', 'BIO-101', '1', 'Summer', '2009', 'A');
  113. insert into takes values ('98988', 'BIO-301', '1', 'Summer', '2010', null);
  114. insert into advisor values ('00128', '45565');
  115. insert into advisor values ('12345', '10101');
  116. insert into advisor values ('23121', '76543');
  117. insert into advisor values ('44553', '22222');
  118. insert into advisor values ('45678', '22222');
  119. insert into advisor values ('76543', '45565');
  120. insert into advisor values ('76653', '98345');
  121. insert into advisor values ('98765', '98345');
  122. insert into advisor values ('98988', '76766');
  123. insert into time_slot values ('A', 'M', '8', '0', '8', '50');
  124. insert into time_slot values ('A', 'W', '8', '0', '8', '50');
  125. insert into time_slot values ('A', 'F', '8', '0', '8', '50');
  126. insert into time_slot values ('B', 'M', '9', '0', '9', '50');
  127. insert into time_slot values ('B', 'W', '9', '0', '9', '50');
  128. insert into time_slot values ('B', 'F', '9', '0', '9', '50');
  129. insert into time_slot values ('C', 'M', '11', '0', '11', '50');
  130. insert into time_slot values ('C', 'W', '11', '0', '11', '50');
  131. insert into time_slot values ('C', 'F', '11', '0', '11', '50');
  132. insert into time_slot values ('D', 'M', '13', '0', '13', '50');
  133. insert into time_slot values ('D', 'W', '13', '0', '13', '50');
  134. insert into time_slot values ('D', 'F', '13', '0', '13', '50');
  135. insert into time_slot values ('E', 'T', '10', '30', '11', '45 ');
  136. insert into time_slot values ('E', 'R', '10', '30', '11', '45 ');
  137. insert into time_slot values ('F', 'T', '14', '30', '15', '45 ');
  138. insert into time_slot values ('F', 'R', '14', '30', '15', '45 ');
  139. insert into time_slot values ('G', 'M', '16', '0', '16', '50');
  140. insert into time_slot values ('G', 'W', '16', '0', '16', '50');
  141. insert into time_slot values ('G', 'F', '16', '0', '16', '50');
  142. insert into time_slot values ('H', 'W', '10', '0', '12', '30');
  143. insert into prereq values ('BIO-301', 'BIO-101');
  144. insert into prereq values ('BIO-399', 'BIO-101');
  145. insert into prereq values ('CS-190', 'CS-101');
  146. insert into prereq values ('CS-315', 'CS-101');
  147. insert into prereq values ('CS-319', 'CS-101');
  148. insert into prereq values ('CS-347', 'CS-101');
  149. insert into prereq values ('EE-181', 'PHY-101');

将上述sql文件导入到数据库中

第一次导入的话就导入DDL-MySQL.sql,
如果之前导入过DDL-MySQL.sql,想重建数据库,就导入DDL-MySQL+drop.sql,
然后导入smallRelationsInsertFile.sql初始化数据即可.

发表评论

表情：
评论列表 （有 0 条评论，11人围观）

还没有评论，来说两句吧...

相关阅读