tugas basdat

“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

(