Define database file, relational database, table, record, field, and key field.

A database file is define as a file that holds all related but organized collection of information on a unit. For example, in a medical practice, the “Doctors’ practice of anywhere” would store all of its data and information in a database file stored on a computer. Relational database is defined as organized assemblies of related data. Data in table is defined as a form of tabulation system within file that holds several related information. For example, one table might hold information on the doctors working for the “Doctors’ Practice of Anywhere”; another may hold information on its patients; and another my hold information on its insurance carriers. Record(s) in database is define as an account(s) that holds and stores all the information on one item in the table. For example, each patient has a record in the practice’s patient table. Fields is defined as a space that holds related piece of information about patient’s records. Key field is defined as a space that uniquely identifies each record in a table which cannot be replicated.