dd

Tables (3)

Truck (truck)

  • car_no (c_no) — varchar2 — Primary key — NOT NULL
  • truck type — varchar2
  • last fixed date (fixed_date) — date
  • end date (end_date) — date

rent office (office)

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

rental

  • contarct number (Cno) — varchar2 — Primary key
  • customer no (Cust_no) — varchar2
  • retal miles (retal_office) — number
  • retal miles (retal_miles) — number
  • rental office (rental_office) — number
  • rental miles (rental_miles) — number