Database diagrams
Database diagrams provide information on database tables, fields, and logical relation­ships between tables.
The rectangular objects with heading depict database tables, where the heading contains the name of the table (e.g. “NUCLIDE”).
The rows under the heading list the data fields in a specific table (e.g. “A” or “Z” means mass number and proton number for a specific nuclide.
The graphical symbol before the field name shows additional information about a field.
 
Regular data field.
 
Primary key data field; all primary keys together will uniquely identify the record.
 
Foreign key data field; references to a record of another table.
 
One-to-many relationship; depicts that many records of the second table may have reference to the same record of the first table.
In our example this means that more nuclear level entries may refer to the same nuclide.
 
 
Copyright © 1998-2007 by HyperLabs Software Budapest, Hungary