Databases

In the ClassList table, the primary key is likely the __ field.

Classnumber

Pet table

Species Pet name Medicines

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

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a

record

Where could you click to switch to Design view?

view

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

Data Type

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

FK OwnerID

You own a pet care center. Which three fields you might enter when you create a table for the dogs that you care for?

Owner's phone number Pet's name Owner's last name

Ordinary field in the table

Street address City Last name Party affiliation

Owner table

Street address Phone number Last name

Possible primary key

Voter registration number Social Security number Driver's license number

When you need to link two tables in a database that do not have a field in common, one solution is to create a ___.

foreign key

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

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 search a database for information, create a ___.

query

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 are related is called a _____.

relationship

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

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