# 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(50) 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(”02000009″,”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(”0501060099″,”ika margiyani”,”P”,”P.Matematika”);
INSERT INTO mahasiswa VALUES(”0501060080″,”siti nasiroh”,”P”,”P.Matematika”);
INSERT INTO mahasiswa VALUES(”0401060090″,indra”,”L”,”P.Bhs.Inggris”);
INSERT INTO mahasiswa VALUES(”0401060078″,”Andi”,”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(”16.30″,”senin”);
INSERT INTO waktu VALUES(”16.30″,”selasa”);
INSERT INTO waktu VALUES(”16.30″,”jum’at”);
