# MySQL-Front Dump 2.2
#
# Host: localhost Database: jadual_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(30) default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘asisten’
#
#
# 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(“0301060001″,”Tito Pandito”,”L”);
#
# 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(“0501060054″,”Widaningsih”,”P”,”P.Matematika”);
INSERT INTO mahasiswa VALUES(“0501060055″,”Melinda Irmawati”,”P”,”P.Matematika”);
INSERT INTO mahasiswa VALUES(“0401060010″,”Wahyu”,”L”,”P.Bhs.Inggris”);
INSERT INTO mahasiswa VALUES(“0401060065″,”Indra”,”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’
#
#
# 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(“14.00″,”Rabu”);
INSERT INTO waktu VALUES(“16.30″,”Kamis”);
INSERT INTO waktu VALUES(“16.30″,”Jum\’at”);
