Databases
MEMO TO THE STAFF (continued) The firm's database program manages a wealth of data concerning the company. An important database file you should know about is the customer order file. This file contains a record for each purchase. Each purchase record contains four fieldscustomer, item, price, and date of the purchase. Those of you in sales should find this file extremely useful for your planning and reporting.
WHAT DO YOU KNOW? Read the preceding memo. Using context clues, determine the meaning of each italicized word. Then, from the following list, select the word or phrase that best completes each sentence and write the word or phrase in the blank space provided.
database files |
fields |
records |
database program |
1 | Inside a database file are _______________ that contain related information such as a customer's orders or an employee's pay and deductions. |
A1:
| records. For example, your school probably keeps all your course grades in your student record, and your bank keeps a record of all the transactions for your checking account. A single order could be a record. |
2 | Records are composed of _______________. |
A2:
| fields. For example, a record of an order for a sweater might include fields for style, color, size, date of order, customer name, customer address, date shipped, price of item, tax, weight, shipping, and other related information. |
3 | We use a _______________ called DataKeep. |
A3:
| database program. The application that computers use to enter, sort, retrieve, analyze, and report the information in a database is a database program. |
4: | Facts and figures are contained in ________________. |
|
TERMS RELATED TO DATABASES database file sometimes called just a database; a collection of data that can be organized in various waysdatabase program a software application that allows a user to enter and organize data, retrieve it, and report itrecord part of a database file containing information about one transaction, one employee, one customer, and so onfield part of a record in which a particular type of data is stored, such as name, date, size, and so on |
|