Hotel Database SQL Scripts (for Oracle)

CREATE TABLE hotels ...
-- ============================================================
--   Project name :  HOTEL_INFORMATION_WEB_SITE
--   DBMS name    :  ORACLE Version 8
--   Created on   :  21 Jan 2001  10:10 am
-- ============================================================

-- ============================================================
--   Table: HOTEL_CHAIN
-- ============================================================
create table HOTEL_CHAINS
(
    HOTEL_CHAIN_ID              INTEGER                not null,
    HOTEL_CHAIN_CODE            CHAR(10)               null    ,
    HOTEL_CHAIN_NAME            VARCHAR2(50)           null    ,
    constraint PK_HOTEL_CHAIN primary key (HOTEL_CHAIN_ID)
)
/

-- ============================================================
--   Table: REF_HOTEL_CHARACTERISTICS
-- ============================================================
create table REF_HOTEL_CHARACTERISTICS
(
    CHARACTERISTIC_ID           INTEGER                not null,
    CHARACTERISTIC_CODE         CHAR(10)               null    ,
    CHARACTERISTIC_DESCRIPTION  VARCHAR2(50)           null    ,
    constraint PK_REF_HOTEL_CHARACTERISTICS primary key (CHARACTERISTIC_ID)
)
/

-- ============================================================
--   Table: REF_COUNTRY
-- ============================================================
create table REF_COUNTRYS
(
    COUNTRY_CODE                CHAR(3)                not null,
    COUNTRY_CURRENCY            CHAR(10)               null    ,
    COUNTRY_NAME                VARCHAR2(50)           null    ,
    constraint PK_REF_COUNTRY primary key (COUNTRY_CODE)
)
/

-- ============================================================
--   Table: REF_STAR_RATING
-- ============================================================
create table REF_STAR_RATINGS
(
    STAR_RATING_ID              INTEGER                not null,
    STAR_RATING_CODE            CHAR(8)                null    ,
    STAR_RATING_IMAGE           CHAR(20)               null    ,
    constraint PK_REF_STAR_RATING primary key (STAR_RATING_ID)
)
/

-- ============================================================
--   Table: HOTEL
-- ============================================================
create table HOTELS
(
    HOTEL_ID                    INTEGER                not null,
    COUNTRY_CODE                CHAR(3)                not null,
    STAR_RATING_ID              INTEGER                not null,
    HOTEL_CHAIN_ID              INTEGER                null    ,
    HOTEL_CODE                  CHAR(10)               null    ,
    HOTEL_NAME                  VARCHAR2(50)           null    ,
    constraint PK_HOTEL primary key (HOTEL_ID)
)
/

-- ============================================================
--   Table: HOTEL_CHARACTERISTICS
-- ============================================================
create table HOTEL_CHARACTERISTICS
(
    CHARACTERISTIC_ID           INTEGER                not null,
    HOTEL_ID                    INTEGER                not null,
    constraint PK_HOTEL_CHARACTERISTICS primary key (CHARACTERISTIC_ID, HOTEL_ID)
)
/