Short ANSWER

1. A(n) ______ is an organized collection of information on a particular topic.

ANSWER:

2. Databases are based on information organized in ______.

ANSWER:

3. Column headings for a database table are called ______.

ANSWER:

4. When creating a database, you can ______ a field by specifying the field_name and the data_format.

ANSWER:

5. A(n) ______ is a unique identifier for any row in a database table.

ANSWER:

6. A(n) ______ makes use of the multiple tables of related information.

ANSWER:

7. The ______ operation takes rows from a table to create a new table.

ANSWER:

8. The ______ operation is used to combine information from two tables.

ANSWER:

9. The ______ operation combines two tables and removes the duplicate rows from the resulting table.

ANSWER:

10. The Join operation works by combining tables based on a(n) ______.

ANSWER:

11. The ________ is a collection of table definitions that gives the name of the table, lists the attributes and their data types, and identifies the primary key.

ANSWER:

12. A(n) ________ is a correspondence between two tables of a database.

ANSWER:

13. The physical database is designed by ________.

ANSWER:

14. The ________, or view of the database, is the form of the database the users see and is created on demand from existing information.

ANSWER:

15. The design of a(n) ________ database is guided by technical considerations, while the design of a(n) ________ database is guided by personal considerations of the users.

ANSWER:

16. ________ are the operations that transform a physical database into a logical one.

ANSWER:

17. The ________ defines the form of the information that can be stored in a field.

ANSWER:

18. Database ________ allow us to ask questions of a database in a way that lets the software find the answer for us.

ANSWER:

19. A(n) ________ is a database command defining a table expressed using the five database operators.

ANSWER:

20. An SQL ________ query can perform any or all of the operations on tables.

ANSWER: