conn system/terserah

create user csp identified by csp;

grant connect,resource to csp;

conn csp/csp
--asumsi membuat soft unt
--karaoke

drop table roomtype;
drop table room;
drop table resto;
drop table htrans;
drop table dtrans;

create table roomtype
(
  roomtype varchar2(3) constraint pk_roomtype primary key,
  roomprice number(7) constraint ch_roomtype_price check (roomprice>0),
  roommax  number(2)
);

insert into roomtype values
('A01',50000,5);
insert into roomtype values
('B01',75000,10);
insert into roomtype values
('C01',100000,15);