rental

Tables (4)

customer

  • customer no (cust_no) — varchar2 — Primary key — NOT NULL
  • customer name (customer_name) — varchar2
  • address — varchar2
  • phone (phonr) — varchar2
  • c_type — varchar2

rent office (office)

  • Office No (off_no) — number — Primary key — NOT NULL
  • address — varchar2
  • telephone (phone) — varchar2 — NOT NULL

rental

  • contract number (Cno) — varchar2 — Primary key — NOT NULL
  • Office No (off_no) — number — Foreign key → rent office.Office No — NOT NULL
  • car no (c_no) — varchar — Foreign key → truck.car no — NOT NULL
  • customer no (cust_no) — varchar2 — Foreign key → customer.customer no — NOT NULL
  • customer no (Cust_no) — varchar2
  • rental office (rent_office) — number
  • rental miles (rent_miles) — number
  • return office (return _ffice) — number
  • return_miles — number
  • Office No (off_no2) — number — Foreign key → rent office.Office No — NOT NULL

truck

  • car no (c_no) — varchar — Primary key — NOT NULL
  • Truck type (type) — varchar
  • last fixed date (fixed_date) — date
  • end date — date