Basis Data - Membuat table di Oracle ( Tugas Akhir Basis Data )

create table jasa (

id_jasa char (6),

nama_jasa varchar2(30),

harga_jasa number(8),

constraint pk_jasa primary key (id_jasa)

);

create table customer (

id_customer char (6),

nama_customer varchar2(30),

alamat_customer varchar2(30),

nomor_telepon varchar2(15),

constraint pk_customer primary key (id_customer)

);

create table jenis_sparepart (

id_jenis_sparepart char (6),

kategori_sparepart varchar2(15),

constraint pk_jenis_sparepart primary key (id_jenis_sparepart)

);

create table sparepart (

id_sparepart char(6),

nama_sparepart varchar2(25),

stok_sparepart number(5),

deskripsi_sparepart varchar2(150),

id_jenis_sparepart char(6),

constraint pk_sparepart primary key (id_sparepart, id_jenis_sparepart)

);

create table transaksi (

id_transaksi char(10),

id_jasa char(6),

id_customer char(6),

id_jenis_sparepart char(6),

tgl_transaksi date,

jml_transaksi number(5),

Constraint pk_transaksi primary key (id_transaksi, id_jasa, id_customer, id_jenis_sparepart),

Constraint fk_transaksi_jasa foreign key (id_jasa)

references jasa (id_jasa),

Constraint fk_transaksi_customer foreign key (id_customer)

references customer (id_customer),

Constraint fk_transaksi_jenis_sparepart foreign key (id_jenis_sparepart)

references jenis_sparepart (id_jenis_sparepart)

);

desc jasa;

desc customer;

desc jenis_sparepart;

desc sparepart;

desc transaksi;