Physical Foreign Key
18 May 1996 updated
Issues:
Role-named foreign keys
- Optionally show foreign keys on the CDM. In addition, allow some flexibility
in naming these foreign keys in the CDM. Concatenating the first part of
the table during physical generation leaves much to be desired.
Foreign key hierarchy tree
- A graphical decomposition view (hierarchical tree structure) in the
physical model that shows the relation of a row of data to its foreign
keys. For example, this would be useful in understanding relationships
in a headers, detail record relationship a purchasing organization might
have.
Where to go from here:
© © 1996
Applied Information Science International