Pequeña base de datos
(CODE VARCHAR2(2)
DESCRIPTION VARCHAR2(22))
create table country
( COUNTRYVARCHAR2(30) NOT NULL,
STATISTIC_CODE NUMBER(8),
REGION VARCHAR2(30),
ABBREVATION VARCHAR2(3),LANGUAGE VARCHAR2(10),
TELEPHONE_CODE NUMBER(4))
create table dept
( DEPT_CODE VARCHAR2(8) NOT NULL,
TEXTVARCHAR2(80),
DEPTCODE_DESCRIPTION VARCHAR2(35),
REMARKS VARCHAR2(200))
create table locator
( CODENUMBER(3) NOT NULL,
DESCRIPTION VARCHAR2(30))
create table event
( FROM1 DATE,
UNTIL1DATE,
EVENT1 VARCHAR2(30))
create table exchange
( CODE VARCHAR2(3) NOT NULL,
DESCRIPTIONVARCHAR2(30),
EXC_RATE NUMBER(12),
ACC_EXCH NUMBER(12))
create table floor
( FLOOR VARCHAR2(4)NOT NULL,
DESCRIPTION VARCHAR2(20))
create table floor1
( FLOOR VARCHAR2(8))
create table hotel_status
( TOTAL_ROOMVARCHAR2(6),
ROOM_OCCUPIED VARCHAR2(6),
OCC_ROOM VARCHAR2(6),
ARRIVAL_ROOMVARCHAR2(6),
DEPARTURE_ROOM VARCHAR2(6),
RESERVATION_MADE_TODAY VARCHAR2(6),
ARRIVAL_TOMORROW_ROOM VARCHAR2(6),
DEPARTURE_TOMORROR_ROOM...
Regístrate para leer el documento completo.