Pequeña base de datos

Solo disponible en BuenasTareas
  • Páginas : 4 (810 palabras )
  • Descarga(s) : 0
  • Publicado : 17 de mayo de 2011
Leer documento completo
Vista previa del texto
create table airline
(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...
tracking img