-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 01, 2003 at 06:27
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `dbnilai`
--

-- --------------------------------------------------------

--
-- Table structure for table `login`
--

CREATE TABLE IF NOT EXISTS `login` (
  `user` varchar(25) NOT NULL,
  `pass` varchar(15) NOT NULL,
  PRIMARY KEY (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `login`
--


-- --------------------------------------------------------

--
-- Table structure for table `mahasiswa`
--

CREATE TABLE IF NOT EXISTS `mahasiswa` (
  `nim` varchar(12) NOT NULL,
  `nama` varchar(35) NOT NULL,
  `jk` varchar(6) NOT NULL,
  `tptlahir` varchar(25) NOT NULL,
  `tgllahir` varchar(25) NOT NULL,
  `kelas` varchar(7) NOT NULL,
  `jurusan` varchar(25) NOT NULL,
  PRIMARY KEY (`nim`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mahasiswa`
--


-- --------------------------------------------------------

--
-- Table structure for table `matakuliah`
--

CREATE TABLE IF NOT EXISTS `matakuliah` (
  `kdmk` varchar(5) NOT NULL,
  `nmmk` varchar(35) NOT NULL,
  `jurusan` varchar(35) NOT NULL,
  `sks` int(4) NOT NULL,
  PRIMARY KEY (`kdmk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `matakuliah`
--


-- --------------------------------------------------------

--
-- Table structure for table `nilai`
--

CREATE TABLE IF NOT EXISTS `nilai` (
  `nim` varchar(12) NOT NULL,
  `kdmk` varchar(5) NOT NULL,
  `tugas` int(4) NOT NULL,
  `kuis` int(4) NOT NULL,
  `uts` int(4) NOT NULL,
  `uas` int(4) NOT NULL,
  `hadir` int(4) NOT NULL,
  `angka` int(4) NOT NULL,
  `huruf` char(1) NOT NULL,
  `ket` varchar(5) NOT NULL,
  PRIMARY KEY (`nim`,`kdmk`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `nilai`
--

Save As di Notepad dengan nama " nilai "