tugas 2

create Database Akademik
use akademik

create Database Akademik
use akademik

create Table Mhs(
NIM char(3) not null Primary key,
Nama varchar(30) not null,
JK char(1),
Alamat varchar(30),
id_mkl char(5))

create Table Ds(
NIP char(3) not null primary key,
Nama varchar(30) not null,
JK char(1),
Alamat varchar(30))

create Table Mkl(
id_Mkl char(5) not null,
nm_Mkl varchar(10),
jml_sks char(15))

insert into Mhs values ('045','dara','l','3d','0499')
insert into Mhs values ('046','ani','l','3a','0493')
insert into Mhs values ('048','tiwi','l','3b','0492')

insert into Ds values ('045','pramoto','l','jepara’)
insert into Ds values ('046','rani','p','jepara’)
insert into Ds values ('048','sunar','l','kudus')


select*from Mhs














create database perpus
use perpus
create table anggota (
nim char(3) not null primary key,
nama varchar(30) not null,
jk char(1),
alamat varchar(30),
kelas varchar(5))
create table pinjam (
nim char(3) not null,
judulbuku varchar(15),
tglpinjam varchar(20),
tglkembali varchar(20))