cis 1A Concepts Databases

Which of the following fields could be used as a primary key for a table? Possible primary key matches: Ordinary field in the table matches:

Possible primary key matches -Voter registration number -Social Security number -Driver's license number Ordinary field in the table matches -Street address -City -Last name -Party affiliation

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ______ key.

foreign

To create a relationship between two tables, it is necessary to create a ______ key in one table that is the primary key of the other table.

foreign

Where could you click to switch to Design view?

view

In the two tables in the image, which field is a foreign key?

FK OwnerID

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

forms

Forms structure data input to help ensure data______ , meaning the information entered is accurate, timely, and useful.

integrity

In the relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many relationship. This means that each entry in the OwnerID field can be linked to many ___.

pets

So that users can find specific information quickly by using filters based on specific criteria, databases allow the creation of ___.

queries

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

relationships

Forms allow data to go into a database, ___ display information coming out of a database.

reports

To display or distribute information from a database, programmers or database administrators create ___.

reports

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a _________ .

query