Database Quiz a

Your college has a database with a Students table. Which of the following could be a primary key in the table?

- Student number - Social Security Number - Street address - Last name

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using _____.

Databases

In a database a _____ is a group of related characters in a database table that represents a characteristics of someone or something.

Field

To control how information is entered into a database, programmers and database administrators create ___ to help ensure data integrity.

Forms

Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ___ .

Integrity

The DBMS engine provides an interface for the end user of the database. This interface is called the ____ view.

Logical

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ___ subsystem.

Manipulation

In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ___ .

Record

A link between tables in a relational database that defines how the data is related is called a ______.

Relationship