Database

5. clause is used to filter records
6. an organized collection of data
8. clause is used to combine rows from two or more tables, based on a related column between them
11. A structured method of asking a set of structured data to produce only those fields from a record that answer a question
12. A database in which inter-table relationships are organized primarily through common data columns, which define a one-to-many relationship between a row of the primary key table and one or more rows of the matching foreign key table
15. Sorting data the opposite of ascending order. (Z-A & 9-0)

1. statement is used to choose data from a database
2. A column in a database table where a specific piece of data will be entered and live. For example, an entry for patient temperature would be entered into the temperature field or column. In databases a field may be referred to as an attribute. In word processing this term describes data inserted into a mail merge document, for example a city
3. a field chosen to identify each record in a table
4. statement is used to remove existing records in a table
7. registering and monitoring users, enforcing data security, monitoring performance, maintaining data integrity dealing with concurrency control, and recovering information that has been corrupted by some event such as an unexpected system failure
9. The word used to indicate that a field in a record is empty
10. The chief structure of a database. It contains data pertaining to a single subject
13. data structure that a database uses to reduce the amount of time it takes to perform certain operations
14. Information about the subject of the table. Seen as a row in a table