1. Terminology: For each description below, give the appropriate term to match the description (Hint: Remember terms are bolded in the text).

1. There is a table that lists the different stores a retail location operations and different attributes about each store is contained in a column of the table. One of these attributes is location and another lists the date the store was first opened.
2. Employees are listed in a payroll database. There is a field that contains numbers that the employees are given upon hire, and no two employees have the same number.
3. Someone writes code that will search the database to tell their boss how many deliveries they have made to Hawaii in the past month.
4. In a hospital database, there is a patient table, and every line in the table contains information from a patient.
5. A firm has a policy that only gives permission to alter or change data already stored in the database
6. A field in a table listing delivery addresses has numbers that uniquely identify which customer is attached to the delivery.

Bolded words are- Database, Table, records, fields, Primary key, Foreign key, Database Management System, Microsoft Access, and Query

little more info

It is typical for information to be stored in a database. A database consists of sets of related information. Each of these sets of information is called a table. A table is organized into rows called records and columns called fields.