-
Notifications
You must be signed in to change notification settings - Fork 0
/
ddl.sql
138 lines (129 loc) · 10.7 KB
/
ddl.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
create dep:ENGNDP set depname="Departmant of engineering";
create dep:DATASC set depname="Departmant of Data Scince";
create dep:KEMSDP set depname="Departmant of chemestry";
create dep:ARKDCE set depname="Departmant of architecture";
create student:960544752 set stname='Ali Alawi', stmjr='MATHEMATICS', stbyear=1377, stbmonth=3, stbday=21;
create student:960544753 set stname='Ali Alawian', stmjr='MATHEMATICS', stbyear=1377, stbmonth=9, stbday=26;
create student:970544754 set stname='Ali Alipour', stmjr='MATHEMATICS', stbyear=1378, stbmonth=3, stbday=14;
create student:980544755 set stname='Ali Ali zadeh', stmjr='MATHEMATICS', stbyear= 1380, stbmonth=10, stbday=2 ;
create student:960214712 set stname='Amin Amini', stmjr='COMPUTER', stbyear=1377, stbmonth=12, stbday=24;
create student:960214114 set stname='Amin khaki', stmjr='COMPUTER', stbyear= 1378, stbmonth=9, stbday=29;
create student:950214718 set stname='Amin Abi', stmjr='COMPUTER', stbyear=1376, stbmonth=3, stbday=2 ;
create student:970214745 set stname='Amin Zamini', stmjr='COMPUTER', stbyear=1379, stbmonth= 5, stbday=18;
create student:970214464 set stname='Amin Asmani', stmjr='COMPUTER', stbyear=1379, stbmonth= 4, stbday=4 ;
create student:980214772 set stname='Amin Havaie', stmjr='COMPUTER', stbyear=1379, stbmonth=10, stbday=1 ;
create student:990214772 set stname='Amin Atashi', stmjr='COMPUTER', stbyear=1381, stbmonth=1, stbday=12;
create student:970845269 set stname='Amir Amiri', stmjr='CIVIL', stbyear=1378, stbmonth=9, stbday=29;
create student:980845278 set stname='Amir Sanati', stmjr='CIVIL', stbyear=1379, stbmonth=10, stbday=3 ;
create student:960845299 set stname='Amir Sonnati', stmjr='CIVIL', stbyear=1378, stbmonth=3, stbday=4 ;
create student:990845285 set stname='Amir Alaska', stmjr='CIVIL', stbyear=1380, stbmonth=9, stbday=30;
create student:950845201 set stname='Amir Bastani', stmjr='CIVIL', stbyear=1376, stbmonth=10, stbday=26;
create student:960216644 set stname='Homan Hamidpour', stmjr='COMPUTER', stbyear=1378, stbmonth=2, stbday=29;
create student:970216657 set stname='Ali Memezadegan', stmjr='COMPUTER', stbyear=1379, stbmonth=6, stbday=26;
relate student:960544752->stdep->dep:DATASC;
relate student:960544753->stdep->dep:DATASC;
relate student:970544754->stdep->dep:DATASC;
relate student:980544755->stdep->dep:DATASC;
relate student:960214712->stdep->dep:DATASC;
relate student:960214114->stdep->dep:DATASC;
relate student:950214718->stdep->dep:DATASC;
relate student:970214745->stdep->dep:DATASC;
relate student:970214464->stdep->dep:DATASC;
relate student:980214772->stdep->dep:DATASC;
relate student:990214772->stdep->dep:DATASC;
relate student:970845269->stdep->dep:ARKDCE;
relate student:980845278->stdep->dep:ARKDCE;
relate student:960845299->stdep->dep:ARKDCE;
relate student:990845285->stdep->dep:ARKDCE;
relate student:950845201->stdep->dep:ARKDCE;
relate student:960216644->stdep->dep:DATASC;
relate student:970216657->stdep->dep:DATASC;
create prof:1 set profname='Maryam 1', profbyear=1372, profbmonth=2, profbday=2 ;
create prof:2 set profname='Maryam 2', profbyear=1370, profbmonth=11, profbday=8 ;
create prof:3 set profname='Maryam 3', profbyear=1371, profbmonth=12, profbday=24;
create prof:4 set profname='Maryam 4', profbyear=1369, profbmonth=4, profbday=4 ;
create prof:5 set profname='Reza 1', profbyear=1367, profbmonth=5, profbday=15;
create prof:6 set profname='Reza 2', profbyear=1361, profbmonth=7, profbday=7 ;
create prof:7 set profname='Reza 3', profbyear=1358, profbmonth=12, profbday=4 ;
create prof:8 set profname='Reza 4', profbyear=1353, profbmonth=2, profbday=14;
create prof:9 set profname='Sina 1', profbyear=1358, profbmonth=11, profbday=1 ;
create prof:10 set profname='Sina 2', profbyear=1358, profbmonth=12, profbday=4 ;
create prof:11 set profname='Sina 3', profbyear=1358, profbmonth=1, profbday=12;
create prof:12 set profname='Sina 4', profbyear=1358, profbmonth=7, profbday=10;
relate prof:1->profdep->dep:DATASC;
relate prof:2->profdep->dep:DATASC;
relate prof:3->profdep->dep:DATASC;
relate prof:4->profdep->dep:DATASC;
relate prof:5->profdep->dep:DATASC;
relate prof:6->profdep->dep:ARKDCE;
relate prof:7->profdep->dep:ARKDCE;
relate prof:8->profdep->dep:DATASC;
relate prof:9->profdep->dep:ARKDCE;
relate prof:10->profdep->dep:ARKDCE;
relate prof:11->profdep->dep:ARKDCE;
relate prof:12->profdep->dep:ARKDCE;
create course:CS1101 set cotitle='Programming Fundementals', credit=3, cotype='t';
create course:CS1102 set cotitle='Advanced Programming', credit=3, cotype='t';
create course:CS2203 set cotitle='Databases 1', credit=3, cotype='t';
create course:CS2301 set cotitle='Operating Systems', credit=3, cotype='t';
create course:CS2401 set cotitle='Software Engneering 1', credit=3, cotype='t';
create course:CS3303 set cotitle='Data Structures', credit=3, cotype='t';
create course:CS4403 set cotitle='Software Engneering 2', credit=3, cotype='t';
create course:CS3306 set cotitle='Databases 2', credit=3, cotype='t';
create course:MATH1211 set cotitle='Calculus 1', credit=3, cotype='t';
create course:MATH2211 set cotitle='Calculus 2', credit=3, cotype='t';
create course:MATH3211 set cotitle='Calculus 3', credit=3, cotype='t';
create course:CE2110 set cotitle='Applied Mechanics I', credit=3, cotype='t';
create course:CE2120 set cotitle='Applied Mechanics II', credit=3, cotype='t';
create course:CE2211 set cotitle='Engineering Economics I', credit=1, cotype='t';
create course:CE2310 set cotitle='Environmental Engineering Fundamentals', credit=3, cotype='t';
create course:CE3110 set cotitle='Mechanics of Materials', credit=3, cotype='t';
relate course:CS1101->codep->dep:DATASC;
relate course:CS1102->codep->dep:DATASC;
relate course:CS2203->codep->dep:DATASC;
relate course:CS2301->codep->dep:DATASC;
relate course:CS2401->codep->dep:DATASC;
relate course:CS3303->codep->dep:DATASC;
relate course:CS4403->codep->dep:DATASC;
relate course:CS3306->codep->dep:DATASC;
relate course:MATH1211->codep->dep:DATASC;
relate course:MATH2211->codep->dep:DATASC;
relate course:MATH3211->codep->dep:DATASC;
relate course:CE2110->codep->dep:ARKDCE;
relate course:CE2120->codep->dep:ARKDCE;
relate course:CE2211->codep->dep:ARKDCE;
relate course:CE2310->codep->dep:ARKDCE;
relate course:CE3110->codep->dep:ARKDCE;
relate student:960216644->studentCourse->course:MATH1211 set prof=prof:5, yr=1396, tr=1, finalyear=1396, finalmonth=9, finalday=29, grade=9.75;
relate student:960214712->studentCourse->course:MATH1211 set prof=prof:5, yr=1396, tr=1, finalyear=1396, finalmonth=9, finalday=29, grade=15.5;
relate student:960214114->studentCourse->course:MATH1211 set prof=prof:10, yr=1396, tr=1, finalyear=1396, finalmonth=9, finalday=29, grade=11;
relate student:950214718->studentCourse->course:MATH1211 set prof=prof:10, yr=1396, tr=1, finalyear=1396, finalmonth=9, finalday=29, grade=10;
relate student:960845299->studentCourse->course:MATH1211 set prof=prof:9, yr=1396, tr=1, finalyear=1396, finalmonth=9, finalday=29, grade=9.75;
relate student:960216644->studentCourse->course:MATH1211 set prof=prof:10, yr=1396, tr=2, finalyear=1397, finalmonth=3, finalday=1, grade=9.75;
relate student:960845299->studentCourse->course:MATH1211 set prof=prof:10, yr=1396, tr=2, finalyear=1397, finalmonth=3, finalday=1, grade=10.25;
relate student:960216644->studentCourse->course:MATH1211 set prof=prof:9, yr=1397, tr=1, finalyear=1397, finalmonth=10, finalday=2, grade=11;
relate student:970214745->studentCourse->course:MATH1211 set prof=prof:9, yr=1397, tr=1, finalyear=1397, finalmonth=10, finalday=2, grade=0;
relate student:970214464->studentCourse->course:MATH1211 set prof=prof:5, yr=1397, tr=1, finalyear=1397, finalmonth=10, finalday=2, grade=9.75;
relate student:970845269->studentCourse->course:MATH1211 set prof=prof:5, yr=1397, tr=1, finalyear=1397, finalmonth=10, finalday=2, grade=12.5;
relate student:970216657->studentCourse->course:MATH1211 set prof=prof:10, yr=1397, tr=1, finalyear=1397, finalmonth=10, finalday=2, grade=16;
relate student:970214745->studentCourse->course:MATH1211 set prof=prof:5, yr=1397, tr=2, finalyear=1398, finalmonth=2, finalday=27, grade=20;
relate student:970214464->studentCourse->course:MATH1211 set prof=prof:5, yr=1397, tr=2, finalyear=1398, finalmonth=2, finalday=27, grade=7;
relate student:970214464->studentCourse->course:MATH1211 set prof=prof:9, yr=1398, tr=1, finalyear=1398, finalmonth=10, finalday=3, grade=10;
relate student:980214772->studentCourse->course:MATH1211 set prof=prof:9, yr=1398, tr=1, finalyear=1398, finalmonth=10, finalday=3, grade=11.5;
relate student:980845278->studentCourse->course:MATH1211 set prof=prof:5, yr=1398, tr=1, finalyear=1398, finalmonth=10, finalday=3, grade=9.75;
relate student:980845278->studentCourse->course:MATH1211 set prof=prof:5, yr=1398, tr=2, finalyear=1399, finalmonth=2, finalday=5, grade=14.5;
relate student:990214772->studentCourse->course:MATH1211 set prof=prof:10, yr=1399, tr=1, finalyear=1399, finalmonth=10, finalday=26, grade=20;
relate student:990845285->studentCourse->course:MATH1211 set prof=prof:10, yr=1399, tr=1, finalyear=1399, finalmonth=10, finalday=26, grade=20;
relate student:960216644->studentCourse->course:CS2203 set prof=prof:2, yr=1398, tr=1, finalyear=1398, finalmonth=11, finalday=5, grade=18;
relate student:960214712->studentCourse->course:CS2203 set prof=prof:2, yr=1398, tr=1, finalyear=1398, finalmonth=11, finalday=5, grade=12;
relate student:970216657->studentCourse->course:CS2203 set prof=prof:3, yr=1399, tr=1, finalyear=1399, finalmonth=11, finalday=7, grade=null;
relate student:970845269->studentCourse->course:CE2110 set prof=prof:9, yr=1397, tr=1, finalyear=1397, finalmonth=11, finalday=4, grade=18.5;
relate student:970845269->studentCourse->course:CE2120 set prof=prof:10, yr=1397, tr=2, finalyear=1398, finalmonth=3, finalday=4, grade=14.5;
create phone:960544753 set stNumber+=['989172581463'];
create phone:980214772 set stNumber+=['989142541441'];
create phone:950845201 set stNumber+=['989262478145'];
create phone:970216657 set stNumber+=['989324581447'];
create phone:960216644 set stNumber+=['989885421746'];
create phone:980845278 set stNumber+=['989445521458'];
create phone:960845299 set stNumber+=['989124578521'];
create phone:980544755 set stNumber+=['989173541565'];