create database db080010197
on (name= N'db080010197_data',
filename = N'd:\k081\db080010197.mdf')
log on (name= N'db080010197_log',
filename = N'd:\k081\db080010197.ldf')
use db080010197
create table departemen
(
Departmentid varchar (5) primary key,
Departmentnama varchar (55),
Departmenthead varchar (25)
)
insert into departemen values ('0001','dep_perindustrian','')
insert into departemen values ('0002','dep_kepariwisataan','kuncoro')
insert into departemen values ('0003','dep_keuangan','sukarjana')
insert into departemen values ('0004','dep_perhutanan','supriono')
insert into departemen values ('0005','dep_kelautan','mega')