“TABEL DOSEN”
CREATE TABLE [dbo].[Tabel_dosen](
[NIP] [char](50) NOT NULL,
[Nama]
[char](50) NULL,
[Alamat]
[char](50) NULL,
[Mata
Kuliah] [char](10)
NULL,
CONSTRAINT [PK_Tabel_dosen] PRIMARY
KEY CLUSTERED
(
“TABEL MAHASISWA”
CREATE TABLE [dbo].[Tabel_mhs](
[NPM] [char](10) NOT NULL,
[Nama]
[char](50) NULL,
[Kelas]
[char](10) NULL,
[Jurusan]
[char](10) NULL,
[Alamat]
[char](50) NULL,
CONSTRAINT [PK_Tabel_mhs] PRIMARY
KEY CLUSTERED
(
“TABEL NILAI”
CREATE TABLE [dbo].[Tabel_nilai](
[NPM] [char](10) NOT NULL,
[Kuis]
[char](10) NULL,
[Tugas]
[char](10) NULL,
[UTS] [char](10) NULL,
[UAS] [char](10) NULL,
[Kode mata
kuliah] [char](10)
NULL,
[NIP] [char](10) NULL,
CONSTRAINT [PK_Tabel_nilai] PRIMARY
KEY CLUSTERED
(
“TABEL MATAKULIAH”
CREATE TABLE [dbo].[Table_matakuliah](
[Kode mata
kuliah] [char](10)
NOT NULL,
[Mata
Kuliah] [char](10)
NULL,
[Dosen]
[char](50) NULL,
[Jurursan]
[char](10) NULL,
CONSTRAINT [PK_Table_matakuliah] PRIMARY KEY CLUSTERED
(
“TABEL MENGAJAR”
CREATE TABLE [dbo].[Tabel_mengajar](
[NIP] [char](10) NOT NULL,
[Kode mata
kuliah] [char](10)
NULL,
[Ruang]
[char](10) NULL,
CONSTRAINT [PK_Tabel_mengajar] PRIMARY KEY CLUSTERED
(