Database CIS 1

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.Social security number Voter registration number Driver's license number 2.Street address Last name Party affiliation City

Select the advantages of using a database instead of a traditional filing system.

A database can hold larger amounts of data A database can provide improved data integrity

Select what's true about database fields

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

In the ClassList table, the primary key is probably the

Class number field

In 1984 Santa switched from using long lists to using

Database

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

primary key

pet table owner table

species perferred food pet name medicine

This much storage and management requires a complex

database

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

integrity

When do you need to link 2 tables in a database that don't have a field in common, one solution is to create a

Foreign key field in one table that links to the primary key in the other table

Look at the 1-to-many relationship above. This indicates that each driver can have many

Tickets

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

database

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

foreign

To create a relationship between 2 tables, it is necessary to create a

foreign key in one table that is primary key of the other table

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

forms

Reports provide a mean of artfully extracting information from database;

forms provide a means of accurately entering data into a database

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 a row of information is called a

record

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

reports

Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ___ System.

Management

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

Queries

The order in which data is organized in a database is( characters, fields, records, tables, files, database) is referred to the database

hierarchy

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

query

For this reasion she is using a relational

database instead of a list

A database that stores data in different physical locations and that users access though client/server networks is called a

distributed database

This is an example of how centralization can improve data

integirty

The above database use common fields to create links between tables. This is called a

relational database

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

relationship

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

Owner's last name Owner's address Pet's name

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

Because it can store virtually unlimited amounts of data that can be shared across networks, and because the data can be kept far more accurately, a

database has many advantages over a traditional filling system

Forms structure data input to help ensure data

inegirty, meaning the information entered s accurate, timely, and useful

When programmers design a database, they start by determining what data or characters will be entered. Next, they decide what fields would best organized this data. With this, records an tables can be created, eventually building an entire database . This organization is called the database

hierarchy

Traditional filling system Database Database

Requires no training to use Allows unlimited storage Allows greater data sharing