OBJECT-BASED DATA MODEL: PRINCIPLES AND COMPONENTS - Database Design and Development: An Essential Guide for IT Professionals - page 170

Product Inventory Verification

Business Objects Show object boxes for PRODUCT, PRODUCT LINE,

DEPARTMENT, and WAREHOUSE.
Attributes Show attribute ellipses for characteristics of the above four objects.
Identifiers Show attribute ellipses for the following identifiers, underlining the
attribute names within the ellipses:
PRODUCT: Product ID
PRODUCT LINE: Product Line Number
DEPARTMENT: Department Code
WAREHOUSE: Warehouse ID
Relationships Indicate relationships, with diamond shapes, between DEPART-
MENT and PRODUCT LINE, PRODUCT LINE and PRODUCT, WARE-
HOUSE and PRODUCT.
Cardinalities Number to show cardinalities at either side of the diamonds for
the above relationships.
Generalization/Specialization

None required.

Patient Service at Doctor's Office

Business Objects Show object boxes for PHYSICIAN, PATIENT, DIAGNO-
SIS, and TREATMENT.
Attributes

Show attribute ellipses for characteristics of the above four

objects.
Identifiers Show attribute ellipses for following identifiers, underlining the
attribute names within the ellipses:
PHYSICIAN: Social Security Number or Certification Number
PATIENT: Patient Number (assigned)
DIAGNOSIS: Diagnostic Code
TREATMENT: Procedure ID
Relationships Indicate relationships, with diamond shapes, between PHYSI-
CIAN and PATIENT, PATIENT and DIAGNOSIS, PATIENT and TREAT-
MENT.
Cardinalities Number to show cardinalities at either side of the diamonds for
the above relationships.
Generalization/Specialization None required.

Deposit to Checking Account

Business Objects Show object boxes for ACCOUNT, CHECKING ACCOUNT,
CUSTOMER, and DEPOSIT.
Attributes Show attribute ellipses for characteristics of the above four objects.
Identifiers Show attribute ellipses for following identifiers, underlining the
attribute names within the ellipses:
ACCOUNT: Account Number
CHECKING ACCOUNT: Account Number