Database Reference
In-Depth Information
Identifiers
Show attribute ellipses for following identifiers, underlining the
attribute names within the ellipses:
PASSENGER: Passenger Number (or Record ID assigned)
AIRLINE: Airline Code (AA, BA, AI, etc.)
FLIGHT: Flight Number (preassigned)
Relationships
Indicate relationships, with diamond shapes, between FLIGHT
and AIRLINE, PASSENGER and FLIGHT.
Cardinalities
Number to show cardinalities at either side of the diamonds for
the above relationships.
Generalization/Specialization
None required.
Taking a Customer Order
Business Objects.
Show object boxes for CUSTOMER,
ORDER,
and
PRODUCT.
Attributes
Show attribute ellipses for characteristics of the above three objects.
Identifiers
Show attribute ellipses for the following identifiers, underlining the
attribute names within the ellipses:
CUSTOMER: Customer Number (system-assigned)
ORDER: Order Number
PRODUCT: Product ID (preassigned)
Relationships
Indicate relationships, with diamond shapes, between CUS-
TOMER and ORDER, ORDER and PRODUCT.
Cardinalities
Number to show cardinalities at either side of the diamonds for
the above relationships.
Generalization/Specialization
None required.
Student Registration
Business Objects
Show object boxes for STUDENT, COURSE, CLASS, and
TERM.
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:
STUDENT: Student ID or Social Security Number
COURSE: Course ID
CLASS: Class Number or Section Number
TERM: Semester ID
Relationships
Indicate relationships, with diamond shapes, between COURSE
and CLASS, TERM and COURSE, STUDENT and CLASS.
Cardinalities
Number to show cardinalities at either side of the diamonds for
the above relationships.
Generalization/Specialization
If necessary, show superset STUDENT and
subsets GRADUATE STUDENT and UNDERGRADUATE STUDENT.
Search WWH ::
Custom Search