Ch.7 Review Questions (3/7) [LATE]

1.Define or describe each of the key terms listed in the "Key Terms" section. Check your answers in the glossary. 

database: data structure that stores organized information
database program: software for storing and retrieving  information in a database
table: information organized into rows and columns
record: group of fields that make up one complete entry
field: an individual mass of information in a database
field type: type of field determining the type of information for that field
numeric field: field containing only numbers
date field: field containing only dates
computed fields: field containing formulas
browse: finding information within a database
query: requesting information from a database.
search: looking for a specific record
select:  searching for records that meet a certain set of criteria
import data: moving data into a program from another program or source
report:  database printout of selected records and fields in an ordered list
export data: transmitting data from one program to another
query language: special language for queries
SQL: Structured Query Language; query language for various DBMS

2. What is the difference between a file manager and a database management system? How are they similar?
Both allow a user to input data, but the file manager only permits the user to work with one file, while a DBMS allows the user to work with a large collection of data.

3. Describe the structure of a simple database. Use the terms file, record, and field in your description.
 A simple database would be made up of tables, which would consist of rows and columns.  A data table is made up of a collection of records- a group of fields of a specific category.A collection of data tables would create a file.

4. What is a query? Give examples of the kinds of questions that might be answered with a query.
A query is a certain information request within a database. Questions within a query may be like  a certain request for books on soccer in a library catalog.