Wednesday, March 9, 2011

HW #1: Read p. 224-232 and do 4RQs

1. Define or describe each of the key terms listed in the "Key Terms" section. Check your answers in the glossary.
-browse: the process of finding information in a data base or other data source, such as the World Wide Web.
-computed fields
-database: a collection of information stored in an organized form in a computer.
-database program: a software tool for organizing the storage and retrieval of the information in the database.
-field: each discrete chunk of information in a database record
-export data: transmitting records and fields from a database program to another program
-import data: to move data into a program from another program or source.
-query: an information request
record: in a database, the information relating to one person, product, or event.
-query language: a special language for performing queries
report: a database printout that is an ordered list of selected records and fields in a an easy to read form
search: looking for a specific record
select record: looking for all records that match criteria
sort: arrange records in alphabetical or numeric order
SQL: a query language available for different data management systems.
table:   a grid of rows and columns; on many Web pages tables with hidden grids are used to align graphical images.
2. What is the difference between a file manager and a data-base management system? How are they similar?
A file management is where hard copies of the files are managed in a storage or file cabinet. A database management is something that can accessed via a computer. They both retrieve information such as names, numbers, prices.
3. What is a query? Give example of the kinds of questions that might be answered with a query.
An information request is a query. A query can be a specific search like (GeorgeWashington) or it can request to select all information that match the criteria.
4. Describe the structure of a simple database using the terms file, record, and field in the description.
Databases are made up of table which are made up of records which are made up of fields.

No comments:

Post a Comment