Sebenernya cukup mudah kok cara mebuata silah kan anda ketikan saja query di bawah ini,lalu database sederhana anda sudah jadi
1.create database mahasiswa
2.create table tbMahasiswa(NPM
nvarchar(10) Primary key, nama_mhs nvarchar(20),
kd_fak nvarchar(10), kd_prodi nvarchar(20), gender nvarchar(20),
alamat nvarchar(20), tahun_angkatan nvarchar(9))
3.create table tbprodi(kd_prodi
nvarchar(20) primary key, nama_prodi nvarchar(20),kaprodi nvarchar(20), kd_fak nvarchar(20))
4.create table tbfakultas(kd_fak
nvarchar(20) primary key, nama_fak nvarchar(20), nama_dekan nvarchar(20))
5.create table tbdosen(kd_dosen
nvarchar(20) primary key,
nama_dosen nvarchar(20), alamat nvarchar(20), gender nvarchar(20))
6.create table tbmatkul(kd_mk nvarchar(10) primary key, nm_mk nvarchar(20), sks_mk nvarchar(20))
7.create table tbruang(kd_ruang
nvarchar(20) primary key, nm_ruang nvarchar(20), nm_gedung nvarchar(20))
8.create table tbkhs(kd_khs nvarchar(20) primary key, NPM nvarchar(20), khs_semester nvarchar(20),
khs_tahun_ajaran nvarchar(5), kd_fak nvarchar(10), kd_prodi nvarchar(10), kd_mk nvarchar(10), kd_dosen nvarchar(10), nilai_mk float)