Contoh Buat Database Sistem informasi Akademi Menggunakan SQL

USE [master]
GO
/****** Object:  Database [db_uts]    Script Date: 04/24/2013 00:44:15 ******/
IF  EXISTS (SELECT name FROM sys.databases WHERE name = N'db_uts')

DROP DATABASE [db_uts]
/****** Object:  Database [db_uts]    Script Date: 04/24/2013 00:44:51 ******/
CREATE DATABASE [db_uts] ON  PRIMARY
( NAME = 'db_uts', FILENAME = 'D:\UTS\db_uts.mdf' , SIZE = 2240KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON
( NAME = 'db_uts_log', FILENAME = 'D:\UTS\db_uts_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 COLLATE Latin1_General_CI_AS
GO


USE [db_uts]
GO

CREATE TABLE [tbl_program_studi](
[id] [tinyint] NOT NULL,
[nama] [varchar] (50) NOT NULL,
[fak_id] [tinyint] NOT NULL,
CONSTRAINT [PK_tbl_program_studi] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO

CREATE TABLE [tbl_fakultas](
[id] [tinyint] NOT NULL,
[nama] [varchar](50) NOT NULL,
CONSTRAINT [PK_tbl_fakultas] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO

CREATE TABLE [tbl_matkul](
[id] [tinyint] NOT NULL,
[kode] [varchar](10) NOT NULL,
[nama] [varchar](50) NOT NULL,
[SKS] [tinyint] NOT NULL,
CONSTRAINT [PK_tbl_mata_kuliah] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO


CREATE TABLE [tbl_jadwal](
[id] [tinyint] NOT NULL,
[prog_id] [tinyint] NOT NULL,
[kelas] [varchar](5) NOT NULL,
[tahun] [smallint] NOT NULL,
[tahapan] [tinyint] NOT NULL,
[semester] [tinyint] NOT NULL,
CONSTRAINT [PK_tbl_jadwal] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO

CREATE TABLE [tbl_jadwal_detail](
[id] [tinyint] NOT NULL,
[jadwal_id] [tinyint] NOT NULL,
[nomor] [tinyint] NOT NULL,
[matkul_id] [tinyint] NOT NULL,
[dosen_id] [tinyint] NOT NULL,
[ruangan_id] [tinyint] NOT NULL,
[menit_mulai] [tinyint] NOT NULL,
[jam_mulai] [tinyint] NOT NULL,
[menit_selesai] [tinyint] NOT NULL,
[jam_selesai] [tinyint] NOT NULL,
[hari] [tinyint] NOT NULL,
CONSTRAINT [PK_tbl_jadwal_detail] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO

CREATE TABLE [tbl_dosen](
[id] [tinyint] NOT NULL,
[nama] [varchar](100) NOT NULL,
[alamat] [varchar](100) NOT NULL,
[handphone] [varchar](10) NOT NULL,
CONSTRAINT [PK_tbl_dosen] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO

CREATE TABLE [tbl_ruangan](
[id] [tinyint] NOT NULL,
[nama] [varchar](100) NOT NULL,
[kapasitas] [smallint] NOT NULL,
CONSTRAINT [PK_tbl_ruangan] PRIMARY KEY CLUSTERED
([id] ASC)
)
GO

--Relationship

BEGIN TRANSACTION
GO
ALTER TABLE dbo.tbl_program_studi ADD CONSTRAINT
FK_tbl_program_studi_tbl_fakultas FOREIGN KEY
(
fak_id
) REFERENCES dbo.tbl_fakultas
(
id
) ON UPDATE  NO ACTION
ON DELETE  NO ACTION

GO
COMMIT
BEGIN TRANSACTION
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.tbl_jadwal ADD CONSTRAINT
FK_tbl_jadwal_tbl_program_studi FOREIGN KEY
(
prog_id
) REFERENCES dbo.tbl_program_studi
(
id
) ON UPDATE  NO ACTION
ON DELETE  NO ACTION

GO
COMMIT
BEGIN TRANSACTION
GO
COMMIT
BEGIN TRANSACTION
GO
ALTER TABLE dbo.tbl_jadwal_detail ADD CONSTRAINT
FK_tbl_jadwal_detail_tbl_matkul FOREIGN KEY
(
matkul_id
) REFERENCES dbo.tbl_matkul
(
id
) ON UPDATE  NO ACTION
ON DELETE  NO ACTION

GO
ALTER TABLE dbo.tbl_jadwal_detail ADD CONSTRAINT
FK_tbl_jadwal_detail_tbl_dosen FOREIGN KEY
(
dosen_id
) REFERENCES dbo.tbl_dosen
(
id
) ON UPDATE  NO ACTION
ON DELETE  NO ACTION

GO
ALTER TABLE dbo.tbl_jadwal_detail ADD CONSTRAINT
FK_tbl_jadwal_detail_tbl_ruangan FOREIGN KEY
(
ruangan_id
) REFERENCES dbo.tbl_ruangan
(
id
) ON UPDATE  NO ACTION
ON DELETE  NO ACTION

GO
ALTER TABLE dbo.tbl_jadwal_detail ADD CONSTRAINT
FK_tbl_jadwal_detail_tbl_jadwal FOREIGN KEY
(
jadwal_id
) REFERENCES dbo.tbl_jadwal
(
id
) ON UPDATE  NO ACTION
ON DELETE  NO ACTION

GO
COMMIT


--Insert Data
INSERT INTO tbl_fakultas VALUES(1, 'Komputer')
INSERT INTO tbl_fakultas VALUES(2, 'Ekonomi')
INSERT INTO tbl_fakultas VALUES(3, 'Kesehatan Masyarakat')
INSERT INTO tbl_fakultas VALUES(4, 'Psikologi')
INSERT INTO tbl_fakultas VALUES(5, 'Hukum')
INSERT INTO tbl_fakultas VALUES(6, 'Keguruan & Ilmu Pendidikan')
INSERT INTO tbl_fakultas VALUES(7, 'Agro Teknologi')

INSERT INTO tbl_program_studi VALUES(1, 'Teknik Informatika', 1)
INSERT INTO tbl_program_studi VALUES(2, 'Sistem Informasi', 1)
INSERT INTO tbl_program_studi VALUES(3, 'Akuntansi', 2)
INSERT INTO tbl_program_studi VALUES(4, 'Manajemen', 2)
INSERT INTO tbl_program_studi VALUES(5, 'Kesehatan Masyarakat',3)
INSERT INTO tbl_program_studi VALUES(6, 'Psikologi',4)
INSERT INTO tbl_program_studi VALUES(7, 'Hukum',5)
INSERT INTO tbl_program_studi VALUES(8, 'Pendidikan Bahasa dan Sastra Indonesia',6)
INSERT INTO tbl_program_studi VALUES(9, 'Pendidikan Bahasa dan Sastra Inggris',6)
INSERT INTO tbl_program_studi VALUES(10, 'Agro Teknologi',7)
INSERT INTO tbl_program_studi VALUES(11, 'Agrobisnis',7)

INSERT INTO tbl_dosen VALUES (1,'Prof. Dr. Kiagus Muhammad Sobri, M.Si.','Jl Pahlawan Lingk I Lingk I 94','0832465466')
INSERT INTO tbl_dosen VALUES (2,'Drs. H. Joko Siswanto, M.Si.','Jl Sutomo 135','0832465467')
INSERT INTO tbl_dosen VALUES (3,'Drs. H. Joko Siswanto, M.Si.','Jl Dr Sutomo 191','0832465468')
INSERT INTO tbl_dosen VALUES (4,'Dr. Ardiyan Saptawan, M.Si.','Jl Jend Gatot Subroto 180-E','0832465469')
INSERT INTO tbl_dosen VALUES (5,'Dra. Hj. Nurmah, M.Si.','Jl Sisingamangaraja 231 B','0832465470')
INSERT INTO tbl_dosen VALUES (6,'Dra. Nengyanti, M.Hum.','Jl Sisingamangaraja 84','0832465471')
INSERT INTO tbl_dosen VALUES (7,'Drs. Eko Budi Widjayanto, M.Si.','Jl Sisingamangaraja 27/39','0832465472')
INSERT INTO tbl_dosen VALUES (8,'Dr. Raniasa Putra, S.IP., M.Si.','Jl Sisingamangaraja 11','0832465473')
INSERT INTO tbl_dosen VALUES (9,'Dwi Gusti Ade Anggraini, SE','Jl MH Thamrin Baru 28','0832465474')
INSERT INTO tbl_dosen VALUES (10,'Prof. Agus Suroso, Dr. MS.','Jl MH Thamrin 71-D','0832465475')
INSERT INTO tbl_dosen VALUES (11,'Prof. Dr. Kamio, SE','Jl Sutrisno 43','0832465476')
INSERT INTO tbl_dosen VALUES (12,'Prof. Dr. H. Slamet Widodo, MS., MM','Jl Brigjen Katamso 25-B','0832465477')
INSERT INTO tbl_dosen VALUES (13,'Achmad Solichin, S.Kom, M.T.I','Jl Gajah 40','0832465478')
INSERT INTO tbl_dosen VALUES (14,'Dewi Kusumaningsih, M.Kom','Jl Amir Hamzah 150-A','0832465479')
INSERT INTO tbl_dosen VALUES (15,'Haris Munandar, ST, M.T.I','Jl Cut Meutia 1','0832465480')
INSERT INTO tbl_dosen VALUES (16,'Haris Munandar, ST, M.T.I','Jl Cirebon 76-A','0832465481')
INSERT INTO tbl_dosen VALUES (17,'M. Anif, M.Kom','Jl Kom L Yos Sudarso 191-A','0832465482')
INSERT INTO tbl_dosen VALUES (18,'Mufti, M.Kom','Jl Pemuda 26-G','0832465483')
INSERT INTO tbl_dosen VALUES (19,'Muhammad Ainur Rony, S.Kom, M.T.I','Jl Medan Binjai Km 13 11','0832465484')
INSERT INTO tbl_dosen VALUES (20,'Nofiyani, S.Kom','Jl Madong Lubis 131-B','0832465485')
INSERT INTO tbl_dosen VALUES (21,'Nurul Jamal, M.Kom','Jl Kelambir V 1','0832465486')
INSERT INTO tbl_dosen VALUES (22,'Painem, M.Kom','Jl Medan-Belawan Lingk VII Km 16','0832465487')
INSERT INTO tbl_dosen VALUES (23,'Purwanto, S.Si, M.Kom','Jl Mayjen Sutoyo Siswomiharjo 81 A','0832465488')
INSERT INTO tbl_dosen VALUES (24,'Safitri Juanita, S.Kom, M.T.I','Jl Pusat Pasar 914','0832465489')
INSERT INTO tbl_dosen VALUES (25,'Safrina Amini, S.Kom, M.T.I','Jl Bakaran Batu I Bl F/15','0832465490')
INSERT INTO tbl_dosen VALUES (26,'Sejati Waluyo, M.Kom','Jl Bromo 7-A','0832465491')
INSERT INTO tbl_dosen VALUES (27,'Wahyu Pramusinto, M.Kom','Jl Japaris 80','0832465492')
INSERT INTO tbl_dosen VALUES (28,'Windarto, M.Kom','Jl Japaris 156','0832465493')
INSERT INTO tbl_dosen VALUES (29,'Yayuk Anggraeni, S.Kom','Jl Dr Sun Yat Sen 32-F','0832465494')
INSERT INTO tbl_dosen VALUES (30,'Agus Umar Hamdani, M.Kom','Jl Pajak Sukaramai 224/225','0832465495')
INSERT INTO tbl_dosen VALUES (31,'Anita Diana, M.Kom','Jl Helvetia By Pass 775-A','0832465496')
INSERT INTO tbl_dosen VALUES (32,'Atik Ariesta, M.Kom','Jl Tlaju-Simpang Tilak 15-A','0832465497')
INSERT INTO tbl_dosen VALUES (33,'Dian Anubhakti, M.Kom','Jl Seram 75','0832465498')
INSERT INTO tbl_dosen VALUES (34,'F.X Bima Cahya Putra, M.Kom','Jl Kemiri 68','0832465499')
INSERT INTO tbl_dosen VALUES (35,'Ferdiansyah, S.Kom, M.T.I.','Jl Kapt Jumhana 636','0832465500')
INSERT INTO tbl_dosen VALUES (36,'Grace Gata, M.Kom','Jl Kapt Jumhana 136-C','0832465501')
INSERT INTO tbl_dosen VALUES (37,'Humisar Hasugian, M.Kom','Jl Laksana 8 C','0832465502')
INSERT INTO tbl_dosen VALUES (38,'Joko Sutrisno, M.Kom','Jl Laksana 28','0832465503')
INSERT INTO tbl_dosen VALUES (39,'Lauw Li Hin, M.Kom','Jl Cahaya 33','0832465504')
INSERT INTO tbl_dosen VALUES (40,'Lis Suryadi, M.Kom','Jl Kalianda 73','0832465505')
INSERT INTO tbl_dosen VALUES (41,'Lusi Fajarita, S.Kom','Jl Lampung 10','0832465506')
INSERT INTO tbl_dosen VALUES (42,'Rizky Tahara Shita, M.Kom','Jl Lampung 22','0832465507')
INSERT INTO tbl_dosen VALUES (43,'Samsinar, M.Kom','Jl Gandhi 75/155','0832465508')
INSERT INTO tbl_dosen VALUES (44,'Tri Ika Jaya Kusumawati, S.Kom','Jl Asia 86/44','0832465509')
INSERT INTO tbl_dosen VALUES (45,'Yohannes Yahya, Ir, MM','Jl Amaliun 133','0832465510')
INSERT INTO tbl_dosen VALUES (46,'Dwi Achadiani, M.Kom','Jl Sabaruddin 4-E','0832465511')
INSERT INTO tbl_dosen VALUES (47,'Gatot Purwanto, Ir','Jl Amaliun 8','0832465512')
INSERT INTO tbl_dosen VALUES (48,'TW. Wisjhnuadji, Ir, M.Kom','Jl Dr Wahidin 2 B','0832465513')
INSERT INTO tbl_dosen VALUES (49,'Muhammad Nur Budiyanto, S.Sos., MPA.','Jl Dr Wahidin 296','0832465514')
INSERT INTO tbl_dosen VALUES (50,'Dr. Raniasa Putra, S.IP., M.Si.','Jl Puri 136','0832465515')
INSERT INTO tbl_dosen VALUES (51,'Dr. Andries Lionardo, S.IP., M.Si.ÿ','Jl Ir H Juanda Baru 2 B','0832465516')
INSERT INTO tbl_dosen VALUES (52,'Ermanovida, S.Sos., M.Si','Jl Logam 8-A','0832465517')
INSERT INTO tbl_dosen VALUES (53,'Hoirunisyak, S.Pd. M.Pd','Jl Dr Wahidin Sudirohusodo 67-B','0832465518')
INSERT INTO tbl_dosen VALUES (54,'Dr. Muhammad Husni Thamrin, M.Si.','Jl Puri 57','0832465519')
INSERT INTO tbl_dosen VALUES (55,'Dra. Katriza Imania, M.Si.','Jl Sambas 114','0832465520')
INSERT INTO tbl_dosen VALUES (56,'Junaidi, S.IP., M.Si.','Jl Ismailiyah 37','0832465521')
INSERT INTO tbl_dosen VALUES (57,'Sylvie Agustina, S.IP.','Jl Ismailiyah 9','0832465522')
INSERT INTO tbl_dosen VALUES (58,'Drs. Adlyn Komaruddin','Jl Ansari 2','0832465523')
INSERT INTO tbl_dosen VALUES (59,'Drs. Alimin Kusuma Ratu','Jl Mahkamah 19-E','0832465524')
INSERT INTO tbl_dosen VALUES (60,'Dra. Hj. Hartati Ali M.M.','Jl AR Hakim 181 B','0832465525')
INSERT INTO tbl_dosen VALUES (61,'Drs. Machmud Syahidin','Jl Rachmadsyah 186','0832465526')
INSERT INTO tbl_dosen VALUES (62,'Dra. Hj. Chaerani Effendi','Jl Samudera 1 A','0832465527')
INSERT INTO tbl_dosen VALUES (63,'Drs. Yusuf Haryono M.M.Ak.','Jl Arif Rahman Hakim 39','0832465528')
INSERT INTO tbl_dosen VALUES (64,'Prof. Dr. Hj. Nurlina Tarmizi, M.Si.','Jl Besi 1','0832465529')
INSERT INTO tbl_dosen VALUES (65,'Dra. Hj. Naisyah Siregar','Jl Lamlo 29/33','0832465530')
INSERT INTO tbl_dosen VALUES (66,'Drs. Abubakar Siddik M.Si. Ak.','Jl Duyung 84-D/114','0832465531')
INSERT INTO tbl_dosen VALUES (67,'Drs. Abdul Gani Harun S.U.','Jl Asia 548-B','0832465532')
INSERT INTO tbl_dosen VALUES (68,'Drs. Tatang Abdul Madjid S, M.Si, Ph.D','Jl Asia 133','0832465533')
INSERT INTO tbl_dosen VALUES (69,'Prof. Dr. H. Syamsurijal AK, M.Sc.','Jl Rachmadsyah 4-D','0832465534')
INSERT INTO tbl_dosen VALUES (70,'Prof. Dr. Hj. Badia Perizade M.B.A.','Jl Gandhi 20','0832465535')
INSERT INTO tbl_dosen VALUES (71,'Drs. M. Sirod Saleh M.Si.','Jl Gandhi 88','0832465536')
INSERT INTO tbl_dosen VALUES (72,'Dra. Hj. Rusmiati','Jl Tilak 1-A','0832465537')
INSERT INTO tbl_dosen VALUES (73,'Drs. Achmad Widad M.Sc.','Jl Dr Wahidin 76-A/320','0832465538')
INSERT INTO tbl_dosen VALUES (74,'Drs. H. Syaipan Djambak M.Si.','Jl Brigjen Katamso 157','0832465539')
INSERT INTO tbl_dosen VALUES (75,'Dr.Hj. Rosmiyati Chodijah S, M.Si.','Jl Asia 81','0832465540')
INSERT INTO tbl_dosen VALUES (76,'Drs. Yuliansyah M. Diah M.M.','Jl Palangkaraya 15','0832465541')
INSERT INTO tbl_dosen VALUES (77,'Drs. H. Akhmad Nazaruddin M.M.','Jl Tritura 16','0832465542')
INSERT INTO tbl_dosen VALUES (78,'Dra. Hj. Kencana Dewi M.Sc.','Jl Hasanudin 159','0832465543')
INSERT INTO tbl_dosen VALUES (79,'Prof. Dr. Hj. Sulastri M.Kom. M.E.','Jl Karya 90','0832465544')
INSERT INTO tbl_dosen VALUES (80,'Drs. Harunnurrasyid M.Com.','Jl Merak 128','0832465545')
INSERT INTO tbl_dosen VALUES (81,'Dian Eka S.E. M.M.','Jl Kijang 151','0832465546')
INSERT INTO tbl_dosen VALUES (82,'Muhammad Teguh S.E. M.Si.','Jl Kancil 78','0832465547')
INSERT INTO tbl_dosen VALUES (83,'Drs. Isnurhadi M.B.A. Ph.D.','Jl Guntur 90','0832465548')
INSERT INTO tbl_dosen VALUES (84,'Prof. Dr. Diah Natalisa M.B.A.','Jl Badai 17','0832465549')
INSERT INTO tbl_dosen VALUES (85,'Dra. Hj. Saadah Yuliana M.Si.','Jl Mongosidi 15','0832465550')
INSERT INTO tbl_dosen VALUES (86,'Aspahani S.E. Ak. M.M.','Jl Sudirohusodo 86','0832465551')
INSERT INTO tbl_dosen VALUES (87,'Drs. Suhel M.Si.','Jl Cipto 78','0832465552')
INSERT INTO tbl_dosen VALUES (88,'Mukhtaruddin S.E. Ak. M.Si.','Jl Moh Yamin 69','0832465553')
INSERT INTO tbl_dosen VALUES (89,'Dr. Azwardi S.E. M.Si.','Jl Pattimura 78','0832465554')
INSERT INTO tbl_dosen VALUES (90,'Prof. Dr. Taufiq S.E. M.Si.','Jl Pecatu 15','0832465555')
INSERT INTO tbl_dosen VALUES (91,'Hj. Nofiawaty S.E. M.M.','Jl Biawak 13','0832465556')
INSERT INTO tbl_dosen VALUES (92,'Yunisvita S.E. M.Si.','Jl Merak Jingga 89','0832465557')
INSERT INTO tbl_dosen VALUES (93,'Anna Yulianita S.E. M.Si.','Jl Badak 11','0832465558')
INSERT INTO tbl_dosen VALUES (94,'Emylia Yuniarti S.E. Ak. M.Si.Ak.','Jl Surabaya 65','0832465559')
INSERT INTO tbl_dosen VALUES (95,'Aslamia Rosa S.E. M.Si.','Jl Bandung 84','0832465560')
INSERT INTO tbl_dosen VALUES (96,'Rela Sari S.E. M.Si.','Jl Papua 17','0832465561')
INSERT INTO tbl_dosen VALUES (97,'Mukhlis, S.E., M.Si.','Jl Kemerdekaan 90','0832465562')
INSERT INTO tbl_dosen VALUES (98,'Luk Luk Fuadah S.E. Ak. MBA.','Jl Kalimantan 11','0832465563')
INSERT INTO tbl_dosen VALUES (99,'Aryanto, SE, MTI, Ak.','Jl Gereja 18','0832465564')
INSERT INTO tbl_dosen VALUES (100,'Isni Andriana S.E. M.Fin.','Jl Sutrisno 17','0832465565')

INSERT INTO tbl_jadwal VALUES (1,1,'S41',2012,2,4)
INSERT INTO tbl_jadwal VALUES (2,1,'S42',2012,2,4)
INSERT INTO tbl_jadwal VALUES (3,2,'S31',2012,2,4)
INSERT INTO tbl_jadwal VALUES (4,2,'S32',2012,2,4)
INSERT INTO tbl_jadwal VALUES (5,3,'S53',2012,2,4)
INSERT INTO tbl_jadwal VALUES (6,3,'S54',2012,2,4)
INSERT INTO tbl_jadwal VALUES (7,4,'S23',2012,2,4)
INSERT INTO tbl_jadwal VALUES (8,4,'S24',2012,2,4)
INSERT INTO tbl_jadwal VALUES (9,1,'S43',2012,2,4)
INSERT INTO tbl_jadwal VALUES (10,1,'S44',2012,2,4)

INSERT INTO tbl_matkul VALUES (1,'C-TI142','Algoritma dan Pemrograman II',2)
INSERT INTO tbl_matkul VALUES (2,'A-TI052','Bahasa Inggris II',2)
INSERT INTO tbl_matkul VALUES (3,'B-TI082','Struktur Data',3)
INSERT INTO tbl_matkul VALUES (4,'A-TI032','Bahasa Indonesia',2)
INSERT INTO tbl_matkul VALUES (5,'B-TI012','Kalkulus',3)
INSERT INTO tbl_matkul VALUES (6,'CTI152','Praktek Algoritma dan Pemrograman II',1)
INSERT INTO tbl_matkul VALUES (7,'C-TI022','Aplikasi Komputer II',2)
INSERT INTO tbl_matkul VALUES (8,'C-TI202','Pemrograman Visual I',2)
INSERT INTO tbl_matkul VALUES (9,'C-TI212','Praktek Pemrograman Visual I',1)
INSERT INTO tbl_matkul VALUES (10,'B-TI022','Matematika Diskrit',3)
INSERT INTO tbl_matkul VALUES (11,'C-TI173','Praktek Algoritma dan Pemrograman III',1)
INSERT INTO tbl_matkul VALUES (12,'C-TI163','Algoritma dan Pemrograman III',2)
INSERT INTO tbl_matkul VALUES (13,'C-TI063','Sistem Operasi',3)
INSERT INTO tbl_matkul VALUES (14,'C-TI223','Pemrograman Visual II',2)
INSERT INTO tbl_matkul VALUES (15,'C-TI053','Arsitektur dan Organisasi Komputer',3)
INSERT INTO tbl_matkul VALUES (16,'B-TI033','Aljabar Linier',3)
INSERT INTO tbl_matkul VALUES (17,'C-TI233','Praktek Pemrograman Visual II',1)
INSERT INTO tbl_matkul VALUES (18,'C-TI033','Elektronika Digital',3)
INSERT INTO tbl_matkul VALUES (19,'C-TI343','Sistem Basis Data I',2)
INSERT INTO tbl_matkul VALUES (20,'C-TI353','Praktek Sistem Basis Data I',1)
INSERT INTO tbl_matkul VALUES (21,'C-TI074','Sistem Berkas',3)
INSERT INTO tbl_matkul VALUES (22,'D-TI024','Analisis dan Perancangan Sistem Informasi',3)
INSERT INTO tbl_matkul VALUES (23,'C-TI304','Pemrograman Berorentasi Objek',2)
INSERT INTO tbl_matkul VALUES (24,'C-TI314','Praktek Pemrograman Berorentasi Objek',1)
INSERT INTO tbl_matkul VALUES (25,'C-TI364','Manajemen Sistem Basis Data II',2)
INSERT INTO tbl_matkul VALUES (26,'C-TI374','Praktek Manajemen Sistem Basis Data II',1)
INSERT INTO tbl_matkul VALUES (27,'B-TI044','Metode Numerik',3)
INSERT INTO tbl_matkul VALUES (28,'C-TI044','Mikroprocessor',3)
INSERT INTO tbl_matkul VALUES (29,'C-TI084','Jaringan Komputer',2)
INSERT INTO tbl_matkul VALUES (30,'C-TI094','Praktek Jaringan Komputer',1)
INSERT INTO tbl_matkul VALUES (31,'C-AK142','Pengantar Akuntansi I',2)
INSERT INTO tbl_matkul VALUES (32,'C-MA132','Matematika Ekonomi',3)
INSERT INTO tbl_matkul VALUES (33,'C-AK152','Ekonomi Mikro',2)
INSERT INTO tbl_matkul VALUES (34,'C-AK122','Pengantar Bisnis',2)
INSERT INTO tbl_matkul VALUES (35,'C-AK112','PengantarAkuntansi II',2)
INSERT INTO tbl_matkul VALUES (36,'C-MA442','Manajemen',2)
INSERT INTO tbl_matkul VALUES (37,'C-MA007','Aspek Hukum Dalam Bisnis',3)
INSERT INTO tbl_matkul VALUES (38,'C-AK052','Akuntansi Menengah I',3)
INSERT INTO tbl_matkul VALUES (39,'C-AK062','Akuntansi Biaya',1)
INSERT INTO tbl_matkul VALUES (40,'C-MA012','Manajemen Keuangan I',2)
INSERT INTO tbl_matkul VALUES (41,'C-MA001','Manajemen Pemasaran',2)
INSERT INTO tbl_matkul VALUES (42,'C-EK002','Ilmu Alamiah Dasar',3)
INSERT INTO tbl_matkul VALUES (43,'C-AK008','Statistik II',3)
INSERT INTO tbl_matkul VALUES (44,'C-ME112','Perpajakan',2)
INSERT INTO tbl_matkul VALUES (45,'C-AK098','Manajemen Perbankan',2)
INSERT INTO tbl_matkul VALUES (46,'C-AK242','Akuntansi Menengah II',3)
INSERT INTO tbl_matkul VALUES (47,'C-AK003','Praktek Akuntansi Dagang dan Jasa',1)
INSERT INTO tbl_matkul VALUES (48,'C-AK005','Akuntansi Perbankan',2)
INSERT INTO tbl_matkul VALUES (49,'C-MA010','Sistem Pengendalian Manajemen',2)
INSERT INTO tbl_matkul VALUES (50,'C-ME045','Studi Kelayakan Bisnis',1)

INSERT INTO tbl_ruangan VALUES (1,'S21',50)
INSERT INTO tbl_ruangan VALUES (2,'S22',60)
INSERT INTO tbl_ruangan VALUES (3,'S23',80)
INSERT INTO tbl_ruangan VALUES (4,'S24',100)
INSERT INTO tbl_ruangan VALUES (5,'S25',40)
INSERT INTO tbl_ruangan VALUES (6,'S26',50)
INSERT INTO tbl_ruangan VALUES (7,'S31',60)
INSERT INTO tbl_ruangan VALUES (8,'S32',90)
INSERT INTO tbl_ruangan VALUES (9,'S33',70)
INSERT INTO tbl_ruangan VALUES (10,'S34',40)
INSERT INTO tbl_ruangan VALUES (11,'S35',50)
INSERT INTO tbl_ruangan VALUES (12,'S36',60)
INSERT INTO tbl_ruangan VALUES (13,'S41',90)
INSERT INTO tbl_ruangan VALUES (14,'S42',100)
INSERT INTO tbl_ruangan VALUES (15,'S43',600)
INSERT INTO tbl_ruangan VALUES (16,'S44',70)
INSERT INTO tbl_ruangan VALUES (17,'S45',40)
INSERT INTO tbl_ruangan VALUES (18,'S46',80)
INSERT INTO tbl_ruangan VALUES (19,'S47',40)
INSERT INTO tbl_ruangan VALUES (20,'S48',50)

INSERT INTO tbl_jadwal_detail VALUES (1,1,1,1,1,1,30,8,45,9,1)
INSERT INTO tbl_jadwal_detail VALUES (2,2,2,2,2,2,30,8,45,9,1)
INSERT INTO tbl_jadwal_detail VALUES (3,3,3,3,3,3,30,8,45,9,1)
INSERT INTO tbl_jadwal_detail VALUES (4,4,4,4,4,4,30,8,45,9,1)
INSERT INTO tbl_jadwal_detail VALUES (5,5,5,5,5,5,30,8,45,9,1)
INSERT INTO tbl_jadwal_detail VALUES (6,6,6,6,6,6,30,8,45,9,1)