REAL Modeling Diagram

To document relationships between each REAL attribute, we use cardinals. There are four types of cardinals that we use. Each of them corresponds to each questions asked below:

1. For each X, what is the minimum value of Y involved?
2. For each X, what is the maximum value of Y involved?
3. For each Y, what is the minimum value of X involved?
4. For each Y, what is the maximum value of X involved?

We document the cardinals in these format:
Attribute 1 -------------------------------------------- Attribute 2
                 (1(Ymin),2(Ymax))        (3(Xmin),4(Xmax))

Each diagram below represent the attributes of REAL model inside each of SDE's department:
(number inside corresponds to table number)