Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.4.10.1
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost
- -- Generation Time: May 23, 2012 at 03:55 PM
- -- Server version: 5.5.20
- -- PHP Version: 5.3.10
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `nurulilm_raports`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `mapel`
- --
- CREATE TABLE IF NOT EXISTS `mapel` (
- `id_mapel` int(11) NOT NULL AUTO_INCREMENT,
- `id_kategori` int(11) NOT NULL,
- `id_group` int(11) NOT NULL,
- `id_tapel` int(11) NOT NULL,
- `nama_mapel` varchar(100) NOT NULL,
- `semester` varchar(5) NOT NULL,
- PRIMARY KEY (`id_mapel`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
- --
- -- Dumping data for table `mapel`
- --
- INSERT INTO `mapel` (`id_mapel`, `id_kategori`, `id_group`, `id_tapel`, `nama_mapel`, `semester`) VALUES
- (1, 2, 1, 1, 'Pendidikan Agama', '1'),
- (2, 2, 1, 1, 'Pendidikan Kewarganegaraan Dan Sejarah', '1'),
- (3, 2, 1, 1, 'Bahasa Indonesia', '1'),
- (4, 2, 1, 1, 'Pendidikan Jasmani Dan Olah Raga', '1'),
- (5, 2, 1, 1, 'Bahasa Jawa', '1'),
- (6, 1, 1, 1, 'Matematika', '1'),
- (7, 1, 1, 1, 'Bahasa Inggris', '1'),
- (8, 1, 1, 1, 'Keterampilan Komputer Dan Pengelolaan Informasi (KKPI)', '1'),
- (9, 1, 1, 1, 'Kewirausahaan', '1'),
- (10, 1, 1, 1, 'Ekonomi', '1'),
- (11, 3, 1, 1, 'Kerjasama Dengan Kolega Dan Pelanggan', '1'),
- (12, 3, 1, 1, 'Menggunakan Peralatan Kantor', '1'),
- (13, 3, 1, 1, 'Melakukan Prosedur Administrasi', '1'),
- (14, 3, 1, 1, 'Memberikan Pelayanan Kepada Pelanggan', '1'),
- (15, 3, 1, 1, 'Mengaplikasikan Keterampilan Dasar Komunikasi', '1'),
- (16, 3, 1, 1, 'Mengetik', '1'),
- (24, 1, 1, 1, 'IPA', '1'),
- (25, 1, 1, 1, 'Fisika', '1'),
- (26, 1, 1, 1, 'Kimia', '1'),
- (27, 1, 1, 1, 'IPS', '1'),
- (31, 2, 2, 1, 'Seni Budaya', '1'),
- (32, 3, 1, 1, 'Memilih & Mengprasikan Perangkat Dasar Multimedia', '1'),
- (33, 3, 1, 1, 'Merancang Produk Multimedia', '1'),
- (34, 3, 1, 1, 'Mengetik', '1'),
- (35, 3, 1, 1, 'Bahasa Jawa Banyumasan', '1'),
- (36, 3, 1, 1, 'BP', '1'),
- (46, 1, 1, 1, 'Seni Budaya', '1'),
- (49, 3, 1, 1, 'Menerapkan Prinsip Praktek Profesional dlm Bekerja', '1'),
- (50, 3, 1, 1, 'Memproses Entri Jurnal', '1'),
- (51, 3, 1, 1, 'Memproses Buku Besar Sekali', '1'),
- (52, 3, 1, 1, 'Menyelesaikan Siklus Akutansi', '1'),
- (53, 3, 1, 1, 'Mengetik', '1'),
- (54, 3, 1, 1, 'Bahasa Jawa Banyumasan', '1');
- -- --------------------------------------------------------
- --
- -- Table structure for table `nilai`
- --
- CREATE TABLE IF NOT EXISTS `nilai` (
- `id_nilai` int(11) NOT NULL AUTO_INCREMENT,
- `id_siswa` int(11) NOT NULL,
- `id_mapel` int(11) NOT NULL,
- `id_tapel` int(11) NOT NULL,
- `n_tugas` varchar(5) NOT NULL,
- `uts` varchar(5) NOT NULL,
- `uas` varchar(5) NOT NULL,
- `n_hasil` varchar(5) NOT NULL,
- `semester` varchar(5) NOT NULL,
- PRIMARY KEY (`id_nilai`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
- --
- -- Dumping data for table `nilai`
- --
- INSERT INTO `nilai` (`id_nilai`, `id_siswa`, `id_mapel`, `id_tapel`, `n_tugas`, `uts`, `uas`, `n_hasil`, `semester`) VALUES
- (1, 1, 3, 1, '90', '90', '90', '90', '1'),
- (2, 1, 1, 1, '95', '80', '100', '91.66', '1'),
- (3, 1, 4, 1, '70', '70', '75', '71.66', '1'),
- (4, 1, 5, 1, '100', '100', '100', '100', '1'),
- (5, 1, 2, 1, '85', '90', '95', '90', '1'),
- (6, 2, 33, 1, '90', '90', '90', '90', '1'),
- (7, 2, 12, 1, '80', '90', '90', '86.66', '1'),
- (8, 2, 49, 1, '100', '85', '90', '91.66', '1');
- -- --------------------------------------------------------
- --
- -- Table structure for table `siswa`
- --
- CREATE TABLE IF NOT EXISTS `siswa` (
- `id_siswa` int(11) NOT NULL AUTO_INCREMENT,
- `id_ortu` int(5) NOT NULL,
- `id_kelas` int(11) NOT NULL,
- `id_group` int(11) NOT NULL,
- `nis` varchar(25) NOT NULL,
- `nama` varchar(150) NOT NULL,
- `tempat_lahir` varchar(50) NOT NULL,
- `tanggal_lahir` date NOT NULL,
- `jenis_kelamin` enum('L','P') NOT NULL,
- `agama` enum('islam','kristen','katholik','hindu','budha') NOT NULL,
- `alamat` varchar(150) NOT NULL,
- `lulusan` varchar(100) NOT NULL,
- `angkatan` int(25) NOT NULL,
- `foto` varchar(50) NOT NULL,
- PRIMARY KEY (`id_siswa`)
- ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
- --
- -- Dumping data for table `siswa`
- --
- INSERT INTO `siswa` (`id_siswa`, `id_ortu`, `id_kelas`, `id_group`, `nis`, `nama`, `tempat_lahir`, `tanggal_lahir`, `jenis_kelamin`, `agama`, `alamat`, `lulusan`, `angkatan`, `foto`) VALUES
- (1, 1, 1, 1, '1101', 'Fandi Akhmad', 'Banyuwangi', '1992-08-30', 'L', 'islam', 'Jl.Tebet Timur', '-', 2007, ''),
- (2, 2, 1, 1, '1102', 'Annisya Ferronica', 'Banyuwangi', '1995-04-24', 'P', 'islam', 'Jl.Opak', 'TK', 2009, ''),
- (3, 2, 1, 1, '1103', 'Michael', 'Amerika', '1990-04-05', 'L', 'kristen', 'Jl.Brawijaya', 'TK', 2000, ''),
- (4, 2, 4, 3, '1104', 'Johny F.', 'Australia', '1992-03-07', 'L', '', 'Jl.Pramuka', 'TK', 2005, '');
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement