Exercise3

Tables (5)

Client (Untitled)

  • PersonalNumber (Key) — char(20) — Primary key — NOT NULL
  • Name (Field) — char(20)
  • Adress (Field2) — char(20)
  • PhoneNumber (Field3) — char(20)
  • ServiceCode (Key2) — char(20) — Foreign key → Service.ServiceCode — NOT NULL

Client_Family (Untitled2)

  • PersonalNumber (Key) — char(20) — Primary key — NOT NULL
  • PersonalNumber (Key2) — char(20) — Foreign key → Client.PersonalNumber — NOT NULL
  • Name (Field) — char(20)
  • Adress (Field2) — char(20)
  • PhoneNumber (Field3) — char(20)

Institution (Untitled5)

  • Administration (Key) — char(20 — Primary key — NOT NULL
  • PrivateCenter (Key2) — char(20) — Primary key — NOT NULL

Service (Untitled3)

  • ServiceCode (Key) — char(20) — Primary key — NOT NULL
  • Description (Field) — text
  • Date (Field2) — date
  • SupplierID (Key2) — char(20) — Foreign key → Service_Supplier.SupplierID — NOT NULL

Service_Supplier (Untitled4)

  • SupplierID (Key) — char(20) — Primary key — NOT NULL
  • Name (Field) — char(20)
  • Adress (Field2) — char(20)
  • PhoneNumber (Field3) — char(20)
  • Administration (Key2) — char(20 — Foreign key → Institution.Administration — NOT NULL
  • PrivateCenter (Key22) — char(20) — Foreign key → Institution.PrivateCenter — NOT NULL