Membuat Tabel Penjualan

Store procedur dan Relasi

use penjualan;

create table Barang (

kd_barang int identity,

nama_barang varchar (20) null,

Harga int not null,

kd_tipe int  FOREIGN KEY (kd_tipe) REFERENCES TipeBarang (kd_tipe) on update cascade on delete cascade,

constraint fk_Barang PRIMARY KEY CLUSTERED (kd_barang)

);

use penjualan;

create table TipeBarang (

kd_tipe int not null primary key,

NamaTipe Varchar (20) null,

);

use penjualan;

create table Pelanggan1 (

kd_pelanggan int not null Primary key,

nama_pelanggan varchar (25) null,

alamat varchar (30) null,

kota Varchar (30) null,

kd_pos int not null,

telpon int not null,

);

use penjualan;

create table faktur (

No_Fj int identity,

Tanggal_Fj int not null,

kd_pelanggan int foreign key (kd_pelanggan) references Pelanggan1 (kd_pelanggan) on update cascade on delete cascade,

constraint fk_faktur PRIMARY KEY CLUSTERED (No_Fj)

);