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