-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinsert_data_table_university.sql
More file actions
270 lines (265 loc) · 12.7 KB
/
Copy pathinsert_data_table_university.sql
File metadata and controls
270 lines (265 loc) · 12.7 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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
-- Insert data mahasiswa (50 mahasiswa)
INSERT INTO Mahasiswa (MahasiswaID, NIM, Nama, Alamat, TanggalLahir, Gender)
VALUES
(1, '20231001', 'Budi Santoso', 'Jl. Merdeka 123', '2001-05-10', 'Laki-laki'),
(2, '20231002', 'Siti Nurhaliza', 'Jl. Sudirman 45', '2002-06-12', 'Perempuan'),
(3, '20231003', 'Andi Wijaya', 'Jl. Raya 67', '2001-07-15', 'Laki-laki'),
(4, '20231004', 'Lina Susanti', 'Jl. Alun-Alun 89', '2000-08-10', 'Perempuan'),
(5, '20231005', 'Joko Prasetyo', 'Jl. Pemuda 12', '2001-09-21', 'Laki-laki'),
(6, '20231006', 'Dian Septiani', 'Jl. Merpati 34', '2002-10-30', 'Perempuan'),
(7, '20231007', 'Rudi Hartono', 'Jl. Kenanga 56', '2002-11-05', 'Laki-laki'),
(8, '20231008', 'Wati Hidayati', 'Jl. Seruni 78', '2001-12-25', 'Perempuan'),
(9, '20231009', 'Faisal Rahman', 'Jl. Pahlawan 90', '2001-01-18', 'Laki-laki'),
(10, '20231010', 'Putri Amalia', 'Jl. Cendana 23', '2000-02-14', 'Perempuan'),
(11, '20231011', 'Riko Budianto', 'Jl. Merpati 45', '2001-03-12', 'Laki-laki'),
(12, '20231012', 'Fani Wahyuni', 'Jl. Cikini 67', '2002-04-10', 'Perempuan'),
(13, '20231013', 'Irwan Santoso', 'Jl. Melati 89', '2000-05-25', 'Laki-laki'),
(14, '20231014', 'Nina Kurniawati', 'Jl. Sakura 12', '2001-06-20', 'Perempuan'),
(15, '20231015', 'Gilang Ramadhan', 'Jl. Teratai 34', '2002-07-14', 'Laki-laki'),
(16, '20231016', 'Desi Putri', 'Jl. Wijaya 56', '2001-08-18', 'Perempuan'),
(17, '20231017', 'Benny Kusuma', 'Jl. Jambu 78', '2002-09-22', 'Laki-laki'),
(18, '20231018', 'Vera Anggraini', 'Jl. Duren 90', '2001-10-10', 'Perempuan'),
(19, '20231019', 'Agus Prabowo', 'Jl. Merdeka 23', '2002-11-15', 'Laki-laki'),
(20, '20231020', 'Tina Marlina', 'Jl. Alamsari 45', '2001-12-05', 'Perempuan'),
(21, '20231021', 'Tono Sulistyo', 'Jl. Karunia 67', '2002-01-14', 'Laki-laki'),
(22, '20231022', 'Yani Fitriani', 'Jl. Sumber 89', '2001-02-08', 'Perempuan'),
(23, '20231023', 'Bambang Suryono', 'Jl. Kencana 12', '2002-03-19', 'Laki-laki'),
(24, '20231024', 'Dewi Yuliana', 'Jl. Harmoni 34', '2001-04-23', 'Perempuan'),
(25, '20231025', 'Hendrik Tulus', 'Jl. Gading 56', '2002-05-30', 'Laki-laki'),
(26, '20231026', 'Mira Kurniasari', 'Jl. Kenanga 78', '2001-06-15', 'Perempuan'),
(27, '20231027', 'Abdul Aziz', 'Jl. Taman 90', '2002-07-12', 'Laki-laki'),
(28, '20231028', 'Rini Anggraini', 'Jl. Pahlawan 23', '2001-08-05', 'Perempuan'),
(29, '20231029', 'Fajar Prasetyo', 'Jl. Melati 45', '2002-09-14', 'Laki-laki'),
(30, '20231030', 'Indah Saraswati', 'Jl. Sinar 67', '2001-10-20', 'Perempuan'),
(31, '20231031', 'Rudi Eka', 'Jl. Jati 89', '2002-11-05', 'Laki-laki'),
(32, '20231032', 'Beni Sugiarto', 'Jl. Nangka 12', '2001-12-12', 'Laki-laki'),
(33, '20231033', 'Siska Pramudya', 'Jl. Hutan 34', '2002-01-07', 'Perempuan'),
(34, '20231034', 'Yusuf Gunawan', 'Jl. Anggrek 56', '2001-02-15', 'Laki-laki'),
(35, '20231035', 'Rina Susanti', 'Jl. Sayang 78', '2002-03-28', 'Perempuan'),
(36, '20231036', 'Agung Santosa', 'Jl. Biru 90', '2001-04-10', 'Laki-laki'),
(37, '20231037', 'Fina Amalia', 'Jl. Sempurna 23', '2002-05-25', 'Perempuan'),
(38, '20231038', 'Harry Suryadi', 'Jl. Kamboja 45', '2001-06-14', 'Laki-laki'),
(39, '20231039', 'Maya Julianti', 'Jl. Mangga 67', '2002-07-05', 'Perempuan'),
(40, '20231040', 'Gita Rahayu', 'Jl. Kuning 89', '2001-08-22', 'Perempuan'),
(41, '20231041', 'Soleh Ramadhan', 'Jl. Pasar 12', '2002-09-10', 'Laki-laki'),
(42, '20231042', 'Sari Fitri', 'Jl. Wira 34', '2001-10-18', 'Perempuan'),
(43, '20231043', 'Arief Wibowo', 'Jl. Mawar 56', '2002-11-25', 'Laki-laki'),
(44, '20231044', 'Ruth Dewi', 'Jl. Lestari 78', '2001-12-01', 'Perempuan'),
(45, '20231045', 'Yani Kurniadi', 'Jl. Gading 90', '2002-01-29', 'Perempuan'),
(46, '20231046', 'Lina Dwi', 'Jl. Bunga 23', '2001-02-25', 'Perempuan'),
(47, '20231047', 'Farel Satria', 'Jl. Bangunan 45', '2002-03-17', 'Laki-laki'),
(48, '20231048', 'Mila Pratiwi', 'Jl. Angsana 67', '2001-04-30', 'Perempuan'),
(49, '20231049', 'Dedi Suhardi', 'Jl. Raya 89', '2002-05-09', 'Laki-laki'),
(50, '20231050', 'Ayu Siti', 'Jl. Suka 12', '2001-06-19', 'Perempuan');
-- Insert data mata kuliah (50 mata kuliah)
INSERT INTO MataKuliah (MataKuliahID, KodeMK, NamaMataKuliah, SKS)
VALUES
(1, 'T1', 'Matematika Teknik', 3),
(2, 'T2', 'Fisika Dasar', 3),
(3, 'T3', 'Statistika Terapan', 3),
(4, 'T4', 'Pemrograman Dasar', 4),
(5, 'T5', 'Algoritma dan Struktur Data', 3),
(6, 'T6', 'Dasar-Dasar Elektronika', 4),
(7, 'T7', 'Jaringan Komputer', 3),
(8, 'T8', 'Analisis dan Perancangan Sistem', 3),
(9, 'T9', 'Rekayasa Perangkat Lunak', 4),
(10, 'T10', 'Kalkulus', 3),
(11, 'T11', 'Fisika Listrik', 3),
(12, 'T12', 'Komunikasi Data', 3),
(13, 'T13', 'Kecerdasan Buatan', 4),
(14, 'T14', 'Pengantar Robotika', 3),
(15, 'T15', 'Sistem Informasi', 3),
(16, 'T16', 'Metode Numerik', 3),
(17, 'T17', 'Dasar-Dasar Mekatronika', 4),
(18, 'T18', 'Matematika Diskrit', 3),
(19, 'T19', 'Keamanan Sistem Informasi', 3),
(20, 'T20', 'Manajemen Proyek Teknologi', 3),
(21, 'T21', 'Pengolahan Citra Digital', 4),
(22, 'T22', 'Sistem Operasi', 4),
(23, 'T23', 'Elektronika Dasar', 3),
(24, 'T24', 'Matematika Keuangan', 3),
(25, 'T25', 'Basis Data', 4),
(26, 'T26', 'Teknik Kompilasi', 3),
(27, 'T27', 'Pengantar Sistem Informasi', 3),
(28, 'T28', 'Simulasi dan Model', 3),
(29, 'T29', 'Metode Penelitian', 3),
(30, 'T30', 'Dasar-Dasar Teknik Komputer', 4),
(31, 'T31', 'Pendidikan Pancasila', 2),
(32, 'T32', 'Bahasa Indonesia', 2),
(33, 'T33', 'Kewirausahaan', 3),
(34, 'T34', 'Ilmu Budaya Dasar', 2),
(35, 'T35', 'Pengantar Ekonomi', 3),
(36, 'T36', 'Pengenalan Teknik Industri', 4),
(37, 'T37', 'Logika Matematika', 3),
(38, 'T38', 'Statistik', 3),
(39, 'T39', 'Desain Interaksi Pengguna', 3),
(40, 'T40', 'Sistem Embedded', 4),
(41, 'T41', 'Pemrograman Web', 3),
(42, 'T42', 'Jaringan Wireless', 3),
(43, 'T43', 'Komunikasi Mobile', 3),
(44, 'T44', 'Sistem Kontrol', 4),
(45, 'T45', 'Pengantar Teknologi Informasi', 3),
(46, 'T46', 'Data Mining', 4),
(47, 'T47', 'Pengantar Cloud Computing', 3),
(48, 'T48', 'Grafika Komputer', 3),
(49, 'T49', 'Cloud Infrastructure', 4),
(50, 'T50', 'Teknik Pengolahan Data', 3);
-- Insert data dosen (50 dosen)
INSERT INTO Dosen (DosenID, NIDN, NamaDosen, Fakultas)
VALUES
(1, '123456789', 'Dr. Arief Budiman', 'Fakultas Teknik'),
(2, '987654321', 'Prof. Rina Suryani', 'Fakultas Teknik'),
(3, '112233445', 'Dr. Budi Santosa', 'Fakultas Teknik'),
(4, '223344556', 'Prof. Siti Nurhaliza', 'Fakultas Teknik'),
(5, '334455667', 'Dr. Agus Prabowo', 'Fakultas Teknik'),
(6, '445566778', 'Dr. Dwi Prasetyo', 'Fakultas Teknik'),
(7, '556677889', 'Prof. Hendra Gunawan', 'Fakultas Teknik'),
(8, '667788990', 'Dr. Eva Suryani', 'Fakultas Teknik'),
(9, '778899001', 'Dr. Tono Sulistyo', 'Fakultas Teknik'),
(10, '889900112', 'Prof. Lian Fitria', 'Fakultas Teknik'),
(11, '990011223', 'Dr. Iwan Santoso', 'Fakultas Teknik'),
(12, '101223334', 'Prof. Gita Ramadhan', 'Fakultas Teknik'),
(13, '112334445', 'Dr. Maya Putri', 'Fakultas Teknik'),
(14, '223445556', 'Prof. Fahri Taufik', 'Fakultas Teknik'),
(15, '334556667', 'Dr. Rina Hidayati', 'Fakultas Teknik'),
(16, '445667778', 'Prof. Erwin Hakim', 'Fakultas Teknik'),
(17, '556778889', 'Dr. Laila Sari', 'Fakultas Teknik'),
(18, '667889990', 'Prof. Ramlan Wirawan', 'Fakultas Teknik'),
(19, '778990001', 'Dr. Asep Kurniawan', 'Fakultas Teknik'),
(20, '889001112', 'Prof. Indra Wijaya', 'Fakultas Teknik'),
(21, '990112223', 'Dr. Nina Safitri', 'Fakultas Teknik'),
(22, '101223334', 'Prof. Siti Nur', 'Fakultas Teknik'),
(23, '112334445', 'Dr. Azman Syahril', 'Fakultas Teknik'),
(24, '223445556', 'Prof. Diana Sari', 'Fakultas Teknik'),
(25, '334556667', 'Dr. Nanda Susanto', 'Fakultas Teknik'),
(26, '445667778', 'Prof. Irwan Sutrisno', 'Fakultas Teknik'),
(27, '556778889', 'Dr. Feni Hamsa', 'Fakultas Teknik'),
(28, '667889990', 'Prof. Zulkarnain Syah', 'Fakultas Teknik'),
(29, '778990001', 'Dr. Benny Pramudya', 'Fakultas Teknik'),
(30, '889001112', 'Prof. Clara Fitriani', 'Fakultas Teknik'),
(31, '990112223', 'Dr. Ivan Saputra', 'Fakultas Teknik'),
(32, '101223334', 'Prof. Yani Lestari', 'Fakultas Teknik'),
(33, '112334445', 'Dr. Joko Wibowo', 'Fakultas Teknik'),
(34, '223445556', 'Prof. Alif Wijaya', 'Fakultas Teknik'),
(35, '334556667', 'Dr. Lina Malasari', 'Fakultas Teknik'),
(36, '445667778', 'Prof. Dwi Marwanto', 'Fakultas Teknik'),
(37, '556778889', 'Dr. Novi Kurniawati', 'Fakultas Teknik'),
(38, '667889990', 'Prof. Rudy Gunawan', 'Fakultas Teknik'),
(39, '778990001', 'Dr. Ika Suyati', 'Fakultas Teknik'),
(40, '889001112', 'Prof. Yuda Satria', 'Fakultas Teknik'),
(41, '990112223', 'Dr. Taufik Kurnia', 'Fakultas Teknik'),
(42, '101223334', 'Prof. Lina Setiawati', 'Fakultas Teknik'),
(43, '112334445', 'Dr. Surya Indrawan', 'Fakultas Teknik'),
(44, '223445556', 'Prof. Ardiansyah Roni', 'Fakultas Teknik'),
(45, '334556667', 'Dr. Lily Sabrina', 'Fakultas Teknik'),
(46, '445667778', 'Prof. Doni Prakoso', 'Fakultas Teknik'),
(47, '556778889', 'Dr. Ria Mustika', 'Fakultas Teknik'),
(48, '667889990', 'Prof. Taufik Santoso', 'Fakultas Teknik'),
(49, '778990001', 'Dr. Lina Wulandari', 'Fakultas Teknik'),
(50, '889001112', 'Prof. Fredi Rahman', 'Fakultas Teknik');
-- Insert data mengajar (50 mengajar)
INSERT INTO Mengajar (MengajarID, DosenID, MataKuliahID, Semester, TahunAkademik)
VALUES
(1, 1, 1, 'Semester 1', '2025/2026'),
(2, 2, 2, 'Semester 1', '2025/2026'),
(3, 3, 3, 'Semester 1', '2025/2026'),
(4, 4, 4, 'Semester 1', '2025/2026'),
(5, 5, 5, 'Semester 1', '2025/2026'),
(6, 6, 6, 'Semester 1', '2025/2026'),
(7, 7, 7, 'Semester 2', '2025/2026'),
(8, 8, 8, 'Semester 2', '2025/2026'),
(9, 9, 9, 'Semester 2', '2025/2026'),
(10, 10, 10, 'Semester 2', '2025/2026'),
(11, 11, 11, 'Semester 2', '2025/2026'),
(12, 12, 12, 'Semester 2', '2025/2026'),
(13, 13, 13, 'Semester 3', '2025/2026'),
(14, 14, 14, 'Semester 3', '2025/2026'),
(15, 15, 15, 'Semester 3', '2025/2026'),
(16, 16, 16, 'Semester 3', '2025/2026'),
(17, 17, 17, 'Semester 3', '2025/2026'),
(18, 18, 18, 'Semester 3', '2025/2026'),
(19, 19, 19, 'Semester 4', '2025/2026'),
(20, 20, 20, 'Semester 4', '2025/2026'),
(21, 21, 21, 'Semester 4', '2025/2026'),
(22, 22, 22, 'Semester 4', '2025/2026'),
(23, 23, 23, 'Semester 4', '2025/2026'),
(24, 24, 24, 'Semester 5', '2025/2026'),
(25, 25, 25, 'Semester 5', '2025/2026'),
(26, 26, 26, 'Semester 5', '2025/2026'),
(27, 27, 27, 'Semester 5', '2025/2026'),
(28, 28, 28, 'Semester 6', '2025/2026'),
(29, 29, 29, 'Semester 6', '2025/2026'),
(30, 30, 30, 'Semester 6', '2025/2026'),
(31, 31, 31, 'Semester 6', '2025/2026'),
(32, 32, 32, 'Semester 6', '2025/2026'),
(33, 33, 33, 'Semester 7', '2025/2026'),
(34, 34, 34, 'Semester 7', '2025/2026'),
(35, 35, 35, 'Semester 7', '2025/2026'),
(36, 36, 36, 'Semester 7', '2025/2026'),
(37, 37, 37, 'Semester 8', '2025/2026'),
(38, 38, 38, 'Semester 8', '2025/2026'),
(39, 39, 39, 'Semester 8', '2025/2026'),
(40, 40, 40, 'Semester 8', '2025/2026'),
(41, 41, 41, 'Semester 8', '2025/2026'),
(42, 42, 42, 'Semester 8', '2025/2026'),
(43, 43, 43, 'Semester 8', '2025/2026'),
(44, 44, 44, 'Semester 8', '2025/2026'),
(45, 45, 45, 'Semester 8', '2025/2026'),
(46, 46, 46, 'Semester 8', '2025/2026'),
(47, 47, 47, 'Semester 8', '2025/2026'),
(48, 48, 48, 'Semester 8', '2025/2026'),
(49, 49, 49, 'Semester 8', '2025/2026'),
(50, 50, 50, 'Semester 8', '2025/2026');
-- Insert data enroll (50 enroll)
INSERT INTO Enroll (EnrollID, MahasiswaID, MataKuliahID, TahunAkademik, Nilai)
VALUES
(1, 1, 1, '2025/2026', 'A'),
(2, 2, 2, '2025/2026', 'B'),
(3, 3, 3, '2025/2026', 'A'),
(4, 4, 4, '2025/2026', 'B'),
(5, 5, 5, '2025/2026', 'C'),
(6, 6, 6, '2025/2026', 'A'),
(7, 7, 7, '2025/2026', 'B'),
(8, 8, 8, '2025/2026', 'A'),
(9, 9, 9, '2025/2026', 'B'),
(10, 10, 10, '2025/2026', 'C'),
(11, 11, 11, '2025/2026', 'A'),
(12, 12, 12, '2025/2026', 'B'),
(13, 13, 13, '2025/2026', 'A'),
(14, 14, 14, '2025/2026', 'B'),
(15, 15, 15, '2025/2026', 'C'),
(16, 16, 16, '2025/2026', 'A'),
(17, 17, 17, '2025/2026', 'B'),
(18, 18, 18, '2025/2026', 'A'),
(19, 19, 19, '2025/2026', 'B'),
(20, 20, 20, '2025/2026', 'C'),
(21, 21, 21, '2025/2026', 'A'),
(22, 22, 22, '2025/2026', 'B'),
(23, 23, 23, '2025/2026', 'A'),
(24, 24, 24, '2025/2026', 'B'),
(25, 25, 25, '2025/2026', 'C'),
(26, 26, 26, '2025/2026', 'A'),
(27, 27, 27, '2025/2026', 'B'),
(28, 28, 28, '2025/2026', 'A'),
(29, 29, 29, '2025/2026', 'B'),
(30, 30, 30, '2025/2026', 'C'),
(31, 31, 31, '2025/2026', 'A'),
(32, 32, 32, '2025/2026', 'B'),
(33, 33, 33, '2025/2026', 'A'),
(34, 34, 34, '2025/2026', 'B'),
(35, 35, 35, '2025/2026', 'C'),
(36, 36, 36, '2025/2026', 'A'),
(37, 37, 37, '2025/2026', 'B'),
(38, 38, 38, '2025/2026', 'A'),
(39, 39, 39, '2025/2026', 'B'),
(40, 40, 40, '2025/2026', 'C'),
(41, 41, 41, '2025/2026', 'A'),
(42, 42, 42, '2025/2026', 'B'),
(43, 43, 43, '2025/2026', 'A'),
(44, 44, 44, '2025/2026', 'B'),
(45, 45, 45, '2025/2026', 'C'),
(46, 46, 46, '2025/2026', 'A'),
(47, 47, 47, '2025/2026', 'B'),
(48, 48, 48, '2025/2026', 'A'),
(49, 49, 49, '2025/2026', 'B'),
(50, 50, 50, '2025/2026', 'C');