MINIproject

Tables (7)

COUNTRY

  • CNUM — NUMBER — Primary key
  • CNAME — NVARCHAR2(20)

HOTELS

  • HNUM — NUMBER — Primary key
  • SNUM (SNUM2) — NUMBER — Foreign key → S_CLUB.SNUM
  • HNAME — NVARCHAR2(100)
  • HPRICE — NUMBER
  • HLOCATION — NVARCHAR2(200)

PAYMENT

  • PNUM — NUMBER — Primary key
  • RNUM (RNUM2) — NUMBER — Foreign key → RESERVATION.RNUM
  • TID — NVARCHAR2(30) — Foreign key → TMEMBER.TID
  • RNUM — NUMBER
  • hhh — NVARCHAR2(10)

RESERVATION

  • RNUM — NUMBER — Primary key
  • HNUM — NUMBER — Foreign key → HOTELS.HNUM
  • DNUM — NUMBER — Foreign key → SCHEDULE.DNUM
  • TID — NVARCHAR2(30) — Foreign key → TMEMBER.TID
  • PAYMENT — NUMBER

SCHEDULE

  • DNUM — NUMBER — Primary key
  • SNUM — NUMBER — Foreign key → S_CLUB.SNUM
  • DDATE — DATE
  • AMOUNT — NUMBER

S_CLUB

  • SNUM — NUMBER — Primary key
  • CNUM — NUMBER — Foreign key → COUNTRY.CNUM
  • CLUB_NAME — NVARCHAR2(50) — NOT NULL
  • STADIUM — NVARCHAR2(100)

TMEMBER

  • TID — NVARCHAR2(30) — Primary key
  • TPW — NVARCHAR2(30) — NOT NULL
  • TNAME — NVARCHAR2(10)
  • TAGE — NUMBER
  • TPHONE — NVARCHAR2(13)
  • TEMAIL — NVARCHAR2(50)
  • TPOINT — NUMBER