Module 9 Notes

Commercial

Large databases often called data banks, that cover particular subjects are referred to as

- Driver's License Number - Voter Registration Number - Social Security Number

Primary key

Databases

The national gallery of art in Washington dc has nearly 100,000 pieces in its collection. to organize its collection it uses a relational ___ so that curators can locate specific pieces

Query

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

Database

Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ___ .

Database

Becky wants to organize and sort her wedding invitation list according to groom's guests, bride's guests, out-of-town guests, and estimated wedding gift value. For this reason she is using a relational ____ instead of list.

Hierarchy

Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ____

Record

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

Integrity

Katrina was a senior in college when she married her high school sweetheart. She changed her last name, and because the college used a centralized database, each of her instructors had her new name in their grade books. This is an example of how centralization can improve data ____

- Last Name - Street address - City - Party Affiliation

Ordinary Fields

Integrity

The reliability and the accuracy of the information in a database is referred to as data

Forms

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

Foreign

To create a relationship between 2 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 a summary of data and archive snapshots of the data, data administrators or programmers create:

Database

To organize the different tables of data, the local police force probably uses the relational ______

Data Type

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

- Represents a characteristic of someone or something - A group of related characters in a database table

What is true about Database fields?