Database Concepts for the Systems Analyst
Fields
- There are four types of fields that can be stored: primary keys, secondary keys, foreign keys, and descriptive fields. (continued)
- Foreign keys are pointers to the records of a different file in a database.
- Foreign keys are how the database ‘links’ the records of one type to those of another type.
- Descriptive fields are any other fields that store business data.