| Entities | ||||||||
|
Entities Anything about which data is stored is called an entity. There is a standard way of writing down the design of an entity: The entity name is shown in capital letters, followed by the fields in brackets. The key field is identified by underlining it. Example :
Any foreign fields would be shown in italics (or overlined). A foreign field is a keyfield from another table - and provides a link between the two tables. Example :
|
||||||||
|
Entity Relationship Diagrams An entity-relationship diagram shows the links between tables. These relationships can be...
|
||||||||
 |
||||||||
