CS3402 Practice 1

Tables (5)

Cars

  • Key (VIN) — string — Primary key — NOT NULL
  • id (SSN) — int — Foreign key → Customers.id — NOT NULL

Customers

  • id (SSN) — int — Primary key — NOT NULL
  • name — string

Untitled (Accidents)

  • Key (VIN) — string — Foreign key → Cars.Key — NOT NULL
  • id (SSN) — int — Foreign key → Cars.id — NOT NULL
  • Field (Description) — string

Untitled (Patients)

  • Key (SSN) — int — Primary key — NOT NULL
  • Field (name) — string

Untitled (Doctor)

  • Key (SSN) — string — Primary key — NOT NULL
  • Field (name) — string