# 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(20) 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’
#
DOSEN values(”028765648″,”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,
`Program_studi` varchar(30) default NULL
) TYPE=MyISAM;
#
# Dumping data for table ‘MAHASISWA’
#
insert into MAHASISWA values(”0501060056″,”rahmiyati”,”P”,”P.Matematika”);
insert into MAHASISWA values(”0501060105″,”agung”,”L”,”P.Matematika”);
insert into MAHASISWA values(”0501060063″,”lubis”,”L”,”P.matematika”);
insert into MAHASISWA values(”0401060065″,”tri widiantoro”,”p.”,”PGSD”);
#
# 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’
#INSERT INTO mahasiswa VALUES(”0501060057″,”ambar”,”P”,”P.Matematika”);
INSERT INTO mahasiswa VALUES(”0501060105″,”pawit”,”L”,”P.Matematika”);
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 (”16.30″,”Jum\’at”);
