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

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

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

integrity

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

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

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

forms

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