Tugas SBD1

# MySQL-Front Dump 2.2
#
# Host: localhost Database: jadwal_praktikum
#--------------------------------------------------------
# Server version 4.0.12-nt

#
# Table structure for table 'assisten'
#
CREATE TABLE `assisten` (
`NIM` varchar(10) NOT NULL default '',
`Nama` varchar(20) NOT NULL default '',
`Jenis_Kelamin` enum('P','L') NOT NULL default 'P',
`Fakultas` varchar(20) NOT NULL default ''
) TYPE=MyISAM;


#
# Dumping data for table 'assisten'
#
INSERT INTO assisten VALUES("030106002","Didi","L","Teknik");
INSERT INTO assisten VALUES("030106005","Anteng","L","Teknik");
INSERT INTO assisten VALUES("030106007","Purwoko","L","Matematika");
INSERT INTO assisten VALUES("030106032","Ozi","L","Matematika");

#
# Table structure for table 'dosen'
#
CREATE TABLE `dosen` (
`NIP` varchar(10) NOT NULL default '',
`Nama` varchar(20) NOT NULL default '',
`Jenis_Kelamin` enum('P','L') NOT NULL default 'P'
) TYPE=MyISAM;


#
# Dumping data for table 'dosen'
#
INSERT INTO dosen VALUES("005003004","Tito","L");
INSERT INTO dosen VALUES("003003005","Erni","P");
INSERT INTO dosen VALUES("003003006","Eka","P");
INSERT INTO dosen VALUES("004003007","Mufida","P");

#
# Table structure for table 'mahasiswa'
#
CREATE TABLE `mahasiswa` (
`Nim` varchar(10) NOT NULL default '',
`Nama` varchar(20) NOT NULL default '',
`Jenis_kelamin` enum('P','L') NOT NULL default 'P',
`Prodi` varchar(20) NOT NULL default ''
) TYPE=MyISAM;


#
# Dumping data for table 'mahasiswa'
#
INSERT INTO mahasiswa VALUES("0501060043","Santi","P","Matematika");
INSERT INTO mahasiswa VALUES("0501060056","Rahmi","P","Matematika");
INSERT INTO mahasiswa VALUES("0501060054","Wida","P","Matematika");
INSERT INTO mahasiswa VALUES("0501060055","Linda","P","Matematika");

#
# Table structure for table 'mata_kuliah'
#
CREATE TABLE `mata_kuliah` (
`KODE` varchar(10) NOT NULL default '',
`Mata_Kuliah` varchar(20) NOT NULL default '',
`SKS` enum('B','U') NOT NULL default 'B',
`Bobot_SKS` int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;


#
# Dumping data for table 'mata_kuliah'
#
INSERT INTO mata_kuliah VALUES("010243","SBD","B","3");
INSERT INTO mata_kuliah VALUES("010242","Matlab","B","3");
INSERT INTO mata_kuliah VALUES("010241","Pemrograman T","B","3");
INSERT INTO mata_kuliah VALUES("010240","Pemrograman D","B","3");
INSERT INTO mata_kuliah VALUES("010239","","B","0");

#
# Table structure for table 'waktu_pelaksanaan'
#
CREATE TABLE `waktu_pelaksanaan` (
`Jam` time NOT NULL default '00:00:00',
`Hari` varchar(10) NOT NULL default ''
) TYPE=MyISAM;


#
# Dumping data for table 'waktu_pelaksanaan'
#
INSERT INTO waktu_pelaksanaan VALUES("07:00:00","Senin");
INSERT INTO waktu_pelaksanaan VALUES("16:00:00","selasa");
INSERT INTO waktu_pelaksanaan VALUES("15:00:00","Rabu");
INSERT INTO waktu_pelaksanaan VALUES("17:00:00","Kamis");
INSERT INTO waktu_pelaksanaan VALUES("16:00:00","Jumat");
INSERT INTO waktu_pelaksanaan VALUES("16:00:00","Kamis");
INSERT INTO waktu_pelaksanaan VALUES("09:00:00","Minggu");