Term
|
Definition
Finds specific records that match certain conditions
Keeps accurate records of almost any type
Sorts records quickly and accurately
Can easily change the sort order
Are an excellent way to organize information
Can add, delete, or edit data easily |
|
|
Term
|
Definition
Automated library system
Electronic dictionaries
Electronic mailing list
CD-ROM encyclopedia
School calendar
Student planner
Telephone book
Overall inventory
Get airline tickets
|
|
|
Term
A travel agent would use a database to
|
|
Definition
| get airline schedules for clients |
|
|
Term
| A database students might use is |
|
Definition
|
|
Term
| A grocery store might use an electronic database to |
|
Definition
| keep track of overall inventory |
|
|
Term
A computerized database in the school media center could eliminate
|
|
Definition
|
|
Term
| Database advantages include: |
|
Definition
speed
can be easily organized
organize your information
search to find specific records
sort information alphabetically or numerically |
|
|
Term
| Database Application Software |
|
Definition
An application software program that organizes and stores information that can be easily sorted
Data can be added or updated easily
Data can be easily searched and sorted that matches certain criteria
Specific information can be retrieved from organized data |
|
|
Term
| A school might use an electronic database to |
|
Definition
| maintain an accurate list of students |
|
|
Term
| A student might use an electronic database to |
|
Definition
| keep track of friend's names and addresses |
|
|
Term
| A doctor's office might use an electronic database to |
|
Definition
| keep track of patient appointments |
|
|
Term
| A business might use a database to |
|
Definition
keep an appointment calendar with patients or customers
Keep inventory up to date
Maintain a list of loyal customers |
|
|
Term
|
Definition
An item of information in a database
One piece or item of information in a database
Can be made in any order and sorted |
|
|
Term
Four parts of a database in ascending order are
|
|
Definition
Entry, which goes into a
Field, which goes into a
Record, which becomes a
Database file or table. |
|
|
Term
| To find a specific entry in a record in a database, you would |
|
Definition
|
|
Term
|
Definition
From the most expensive to the cheapest
From Z to A order
From highest number to the lowest
From greatest to least
From oldest to youngest |
|
|
Term
|
Definition
a collection or group of related records in a database
This includes all of the entries in the
fields or categories in the
records.
This is the entire file. |
|
|
Term
|
Definition
From the least expensive to the most
From A to Z order
From lowest number to the highest
From least to greatest
From youngest to oldest |
|
|
Term
| If you had a database of names and phone numbers, what would LAST NAME, FIRST NAME, and PHONE NUMBER be examples of? |
|
Definition
Fields
Fields are categories of information put into a database.
Fields together with entries make up a record, which make up a database file. |
|
|
Term
| A set of related records in a database is known as a |
|
Definition
|
|
Term
| An electronic database could be compared to a |
|
Definition
|
|
Term
| An example of a computerized database program found in a school would be an |
|
Definition
|
|
Term
|
Definition
| A character used to take the place of an unknown |
|
|
Term
| Mathematical Symbols are: |
|
Definition
=> equal to or greater than
> less than
< greater than
=< equal to or less than
= equal
<> not equal to
|
|
|
Term
|
Definition
And/Or used while filtering, querying, or searching for very specific information
And means it has to have all the characteristics you are seeking
Or means it has to have one or more of the characteristics you are seeking |
|
|
Term
| To put data in a particular order, you would |
|
Definition
|
|
Term
| Words related to databases, include |
|
Definition
Data and sort
Entries and Fields
Search and Query (question) |
|
|
Term
|
Definition
Records are ALL the information about one person, place, or thing.
Entries go into
Fields which make up
Records
A group of related fields with entries in them. |
|
|
Term
| When creating a database about African countries, what type of field would the square miles be? |
|
Definition
| Number because mile are expressed in numbers. |
|
|
Term
| Saving a newly created database involves: |
|
Definition
Designating the drive where you want it saved
Telling the computer to save it
Naming the file |
|
|
Term
| A database will help a user |
|
Definition
access information quickly
locate specific data
organize information |
|
|
Term
Entry types in a database
|
|
Definition
Text for words
Numbers for numerical information
Logical for simple yes or no answers
Date |
|
|
Term
| When creating a database is |
|
Definition
Determine its purpose
Create it--set up your fields and categories
Fill in the entries
Save it |
|
|
Term
|
Definition
| what you set up when creating a database to hold the entries |
|
|
Term
| An art club at school can keep track of all its members by |
|
Definition
| Creating a database to organize member information |
|
|
Term
|
Definition
| the process of removal or insertion of text in a database |
|
|
Term
|
Definition
| displays records that meet a specific criteria from a database |
|
|
Term
| To locate all of the students who were born on 08/29/20xx, you would |
|
Definition
|
|
Term
|
Definition
(Querying is another word for questioning)
Retrieving information in a database using specific criteria |
|
|
Term
| What would you do first to generate a hard copy of a database of North Carolina? |
|
Definition
| You would need to retrieve the file. |
|
|
Term
| Which is NOT an operator to be used in a query (question)? |
|
Definition
|
|
Term
| To find the students in your math class that made a final grade average of at least a 93? |
|
Definition
| Perform a search of all records that have => 93 in the grade field |
|
|
Term
| How would you find the phone number of one particular students from 500 names and addresses of students enrolled at your school? |
|
Definition
| Perform a search using the student's name as the criteria |
|
|
Term
|
Definition
| Changes a record in a database |
|
|
Term
|
Definition
| Arranging the data in a field in alphabetical order. |
|
|
Term
How would a guidance counselor generate a listing of all the 7th grade girls from the school database?
|
|
Definition
|
|
Term
| To find out which employee earns the most per hour, you would |
|
Definition
|
|
Term
| To get to a previously saved database, you must |
|
Definition
|
|
