contoh program sederhana
desain database sensus penduduk
menggunakan
sql server 2008
epenta brahmana
ni adalah contoh sederhana desain database sql server 2008
"semoga bermanfaat "
create database pensensusanmasyrakatdalamkelurahan
use
pensensusanmasyrakatdalamkelurahan
create table penduduk(
noktp int primary key,
nama char (20),
alamat char(20),
pekerjaan char(25),
norumah int,
agama char(10),
jeniskelamin char(1))
insert into penduduk values('111087','sugianto','jl.kotacane','wiraswasta','22','katolik','p')
insert into penduduk values('632874','carles','jl.kotacane','polisi','15','islam','p')
insert into penduduk values('758237','monita','jl.kotacane','guru','22','katolik','l')
insert into penduduk values('683628','latersia','jl.kotacane','wiraswasta','22','katolik','l')
select*from penduduk
create table pindahan(
nopindahan int primary key,
noktp int foreign key references
penduduk (noktp),
nama char(50),
alamat char(20),
pekerjaan char(25),
norumah int,
agama char(10),
jeniskelamin char(1),
asalpindahan char(30))
drop table pindahan
insert into pindahan values('008','111087','sugianto','jl.kotacane','wiraswasta','22','katolik','p','samosir')
insert into pindahan values('032','632874','anjra','jl.medan','polisi','22','islam','l','samosir')
insert into pindahan values('055','758237','indra','jl.bandung','pengaguran','22','budha','l','padang')
insert into pindahan values('065','683628','utri','jl.jakarta','septa','22','islam','p','jawa')
select*from pindahan
create table kematian(
noktp int primary key,
nama char(20),
alamat char(20),
pekerjaan char(25),
norumah int,
agama char(10),
jeniskelamin char(1),
tglkematian datetime)
insert into kematian values('393239','jufri','jl.kotacane','wiraswasta',423,'islam','l',09/09/1997 )
insert into kematian values('328732','halimah','jl.kotacane','wiraswasta',67,'islam','p',12/10/1985 )
insert into kematian values('111087','joko','jl.kotacane','wiraswasta',687,'islam','p',15/05/1987 )
insert into kematian values('111597','hona','jl.kotacane','wiraswasta',646,'islam','l',08/10/1997 )
select*from kematian
create table fropil(
noktp int primary key,
nama char(20),
alamat char(20),
pekerjaan char(25),
norumah int,
agama char(20),
jeniskelamin char(1),
fropil char(25))
insert into fropil values('576227','gino','jl.kota cane','bertani','567','kristen protestan','l','duda')
insert into fropil values('638597','guni','jl.kota cane','bertani','75','kristen protestan','l','berkeluarga')
insert into fropil values('789767','siah','jl.kota cane','wiraswasta','566','islam','l','janda')
insert into fropil values('575068','napa','jl.kota cane','tentara','567','katolik','l','berkeluarga')
select*from fropil
create table keterangan(
noktp int foreign key references
kematian (noktp),
nama char(20),
jumlahanak int)
select * from keterangan
drop table keterangan
insert into keterangan values('393239','sugeng','8')
insert into keterangan values('328732','hardino','7')
insert into keterangan values('111087','nandangi','2')
insert into keterangan values('111597','iko','3')
select*from keterangan
select nama,tglkematian
from kematian