Database Topics


Entity Relationship Diagrams


Anomalies  = modification anomalies = deletion anomalies and/or insertion anomalies

  • Referential integrity = ensuring that the records in related tables are consistent with one another
  • Total Query (QBE Design view grid) performs calculations on a group of records using one of the summary (aggregate) functions.  (Group by)
  • Indexes should be specified for any criteria field in a query, as well as for any field that is used in a relationship to join two tables