# MySQL-Front Dump 2.2
#
# Host: localhost Database: Jadwal_Praktikum
#——————————————————–
# Server version 4.0.12-nt
#
# Table structure for table ‘Asisten’
#
CREATE TABLE `Asisten` (
`Nim` varchar(10) default NULL,
`Nama` varchar(30) default NULL,
`Jenis_Kelamin` enum(’P’,’L’) default NULL,
`Fakultas` varchar(50) default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘Asisten’
#
INSERT INTO Asisten VALUES(”04000017009”,”Didi”,”L”,”Teknik elektro”);
INSERT INTO Asisten VALUES(“0406001908″,”Anteng”,”L”,”Teknik elektro”);
INSERT INTO Asisten VALUES(“0401060033″,”Andri”,”L”,”P.Matematika”);
#
# Table structure for table ‘Dosen’
#
CREATE TABLE `Dosen` (
`NIP` varchar(10) default NULL,
`Nama` varchar(30) default NULL,
`Jenis_Kelamin` enum(’P’,’L’) default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘Dosen’
#
INSERT INTO Dosen VALUES(”2000078900″,”Tito Panandito”,”L”);
INSERT INTO Dosen VALUES(“2030006001″,”Erni Widiastuti”,”P”);
#
# Table structure for table ‘Mahasiswa’
#
CREATE TABLE `Mahasiswa` (
`Nim` varchar(10) default NULL,
`Nama` varchar(30) default NULL,
`Jenis_Kelamin` enum(’P’,’L’) default NULL,
`Prodi` varchar(30) default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘Mahasiswa’
#
INSERT INTO Mahasiswa VALUES(”0501060056″,”Rahmiyati”,”P”,”P.Matematika”);
INSERT INTO Mahasiswa VALUES(”0501060087″,”Susipah”,”P”,”P.Matematika”);
INSERT INTO Mahasiswa VALUES(”0701060090″,Rendra”,”L”,”Teknik Informatika”);
INSERT INTO Mahasiswa VALUES(”0401060078″,”Anto”,”L”,”P.Bhs.Inggris”);
#
# Table structure for table ‘Mata_Kuliah’
#
CREATE TABLE `Mata_Kuliah` (
`Kode_MK` varchar(10) default NULL,
`Mata_Kuliah` varchar(30) default NULL,
`Keterangan` enum(’B’,’U’) default NULL,
`Bobot_SKS` int(30) unsigned default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘Mata_Kuliah’
#
INSERT INTO Mata_Kuliah VALUES(“0903″,”Pemrograman Terstruktur”,”B”,”3″);
INSERT INTO Mata_Kuliah VALUES(“0904″,”Sistem Basis Data”,”B”,”3″);
INSER INTO Mata_Kuliah VALUES(“0905″,”Aplikasi Komputer”,”B”,”2″);
#
# Table structure for table ‘Waktu’
#
CREATE TABLE `Waktu` (
`Jam` varchar(10) default NULL,
`Hari` varchar(30) default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘Waktu’
#
INSERT INTO Waktu VALUES(”16.30″,”Selasa”);
INSERT INTO Waktu VALUES(”16.30″,”Rabu”);
INSERT INTO Waktu VALUES(”16.30″,”Kamis”);
