DDL dan DML

create database Db3027

use Db3027

create table customer(

kdcus int identity(1,1) primary key,

nmcus varchar(50) not null,

sexcus char(1) check (sexcus in('M','F')),

kotacus varchar(50)

)

create table barang(

kdbrg char(4) primary key,

nmbrg varchar(100) not null,

hrgbrg money default 0 check(hrgbrg > 0)

)

alter table barang add jmlbrg int check(jmlbrg >0)

create table orders(
noorder char(4) primary key,
tglorder datetime,
kdcus int constraint FK__orders__kdcus foreign key references customer (kdcus)
   on update cascade on delete no action
)




create table itemorders(
noorder char(4) foreign key references orders(noorder)
   on update cascade on delete no action,
kdbrg char(4) foreign key references barang(kdbrg)
   on update cascade on delete no action,
qty smallint,
primary key(noorder,kdbrg)
)
http://www.ziddu.com/download/13436278/createdatabaseDb3027.rar.html