| WVNET Banner Support | ||
| WVNET Banner Support | ||
| Banner 7.x ERDs | |
| |
How do I read the Entity Relationship Diagrams (ERD) provided by SCT? I am not familiar with the symbols used. The Entity Relationship Diagrams (ERDs) were generated in SCT Banner enLighten by Cast. In SCT Banner enLighten by CAST, there are two types of links: Join and Refer. When you see a J, it indicates Join. When you see Rn, it means Refer(no action). In general, the "join" links are relationships that come from relationships that are found from the client code (Oracle Forms), not physically defined in the database. The links are imported into the database to help understand some of the "implied" links between tables or views in the database.A red arrow means an actual link and its direction indicates a "calling" relationship. At one end, the object is calling, at the other end, the object is called. Please also note that if you click on the link line or one of the notations on that line, the ERD will take you to the corresponding detail information in the report. The (O,n) markings are called cardinalities and arrows point from calling object to called object. These are used to show the relationships between the data in the tables. The cardinality determines the one-to-many types of entries that are either allowed or disallowed by the physical foreign key/primary keys that are defined in the database. What the cardinalities mean depends on whether the table is the parent or the child. Per the Banner enLighten online help: "On the "parent" side: The cardinalities show the minimum number (1st value) and the maximum number (2nd value) of existing records in the "child" table for each record of the "parent" table. The minimum cardinality is either '0' or '1'. '1' indicates that one of the "parent" table records cannot exist without a record in the "child" table. If not the value is '0'. The maximum cardinality is either '1' or 'n'. '1' is displayed when the columns of the foreign key in the "child" table have a unique condition (for example if a foreign key is also declared as the primary key of the "child" table, or if a unique index relates to the foreign key columns). On the "child" side: The cardinalities show the minimum number (1st value) and the maximum number (2nd value) of records in the "parent" table corresponding to one specific record in the "child" table. Since a primary key is unique, the maximal cardinality (2nd value) is always '1' (one record in the "child" table cannot have more than one parent). The minimum cardinality is either '0' or '1'. '1' indicates that there is always a parent for each record of the "child" table. '0' indicates that one record of the "child" table can exist without a parent (the foreign key columns can be null)." |
| Banner Support Home Page | | | Log a Problem | | | Forums | | | Links | | | Contact Us | |
WVNET | ph 304.293.5192 © 2003 WVNET 05/26/2006 |
|||||||||