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