Databases

Databases

1. Tables

   • Stores all of the records for a particular category

2. Records

   • Is all of the data or information about an entity

3. Fields

   • One piece of data or information about an entity

4. Data types

   • Alphanumeric or Text
   • Number
   • Currency
   • Date/Time
   • Autonumber
   • Boolean

5. Field length

   • The length of characters that are allowed in each field

6. Primary key

   • Unique identifier for each record

7. Foreign key

   • Creates a relationship between the tables in which matching primary keys are present

8. Referential integrity

   • Uses the values of a foreign key to ensure there are no orphan records