Contoh Database TKI

1. create database tki
on primary(
name=datatki,
filename="D:\haryadi\tki.MDF",
size=25MB,
maxsize=50MB,

filegrowth=1MB)
log on(
name=logtki,
filename="D:\haryadi\tki.LDF",
size=5MB,
maxsize=50MB,
filegrowth=1MB)

2. create table keahlian
(
kodekeahlian int not null primary key,
keahlian varchar(30) null)

3. create table negara
(
kodenegara int not null primary key,
negara varchar(25) null)

4. create table perusahaan
(
kodeperusahaan int not null primary key,
namaperusahaan varchar(35),
alamat varchar(25),
telepone char(12),
)

5. create table pendaftaran
(
nopendaftaran int not null primary key,
tglpendaftaran date,noktp int,nama varchar(30),
tlahir varchar(25),statusperkawinan(15),
agama varchar(10),pendidikan varchar(10),
kodekeahlian int not null,
kodenegara int not null,
kodeperusahaan int not null,
constraint FK_pendaftaran_keahlian foreign key(kodekeahlian),
refences keahlian(kodekeahlian),
constraint FK_pendaftaran_negara foreign key(kodenegara),
refences negara(kodenegara),
constraint FK_pendaftaran_perusahaan foreign key(kodeperusahaan),
refences perusahaan(kodeperusahaan),
)

6. create table hasiltest
(
notest int not null primary key,
tgltest date,
nopendaftaran int not null,
nilai int null,
keterangan varchar(10) null,
constraint FK_hasiltest_pendaftaran foreign key(nopendaftaran),
refences pendaftaran(nopendaftaran),
)

7. create table paspor
(
nopaspor int not null primary key,
notest int not null,
tglpengeluaran date,
tglhabisberlaku int not null,
alamat tujuan varchar(25),
constraint FK_paspor_hasiltest foreign key(notest),
refences hasiltes(notesst),
)