Exercise3
Tables (4)
Customer (Untitled)
- customerId (Key) — char(5) — Primary key — NOT NULL
- customerName (Field) — char(30)
- identificationNumber (Field2) — char(13)
- phone (Field3) — char(11)
- address (Field4) — text
Dependent (Untitled3)
- dependentId (Key) — char(10) — Primary key — NOT NULL
- dependentName (Field) — char(30)
- identificationNumber (Field2) — char(13)
- age (Field3) — char(3)
- gender (Field4) — char(1)
- relation (Field5) — char(10)
- customerId (Key2) — char(5) — Foreign key → Customer.customerId — NOT NULL
Service (Untitled2)
- serviceCode (Key) — char(5) — Primary key — NOT NULL
- serviceName (Field) — char(30)
- description (Field2) — text
- sreviceDate (Field3) — date
- customerId (Key2) — char(5) — Foreign key → Customer.customerId — NOT NULL
- serviceProviderId (Key3) — char(5) — Foreign key → ServiceProvider.serviceProviderId — NOT NULL
ServiceProvider (Untitled4)
- serviceProviderId (Key) — char(5) — Primary key — NOT NULL
- serviceProviderName (Field) — char(30)
- phone (Field2) — char(11)
- address (Field3) — text
- hostInstitution (Field4) — char(10)