Databases

Data Type

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

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

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

Social Security Number Student number

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

relationship

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

reports

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

integrity or accuracy

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

record, records, Record, or Records

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

Classnumber

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

record

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

Pets

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 ___.

forms

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

foreign, foreign key, or fk

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.

reports

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

query

To search a database for information, create a ___.

Possible primary key

Voter registration number Social Security number Driver's license number

foreign key

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

View

Where could you click to switch to Design view?

Street address Phone number Last name

You opened a pet care business and decided to create a database with two tables. One table has data on the pets and the other table contains data about the owners. You create a one-to-many relationship between the tables since one owner can have more than one pet. Place the following fields in the correct table. Owner Table

Species Pet name Medicines

You opened a pet care business and decided to create a database with two tables. One table has data on the pets and the other table contains data about the owners. You create a one-to-many relationship between the tables since one owner can have more than one pet. Place the following fields in the correct table. Pet Table

primary

In a relational database, an important field that contains a unique value that identifies each record as individual is ______________ key.

query

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

foreign, foreign key, or fk

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

FK OwnerID

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

Ordinary field in the table

Street address City Last name Party affiliation

queries

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