|
51
createString_3 += "name
varchar(20) not null,";
52
createString_3 += " dept_name
varchar(20),";
53
createString_3 += " salary
numeric(8,2) check (salary > 29000),";
54
createString_3 += " primary key (ID),";
55
createString_3 += " foreign key (dept_name) references department (dept_name)\r\n"+
"
on delete set null)";
56
57
58
String createString_4 = "CREATE TABLE section";
59
createString_4 += "(course_id
varchar(8),";
60
createString_4 += "
sec_id
varchar(8),";
61
createString_4 += " semester
varchar(6)";
62
createString_4 += "check (semester in ('Fall', 'Winter', 'Spring', 'Summer')), ";
63
createString_4 += " year
numeric(4,0) check (year > 1701 and year <
2100), ";
64
createString_4 += " building
varchar(15),";
65
createString_4 += " room_number
varchar(7),";
66
createString_4 += " time_slot_id
varchar(4),";
67
createString_4 += " primary key (course_id, sec_id, semester, year),";
68
createString_4 +=
" foreign key (course_id) references course (course_id) on delete
cascade,";
69
createString_4 += " foreign key (building, room_number) references classroom
(building, room_number)\r\n"+ "on delete set null)";
70
71
72
String createString_5 = "CREATE TABLE teaches";
73
createString_5 += "(ID
varchar(5), ";
74
createString_5 += " course_id
varchar(8),";
75
createString_5 +=
varchar(8),";
76
createString_5 += " semester
varchar(6),";
77
createString_5 += " year
numeric(4,0),";
78
createString_5 += " primary key (ID, course_id, sec_id, semester, year),";
79
createString_5 += " foreign key (course_id, sec_id, semester, year) references
section (course_id, sec_id, semester, year)\r\n"+ "
on delete cascade,";
80
createString_5 += " foreign key (ID) references instructor (ID)\r\n" + "on delete
cascade)";
81
82
83
String createString_6 = "CREATE TABLE student";
84
createString_6 += "(ID
varchar(5), ";
85
createString_6 += " name
varchar(20) not null, ";
86
createString_6 += " dept_name
varchar(20),";
87
createString_6 +=
numeric(3,0) check (tot_cred >= 0),";
88
createString_6 += " primary key (ID),";
89
createString_6 += " foreign key (dept_name) references department (dept_name)\r\n"+
"
on delete set null)";
90
91
92
93
String createString_7 = "CREATE TABLE takes";
94
createString_7 += "(ID
varchar(5), ";
95
createString_7 += "course_id
varchar(8),";
96
createString_7 += " sec_id
varchar(8), ";
97
createString_7 += " semester
varchar(6),";