Database Concepts - Final Exam B

1. Redundancy refers to what database condition?

The same data is recorded in more than one place in the same database.

You have more than one database devoted to the same thing.

2. Which statement best describes the function of a primary key?

It uniquely identifies each record.

3. Which statement best describes the function of a foreign key?

A foreign key is the primary key of one table repeated in another table in order to create a relationship between the tables.

4. What is SQL?

It is the language relational databases use to create database objects and to manipulate and retrieve data.

5. A database entity can best be described as _____________.

something the database is concerned with about for which data can be stored

6. Which of the following best defines the term “database requirement”?

Something a database must do to fulfill its business function

7. Which of these best defines “data integrity”?

The accuracy and correctness of the data in the database

8. A document that has the primary purpose of summarizing and displaying data is called a _____.

report

9. The focus of a database, the business problem it is designed to solve, is called _____.

the domain of the database

10. Observing people at work to see how they interact with the data is called _____.

work shadowing

11. An attribute or combination of attributes that could be used as the primary key for an entity is a ___________.

candidate key

12. A key that consists of two or more attributes combined to make a unique value is called a _______.

composite key

13. Which of the following statements is an advantage of a natural key?

A natural key helps protect data integrity by preventing accidental entry of duplicate rows.

14. A natural key is __________.

an