7.1 Read and translate the following words and word-combinations.

a collection of data, the database capabilities, computerized filing cabinets, sophisticated multiple-file systems, handle basic tasks, a general example, a set of records, a preidentified sequence, ZIP code, the entire contents, to meet the criterion, a specific record.

1.2    Learn key words and word-combinations.

database (n) – база даних

database management system – СКБД (система керування базою даних)

database manager – адміністратор бази даних

database program – програма бази даних

database software – програмні засоби бази даних

field (n) – поле

file manager – програма керування файлами

format (v) – форматувати

personal information manager – адміністратор особистої інформації

record (n) – запис

record structure – структура запису

report generator – генератор звітів

7.3 Read and translate the text.

DATABASE SOFTWARE

A database is a collection of data, a structure, and programs that can manage and manipulate the data and its structure. The database capabilities for personal computers vary widely. Very simple databases are nothing more than computerized filing cabinets. Sophisti­cated multiple-file systems are suitable for organizing large amounts of informa­tion and retrieving that information in many different ways.

Database software for personal com­puters falls into two categories:

• A file manager is composed of a single file, its indexes, and a program to handle basic tasks such as entering, modifying, retrieving, and printing data from the file.

• A database manager is composed of multiple files, their indexes, the relationships among data in the files, and a program to link the files and handle basic tasks such as entering, modifying, retrieving, and printing data from the file.

. A database program derives much of its power through the ability to perform three simple tasks: sorting, searching, and generating reports. To show how a database program allows you to perform these tasks, it is helpful to look at a general example. Almost all businesses keep a set of records known as a cus­tomer list. In its simplest form, it might be a file, in which each record is a card that contains a customer's name, address, and phone number. A more complex example might include a record for each cus­tomer that contains enough information to generate all the company's billing in­formation.

Suppose that the customer list data­base is made up of one record for each customer, which includes the previously mentioned customer information along with some general information about the customer's purchases. Sorting, which involves arranging the records into a predeidentified sequence, makes it possible to generate a list sorted by cus­tomer number, alphabetically by cus­tomer name, by ZIP code for mailing purposes, or even by items purchased. Sorting a database also makes it possible to search and generate reports in various sequences. For example, you can sort a database alphabetically by customer name to print a report and then sort the database by ZIP code to generate and print mailing labels in ZIP code order.

Searching involves the ability to find information in a database. This might include a most general case in which you want to list the entire contents of a data­base on the computer's display screen or a special case in which you want to search for a specific record or set of records. For example, if you want to know the name of every customer who purchased more than $10,000 worth of goods last year, you could search the customer list database to display only those customers who meet the crite­rion—more than $10,000 in sales.

A report generator allows you to cre­ate nicely formatted reports, including headings, subheadings, columns of data from the database, columns of data com­puted from existing fields in the data­base, and computed intermediate and final totals. Once the format of the report has been defined, it can be saved as a file on a disk and used over and over again to print copies of the report.

. A class of software similar to database programs is called personal informa­tion managers. Like databases, these programs help you manage information. Unlike databases, they can manage infor­mation without using the record and field structure common to databases. You do not have to think about the struc­ture of your data ahead of time. For example, you can use a personal infor­mation manager to type in notes about a project you are working on, then filter through the notes and reorganize them by categories of your own choosing.

1.4    Give English equivalents.

упорядковувати базу даних в алфавітному порядку, знаходити інформацію в базі даних, керувати даними та їхньою структурою, складні системи файлів, керувати основними завданнями, з’єднувати файли, відповідати критерію, визначити формат звіту, заздалегідь, за власним вибором, друкувати звіт, вводити дані, вилучати дані

1.5    Answer the questions.

1.                   What is a database?

2.                   Which tasks can be performed by using a database? Make a list of possible applications.

3.                   What do these terms mean in Ukrainian: file, record, field?

4.                   What is personal information manager?

5.                   What stages can be defined while working with database?