ERD EXERCISE 3

Tables (7)

Untitled (CLIENT)

  • Key (clientld) — int(5) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (address) — chat(100)
  • Field (phone) — int(11)
  • Field (emaill) — char(100)
  • Field (ssn) — char(13)

Untitled (DEPENDANT)

  • Key (dependantld) — int(5) — Primary key — NOT NULL
  • Field (name) — char(10)
  • Field (phone) — int(11)
  • Key (clientld) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Field (ssn) — char(13)

Untitled (SERVICEPROVIDER)

  • Key (providerld) — int(100) — Primary key — NOT NULL
  • Field (name) — char(100)
  • Field (address) — char(100)
  • Field (phone) — int(12)
  • Field (grade) — float(3)
  • Field (memo) — LONGTEXT
  • Field (type) — char(4)

Untitled (ENROLL)

  • Key (sereld) — integer — Primary key — NOT NULL
  • Field (grade) — char(2)
  • Field (review) — LONGTEXT
  • Key (clientld) — int(5) — Foreign key → Untitled.Key — NOT NULL
  • Key (classld) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (date) — date

Untitled (SERVICE)

  • Key (classld) — int(100) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (level) — char(2)
  • Field (year) — int(4)
  • Field (month) — int(2)
  • Field (lecturer) — char(10)
  • Key (providerld) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Key (subjectld) — int(10) — Foreign key → Untitled.Key — NOT NULL
  • Key (lecturerld) — int(100) — Foreign key → Untitled.Key — NOT NULL
  • Field (fee) — integer

Untitled (SUBJECT)

  • Key (subjectld) — int(10) — Primary key — NOT NULL
  • Field (name) — char(30)
  • Field (memo) — LONGTEXT

Untitled (LECTURER)

  • Key (lecturerld) — int(100) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (phone) — char(20)
  • Field (email) — char(30)
  • Field (description) — text