Business Rules: A Case Study - High-Performance Web Databases: Design, Development, and Deployment - page 137

Exhibit 9-4. Comprehensive business rules for nanny agency. ( continued )

Relationships

3. A CLIENT signs zero, one, or many EMPLOYMENT CONTRACTS. An EMPLOYMENT
CONTRACT is signed by one and only one CLIENT.
5. A CAREGIVER signs zero, one, or many EMPLOYMENT CONTRACTS. An
EMPLOYMENT CONTRACT is signed by one and only one CAREGIVER.
19. A SERVICE requires zero, one, or many SERVICE SKILLS. A SERVICE SKILL is
required by one and only one SERVICE.
20. A SKILL is required by zero, one, or many SERVICE SKILLS. A SERVICE SKILL
requires one and only one SKILL.
21. A CAFIEGIVER is affiliated with zero or one RELIGION. A RELIGION is affiliated with
zero, one, or many CAREGIVERS.
41. An APPLICATION specifies one or many APPLICATION REFERENCES. An
APPLICATION REFERENCE is specified in one and only one APPLICATION.
42. An APPLICATION is a supertype for zero or one CLIENT APPLICATION. A CLIENT
APPLICATION is a subset of one and only one APPLICATION.
43. An APPLICATION is a supertype for zero or one CAREGIVER APPLICATION. A
CAREGIVER APPLICATION is a subset of one and only one APPLICATION.
44. A CLIENT APPLICATION requests one or many CLIENT APPLICATION SERVICES. A
CLIENT APPLICATION SERVICE is requested by one and only one CLIENT APPLICATION.
45. A SERVICE is requested by zero, one, or many CLIENT APPLICATION SERVICES. A
CLIENT APPLICATION SERVICE requests one and only one SERVICE.
46. A SERVICE is a supertype for zero or one HOUSEKEEPING SERVICE. A
HOUSEKEEPING SERVICE is a subset of one and only one SERVICE.
47. A SERVICE is a supertype for zero or one DEPENDENT CARE SERVICE. A
DEPENDENT CARE SERVICE is a subset of one and only one SERVICE.
48. A CAFIEGIVER APPLICATION is completed by one and only one CAREGIVER. A
CAREGIVER completes one or many CAREGIVER APPLICATIONS.
49. A CAREGIVER APPLICATION lists one or many CAREGIVER JOB EXPERIENCES. A
CAREGIVER JOB EXPERIENCE is listed on one and only one CAREGIVER APPLICATION.
50. A CAREGIVER is a citizen of one and only one COUNTRY. A COUNTRY is the legal
residence of zero, one, or many CAREGIVERS.
51. A CAREGIVER possesses zero, one, or many CAREGIVER SKILLS. A CAREGIVER
SKILL is possessed by one and only one CAREGIVER.
52. A SKILL is possessed by zero, one, or many CAREGIVER SKILLS. A CAREGIVER SKILL
possesses one and only one SKILL.
53. An EMPLOYMENT CONTRACT defines one or many CAREGIVER SALARY
SCHEDULES. A CAREGIVER SALARY SCHEDULE is defined for one and only one
EMPLOYMENT CONTRACT.
54. An EMPLOYMENT CONTRACT defines one or many EMPLOYMENT CONTRACT
SERVICES. An EMPLOYMENT CONTRACT SERVICE is defined in one and only one
EMPLOYMENT CONTRACT.
55. A SERVICE is defined in zero, one, or many EMPLOYMENT CONTRACT SERVICES.
An EMPLOYMENT CONTRACT SERVICE defines one and only one SERVICE.
58. A CLIENT supports zero, one, or many DEPENDENTS. A DEPENDENT is supported
by one and only one CLIENT.