Tugas SBD "Penjadwalan Praktikum"

# MySQL-Front Dump 2.2
#
# Host: localhost Database: sistem_penjadwalan_praktikum
#--------------------------------------------------------
# Server version 4.1.11-nt

USE sistem_penjadwalan_praktikum;


#
# Table structure for table 'asisten'
#

CREATE TABLE `asisten` (
`NIK` varchar(10) NOT NULL default '0',
`Nama` varchar(30) NOT NULL default '',
`Alamat` varchar(30) NOT NULL default '',
`Jenis_Kelamin` enum('P','L') NOT NULL default 'P'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'asisten'
#
INSERT INTO asisten VALUES("005","Edi p","Tegal","L");
INSERT INTO asisten VALUES("002","awe","cibangkong","P");
INSERT INTO asisten VALUES("003","wahab","baturaden","P");
INSERT INTO asisten VALUES("004","ucil","vietnam","L");
INSERT INTO asisten VALUES("005","babe","singapur","L");


#
# Table structure for table 'dosen'
#

CREATE TABLE `dosen` (
`NIP` varchar(10) NOT NULL default '0',
`Nama` varchar(30) NOT NULL default '',
`Alamat` varchar(50) NOT NULL default '',
`Jenis_kelamin` enum('P','L') NOT NULL default 'P'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'dosen'
#
INSERT INTO dosen VALUES("001","TITO","vietnam","L");
INSERT INTO dosen VALUES("002","VIDA","eropa","P");
INSERT INTO dosen VALUES("003","Erni","singapur","P");
INSERT INTO dosen VALUES("004","Ela","ajibarang","P");
INSERT INTO dosen VALUES("005","Ana.Q","cibangkong","L");


#
# Table structure for table 'mahasiswa'
#

CREATE TABLE `mahasiswa` (
`NIM` varchar(10) NOT NULL default '0',
`Nama` varchar(30) NOT NULL default '',
`Alamat` varchar(50) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'mahasiswa'
#
INSERT INTO mahasiswa VALUES("0501060001","yuni","purbalingga");
INSERT INTO mahasiswa VALUES("0501060002","bebek","ancol");
INSERT INTO mahasiswa VALUES("0501060003","acong","tai_P");
INSERT INTO mahasiswa VALUES("0501060004","krisdayanti","jakarta");
INSERT INTO mahasiswa VALUES("0501060006","bendi","surabaya");



#
# Table structure for table 'mata_kuliah'
#

CREATE TABLE `mata_kuliah` (
`kode` varchar(10) NOT NULL default '0',
`Mata_Kuliah` varchar(50) NOT NULL default '',
`Jam` varchar(50) NOT NULL default '',
`Hari` varchar(10) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'mata_kuliah'
#
INSERT INTO mata_kuliah VALUES("001","SBD","07.00","senin");
INSERT INTO mata_kuliah VALUES("002","pemrograman_terstruktur","09.00","selasa");
INSERT INTO mata_kuliah VALUES("003","pemrogramaan_dasar","10.00","rabu");
INSERT INTO mata_kuliah VALUES("004","aplikom","13.00","kamis");
INSERT INTO mata_kuliah VALUES("005","Metode_Numerik","15.00","sabtu");


#
# Table structure for table 'program_study'
#

CREATE TABLE `program_study` (
`Kode_Prodi` varchar(30) NOT NULL default '0',
`Nama_Prodi` varchar(20) NOT NULL default '',
`Kode_Fakultas` varchar(10) NOT NULL default '',
`Nama_Fakultas` varchar(30) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'program_study'
#
INSERT INTO program_study VALUES("002131","P.Matematika","0200301","KIP");
INSERT INTO program_study VALUES("020003","Akuntansi","0300147","Ekonomi");
INSERT INTO program_study VALUES("020301","T.Informatika","0325477","Teknik");
INSERT INTO program_study VALUES("030145","Keperawatan","0230145","Ilmu_Kesehatan");
INSERT INTO program_study VALUES("030124","P.Biologi","036450","KIP");