Exercise 3.

Tables (5)

Untitled (Customer)

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(10)
  • Field2 — integer(13)
  • Field3 — integer(5)
  • Key (Key2) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Service)

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(30)
  • Field2
  • Field3 — char(10)
  • Field4 — integer(13)
  • Field5 — integer(5)
  • Key (Key2) — char(30) — Foreign key → Untitled.Key — NOT NULL

Untitled (Service Sponcor)

  • Key — char(30) — Primary key — NOT NULL
  • Field — char(10)
  • Field2 — char(50)
  • Field3 — integer(15)

Untitled (Family)

  • Key — char(30) — Foreign key → Untitled.Key — NOT NULL
  • Field — char(10)
  • Field2 — integer(13)
  • Field3 — integer(5)

Untitled (Be Provided)

  • Field — integer(8)
  • Key — char(30) — Foreign key → Untitled.Key — NOT NULL