DLL Toko Bangunan

DATABASE TOKO KAYU
Data Definition Languague (DDL)
CREATE DATABASE TOKOKAYU
ON
(NAME = 'TOKOKAYU_MDF',
FILENAME = 'E:\ Tokokayu\ TOKOKAYU.MDF',
SIZE = 25,
MAXSIZE = 30,
FILEGROWTH = 5)
LOG ON
(NAME = 'TOKOKAYU_LDF',
FILENAME = 'E:\ Tokokayu\ TOKOKAYU.LDF',
SIZE = 10 MB,
MAXSIZE = 15 MB,
FILEGROWTH = 5 MB)

USE TOKOKAYU // berpindah ke database tokokayu

CREATE TABEL BARANG
(KODE_BARANG CHAR(5) CONSTRAINT PK_BARANG PRIMARY KEY,
NAMA_BARANG VARCHAR(20) NOT NULL,
UKURAN VARCHAR(15) NOT NULL,
HARGA_BELI MONEY DEFAULT 0,
HARGA_JUAL MONEY DEFAULT 0)

CREATE TABEL PELANGGAN
(ID_PELANGGAN CHAR(5) CONSTRAINT PK_PELANGGAN PRIMARY KEY,
NAMA_PELANGGAN VARCHAR(25) NOT NULL,
ALAMAT VARCHAR(50) NOT NULL,
TELEPON VARCHAR(15) NULL)

CREATE TABEL KARYAWAN
(ID_KARYAWAN CHAR(5) CONSTRAINT PK_KARYAWAN PRIMARY KEY,
NAMA_KARYAWAN VARCHAR(20) NOT NULL,
GENDER CHAR NOT NULL,
ALAMAT VARCHAR(50) NULL,
TELEPON VARCHAR(15) NULL,
JABATAN VARCHAR(15),
TGL_MASUK DATETIME)

CREATE TABEL INVENTORY
(KODE_BARANG CHAR(5) CONSTRAINT FK_INVENTORY FOREIGN KEY REFERENCES BARANG(KODE_BARANG),
JUMLAH INT NOT NULL)

CREATE TABEL PENJUALAN
(NO_NOTA INT CONSTRAINT PK_PENJUALAN PRIMARY KEY IDENTITY(1,1),
ID_PELANGGAN CHAR(5) CONSTRAINT FK_PENJUALAN FOREIGN KEY REFERENCES PELANGGAN(ID_PELANGGAN),
ID_KARYAWAN CHAR(5) CONSTRAINT FK_PENJUALANIDKARYAWAN FOREIGN KEY REFERENCES KARYAWAN(ID_KARYAWAN),
TGL_JUAL DATETIME NOT NULL,
TOTAL MONEY)

CREATE TABEL DETAIL_NOTA
(NO_NOTA INT CONSTRAINT FK_DETAIL_NOTA FOREIGN KEY REFERENCES PENJUALAN(NO_NOTA),
KODE_BARANG CHAR(5) CONSTRAINT FK_DETAIL_NOTA2 FOREIGN KEY REFERENCES BARANG(KODE_BARANG),
JLH_BELI INT NOT NULL,
DISKON MONEY DEFAULT 0)

CREATE TABEL RETUR
(NO_RETUR INT CONSTRAINT PK_RETUR PRIMARY KEY,
ID_PELANGGAN CHAR(5) CONSTRAINT FK_RETUR FOREIGN KEY REFERENCES PELANGGAN(ID_PELANGGAN),
TGL_RETUR DATETIME)

CREATE TABEL DETAIL_RETUR
(NO_RETUR INT CONSTRAINT FK_RETUR2 FOREIGN KEY REFERENCES RETUR(NO_RETUR),
KODE_BARANG CHAR(5) CONSTRAINT FK_RETUR3 FOREIGN KEY REFERENCES BARANG(KODE_BARANG),
JLH_RETUR INT NOT NULL,
TOTAL_REKTUR MONEY)

CREATE TABEL ADMIN
(ID_KARYAWAN CHAR(5) CONSTRAINT FK_ADMIN FOREIGN KEY REFERENCES KARYAWAN(ID_KARYAWAN),
PWD VARCHAR(15) NOT NULL )