Tag: database

Structures and links (database)

  • Database structure: field, record, file
  • Database structure: flat file, linked tables, primary keys, foreign keys
  • Field types (text, numbers, date, time, graphic, object, calculated, link, boolean)
  • Validation (presence check, restricted choice, field length, range)
  • Database operations search, sort (on multiple fields)
  • Good design to avoid data duplication and modification errors (insert, delete, update)

Read more