-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathscript_3.sql
More file actions
117 lines (109 loc) · 4.93 KB
/
script_3.sql
File metadata and controls
117 lines (109 loc) · 4.93 KB
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
INSERT INTO Department (Name, Budget, Administrator, StartDate) VALUES
('Business', 50000, 'Alex', '01.09.2014'),
('Computer Science', 100000, 'Rustam', '01.09.2015');
INSERT INTO Course (Title, Credits, DepartmentID) VALUES
('Business Foundations', 10, (SELECT DepartmentID
FROM Department
WHERE Name == 'Business')),
('Business Analytics', 12, (SELECT DepartmentID
FROM Department
WHERE Name == 'Business')),
('Python for Everybody', 10, (SELECT DepartmentID
FROM Department
WHERE Name == 'Computer Science')),
('Mathematics', 12, (SELECT DepartmentID
FROM Department
WHERE Name == 'Computer Science'));
INSERT INTO OnlineCourse (CourseID, URL) VALUES
((SELECT CourseID
FROM Course
WHERE Title == 'Business Analytics'), 'https://www.coursera.org/specializations/business-analytics'),
((SELECT CourseID
FROM Course
WHERE Title == 'Algorithms'), 'https://www.coursera.org/specializations/algorithms');
INSERT INTO OnsiteCourse (CourseID, Location, Days, Time) VALUES
((SELECT CourseID
FROM Course
WHERE Title == 'Business Foundations'), 'Odessa, Balkivskya street, house 54b', 90, '2 hours'),
((SELECT CourseID
FROM Course
WHERE Title == 'Python for Everybody'), 'Odessa, Balkivskya street, house 54b', 60, '1.5 hours');
INSERT INTO Person (LastName, FirstName, HireDate, EnrollmentDate) VALUES
('Vegner', 'Alex', '05.09.2014', '10.09.2014'),
('Shah', 'Rustam', '15.09.2014', '20.09.2014'),
('Vegner', 'Eugene', '25.09.2014', '30.09.2014'),
('Makarenko', 'Valeria', '05.10.2014', '10.10.2014'),
('Burkun', 'Anton', '15.10.2014', '20.10.2014'),
('Stels', 'Valera', '25.10.2014', '30.10.2014');
INSERT INTO StudentGrade (CourseID, StudentID, Grade) VALUES
((SELECT CourseID
FROM Course
WHERE Title == 'Business Foundations'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Alex'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Business Analytics'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Alex'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Python for Everybody'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Alex'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Python for Everybody'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Rustam'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Python for Everybody'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Eugene'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Mathematics'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Rustam'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Mathematics'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Valeria'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Mathematics'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Anton'), '1'),
((SELECT CourseID
FROM Course
WHERE Title == 'Mathematics'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Valera'), '1');
INSERT INTO CourseInstructor (CourseID, PersonID) VALUES
((SELECT CourseID
FROM Course
WHERE Title == 'Business Foundations'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Alex')),
((SELECT CourseID
FROM Course
WHERE Title == 'Business Analytics'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Alex')),
((SELECT CourseID
FROM Course
WHERE Title == 'Python for Everybody'), (SELECT PersonID
FROM Person
WHERE FirstName == 'Rustam'));
INSERT INTO OfficeAssignment (InstructorID, Location, TimeStamp) VALUES
((SELECT PersonID
FROM Person
WHERE FirstName == 'Eugene'), '101 room', 1413763200),
((SELECT PersonID
FROM Person
WHERE FirstName == 'Rustam'), '102 room', 1413763200),
((SELECT PersonID
FROM Person
WHERE FirstName == 'Alex'), '103 room', 1413763200);