CIS CH 9 Databases

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

Data Type

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

integrity or accuracy

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

primary

To search a database for information, create a ___.

query

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

record

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

record

How is information artfully extracted from a database? - 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

Where could you click to switch to Design view?

view

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

Social Security Number Student number

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

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

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

relationship

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

Classnumber

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

query

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

reports

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. 1. pet table 2. owner table

1. Species Pet name Medicines 2.Street address Phone number 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?

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

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

Which of the following fields could be used as a primary key for a table? 1. Possible primary key 2. Ordinary field in the table

1. Voter registration number Social Security number Driver's license number 2. Street address City Last name Party affiliation

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

forms