Wrap-Up

Fill in the blanks in each of the following:

1. Computers store large amounts of data on secondary storage devices as__________.
2. A(n)__________is composed of several fields.
3. To facilitate the retrieval of specific records from a file, one field in each record is chosen as a__________.
4. The vast majority of information stored in computer systems is stored in__________files.
5. A group of related characters that conveys meaning is called a(n)__________.
6. The standard stream objects declared by header are__________,__________,__________and__________.
7. ostream member function__________outputs a character to the specified stream.
8. ostream member function__________is generally used to write data to a randomly accessed file.
9. istream member function__________repositions the file-position pointer in a file.

State which of the following are true and which are false. If false, explain why.

1. The impressive functions performed by computers essentially involve the manipulation of zeros and ones.
2. People prefer to manipulate bits instead of characters and fields because bits are more compact.
3. People specify programs and data items as characters; computers then manipulate and process these characters as groups of zeros and ones.
4. A person's 5-digit zip code is an example of a numeric field.
5. A person's street address is generally considered to be an alphabetic field in computer applications.
6. Data items represented in computers form a data hierarchy in which data items become larger and more complex as we progress from fields to characters to bits, etc.
7. A record key identifies a record as belonging to a particular field.
8. Most organizations store all information in a single file to facilitate computer processing.
9. When a program creates a file, the file is automatically retained by the computer for future reference; i.e., files are said to be persistent.

Exercise 17.3 asked the reader to write a series of single statements. Actually, these statements form the core of an important type of file-processing program, namely, a file-matching program. In commercial data processing, it is common to have several files in each application system. In an accounts-receivable system, for example, there is generally a master file containing detailed information about each customer, such as the customer's name, address, telephone number, outstanding balance, credit limit, discount terms, contract arrangements and, possibly, a condensed history of recent purchases and cash payments.

As transactions occur (e.g., sales are made and cash payments arrive), they are entered into a file. At the end of each business period (a month for some companies, a week for others and a day in some cases), the file of transactions (called trans.dat in Exercise 17.3) is applied to the master file (called oldmast.dat in Exercise 17.3), thus updating each account's record of purchases and payments. During an updating run, the master file is rewritten as a new file (newmast.dat), which is then used at the end of the next business period to begin the updating process again.

File-matching programs must deal with certain problems that do not exist in single-file programs. For example, a match does not always occur. A customer on the master file might not have made any purchases or cash payments in the current business period, and therefore no record for this customer will appear on the transaction file. Similarly, a customer who did make some purchases or cash payments may have just moved to this community, and the company may not have had a chance to create a master record for this customer.

Use the statements from Exercise 17.3 as a basis for writing a complete file-matching accounts-receivable program. Use the account number on each file as the record key for matching purposes. Assume that each file is a sequential file with records stored in increasing order by account number.

When a match occurs (i.e., records with the same account number appear on both the master and transaction files), add the dollar amount on the transaction file to the current balance on the master file, and write the newmast.dat record. (Assume purchases are indicated by positive amounts on the transaction file and payments are indicated by negative amounts.) When there is a master record for a particular account but no corresponding transaction record, merely write the master record to newmast.dat. When there is a transaction record but no corresponding master record, print the error message "Unmatched transaction record for account number ..." (fill in the account number from the transaction record).

After writing the program of Exercise 17.7, write a simple program to create some test data for checking out the program. Use the following sample account data:

Run the program of Exercise 17.7, using the files of test data created in Exercise 17.8. Print the new master file. Check that the accounts have been updated correctly.

It is possible (actually common) to have several transaction records with the same record key. This occurs because a particular customer might make several purchases and cash payments during a business period. Rewrite your accounts-receivable file-matching program of Exercise 17.7 to provide for the possibility of handling several transaction records with the same record key. Modify the test data of Exercise 17.8 to include the following additional transaction records:

Write a series of statements that accomplish each of the following. Assume that we have defined class Person that contains private data members

char lastName[ 15 ]; char firstName[ 15 ]; char age[ 4 ];  

and public member functions

// accessor functions for lastName void setLastName( string ); string getLastName() const; // accessor functions for firstName void setFirstName( string ); string getFirstName() const; // accessor functions for age void setAge( string ); string getAge() const;  

Also assume that any random-access files have been opened properly.

1. Initialize the file nameage.dat with 100 records that store values lastName = "unassigned", firstName = "" and age = "0".
2. Input 10 last names, first names and ages, and write them to the file.
3. Update a record that already contains information. If the record does not contain information, inform the user "No info".
4. Delete a record that contains information by reinitializing that particular record.

You are the owner of a hardware store and need to keep an inventory that can tell you what different tools you have, how many of each you have on hand and the cost of each one. Write a program that initializes the random-access file hardware.dat to 100 empty records, lets you input the data concerning each tool, enables you to list all your tools, lets you delete a record for a tool that you no longer have and lets you update any information in the file. The tool identification number should be the record number. Use the following information to start your file:

(Telephone Number Word Generator) Standard telephone keypads contain the digits 0 through 9. The numbers 2 through 9 each have three letters associated with them, as is indicated by the following table:

Many people find it difficult to memorize phone numbers, so they use the correspondence between digits and letters to develop seven-letter words that correspond to their phone numbers. For example, a person whose telephone number is 686-2377 might use the correspondence indicated in the above table to develop the seven-letter word "NUMBERS."

Businesses frequently attempt to get telephone numbers that are easy for their clients to remember. If a business can advertise a simple word for its customers to dial, then no doubt the business will receive a few more calls.

Each seven-letter word corresponds to exactly one seven-digit telephone number. The restaurant wishing to increase its take-home business could surely do so with the number 825-3688 (i.e., "TAKEOUT").

Each seven-digit phone number corresponds to many separate seven-letter words. Unfortunately, most of these represent unrecognizable juxtapositions of letters. It is possible, however, that the owner of a barber shop would be pleased to know that the shop's telephone number, 424-7288, corresponds to "HAIRCUT." The owner of a liquor store would, no doubt, be delighted to find that the store's telephone number, 233-7226, corresponds to "BEERCAN." A veterinarian with the phone number 738-2273 would be pleased to know that the number corresponds to the letters "PETCARE."

Write a C++ program that, given a seven-digit number, writes to a file every possible seven-letter word corresponding to that number. There are 2187 (3 to the seventh power) such words. Avoid phone numbers with the digits 0 and 1.

Write a program that uses the sizeof operator to determine the sizes in bytes of the various data types on your computer system. Write the results to the file datasize.dat, so that you may print the results later. The results should be displayed in two-column format with the type name in the left column and the size of the type in right column, as in:

[Note: The sizes of the built-in data types on your computer might differ from those listed above.]