Contoh Script pembuatan tabel pada DBMS

 Create table Staf
(
Nip varchar (9) primary key,
Nama varchar (25),
Sex varchar (1),
Gol varchar (5),
Status char (1),
Alamat varchar (30),
NoCbg varchar (5)
)


Create table Cabang
(
NoCbg varchar (5)Primary key,
Alamat varchar (30),
Telp varchar (15),
E_Mail varchar (20),
Fax varchar (15)
)

Create table Jual
(
No_Bukti varchar (5),
Tgl_Jual Date,
Kd_Prod char (5),
Jumlah Int,
Nip varchar (9)
)

Create table Produk
(
Kd_Prod char (5) Primary key,
Nama varchar (25),
Merk varchar (25),
Satuan varchar (15),
Harga int
)