exercise 3

Tables (5)

customer (Untitled)

  • ssn (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(30)
  • phone (Field3) — char(11)

day (Untitled5)

  • day (Key) — Primary key — NOT NULL
  • ssn (Key2) — char(13) — Foreign key → customer.ssn — NOT NULL
  • code (Key3) — char(10) — Foreign key → service.code — NOT NULL

dependent (Untitled2)

  • ssn (Key) — char(13) — Primary key — NOT NULL
  • name (Field) — char(10)
  • birthdate (Field2) — char(8)
  • code (Key2) — char(10) — Foreign key → service.code — NOT NULL

service (Untitled4)

  • code (Key) — char(10) — Primary key — NOT NULL
  • description (Field) — char(100)

service provider (Untitled3)

  • uni no (Key) — char(20) — Primary key — NOT NULL
  • name (Field) — char(10)
  • address (Field2) — char(30)
  • phone (Field3) — char(11)
  • Field4
  • ssn (Key2) — char(13) — Foreign key → customer.ssn — NOT NULL