HP 3000 Manuals

Identifying Relationships between Entities [ Up and Running with ALLBASE/SQL ] MPE/iX 5.0 Documentation


Up and Running with ALLBASE/SQL

Identifying Relationships between Entities 

After subdividing the data by entities, the next step of design is to
identify meaningful relationships between the entities described so far.
For each relationship you identify, an attribute or group of attributes
must support the relationship.

What are the relationships among the entities in the sample data?  For
the Album and Selection entities, there is a relationship of Content,
that is, each album contains a specific group of selections.  For the
Composer and Selection entities, the relationship is one of Authorship;
each composer has created one or more selections.

Another kind of relationship exists between Selection and Composer,
namely, Period.  The attributes that define Period are the composer's
"Name" and "Birth Date."



MPE/iX 5.0 Documentation