Show TOC

Function documentationViewing and Validating Databases

 

Before learning how to troubleshoot a database, it is first necessary to understand a few basics of what a database is. The very basic definition is “a collection of data”. Databases are made up of files, records, and fields.

  • File: It is a file in which data of a certain type is kept. For example, the PLU database holds all of the data referencing sku numbers, their individual prices, and so forth.

  • Records: Normally, the data within each file is divided up into ‘records’. Each record contains information related to a certain item. For example, we can look at a phonebook as a database. The phonebook is a collection of data all related to phone numbers. Individual records in the phonebook are the information related to each individual phone number - a person’s name, address, and so forth.

  • Fields: Each record can further be broken down into ‘fields’. A field is an entry in a record. For example, the ‘name’ field in our phonebook contains the person’s name who owns a particular number.