A relational database provides three main levels of data storage: field, record, and table. A field stores a single piece of data such as a last name or a salary.
A record stores a record of related fields. For example, a record might store fields giving a particular employee’s name, address, phone number, job title, and salary.
A table holds a collection of records that all contain the same kinds of fields. For instance, a table named Employees would hold records containing data for all the company’s employees. Each record would contain the same fields (FirstName, LastName, Street, and so forth), though the fields would have different values in different records.
A physical analogy to this structure is a filing room. ...