Материал: Unit 5
Unit 5
Setting up (Data – Base – Management System)
1. Read and memorize the following words:
Field – поле; current – поточний;
Entry – вхід, внесення; to expand – розширювати;
Turning – вмикання; to shorten – скорочувати;
Subject – тема; to accompany – супроводити;
Record – запис; to eliminate – видаляти;
Title – заголовок; duplicate – копія, дублікат;
Movie – кадр; related - пов’язаний;
Character – символ, знак, буква.
2. Name the word – building elements (suffixes, prefixes) and parts of speech the refer to. Translate them into Ukrainian.
To combine – combination – combined;
To manage – manager – management;
To computerize – computerization – computerized – non computerized;
Possible – impossible – possibility – impossibility;
To charge – discharge – chargeable;
To relate – relation – related – relationship;
Identification – to Identify;
To count – countable – uncountable;
Character – to character – characteristically – characteristic;
To describe – description – describing.
3.State which of the given words are the terms (jargon). Make up possible word-combinations or sentences with them:
Title, subject, access, microcomputer, category, jargon, catalogue, movie, record, field, memory, game, storage, device, terminology, documentation, program, work.
4. Match the parts of word combinations, paying attention to the meaning of new words.
To have a) a DBM system
To set up b) access to a microcomputer
To eliminate c) title and subject cards
To combine d) duplicate records
To consist of e) two files
To identify f) eleven fields.
5. Read the following word-combinations with the new words and guess their meaning. Give the Ukrainian equivalents:
Subject catalogue; related records; to eliminate duplicate records; current data base; type of movie; movie title; entry of letters, numbers or characters; to shorten the description of the movies.
6.Read the text to understand particular terms related with the stages of setting up a DBMS.
SETTING UP A DBMS (Data-Base-Management-System)
Now that you know the advantages of electronic files, let's set up a data base management system In order to learn how one works. Assume that you are In charge of your school's video library. You have access to a microcomputer and are interested in computerizing your ever-expanding catalogue. Since you already have a data base-a title and a subject card catalogue-you have a good idea of the kind of information that people want and how they can best find it. After consulting with the computer lab instructor, you buy a DBMS. You're ready to begin.
LEARNING THE JARGON
Before turning to the computer, you review the documentation that accompanies the program and become familiar with the terminology, or jargon, of a DBMS. You learn three important words: field, record, and file.
Field. Afield is a single category of information in your data base. It c an made up of numbers, letters, or a combination of numbers and letters. You look at a catalogue card in your current data base and identify eleven fields, including type of movie, movie title, and call number.
Record. A record is a collection of fields. Each catalogue card with all its entries about a single movie is a record. Since your catalogue currently consists of title and subject cards, you have two records for each movie listed in your data base.
File. A file is a collection of related records. Your subject catalogue is one file; your title catalogue is another. Your DBMS will eliminate duplicate records and combine the two files.
While every data base consists of fields, records, and files, some can handle more data than others. Say that this particular program allows 65 characters in a field, 12 fields in a record, and 300 records in a file. Each letter, number, or space in an entry counts as one character. You note that in setting up your DBMS you'll have to shorten the descriptions of the movies.
7. Translate in English:
- електронні файли;
- система управління бази даних;
- для того, щоб;
- бути відповідальним за;
- мати доступ до;
- заголовок бази даних;
- поточні дані;
- визначати поля;
- заголовок кадра;
- збірка полів;
- одиничний кадр;
- предметна картка;
- перелічений в базі даних;
- збірка взаємно пов’язаних записів;
- усувати записи;
- поєднувати файли;
- регулювати дані;
- ввід;
- скорочувати опис кадрів.
8. What will you have to shorten in setting up your DBMS? Why? Answer the questions:
1. What should a computer user learn before setting up a DBMS?
2. What is a field and what it is made of?
3. What should you identify in your current data base?
4. What is a record and what it is used for?
5. What kind of task does a DBMS perform while forming a file?
6. What devices do you use in setting up a DBMS?
7. Can you explain in English the sequence of this operation?
9. Look through the text to find the main (jargons) terms and their definition.
10. Write out the text: 1) The verbs to characterize the functions of DBMS System;
2) The main elements or categories it operates with.
11. Your fiend has missed a class about setting up a DBMS. Tomorrow he is going to pass the missed material to the teacher, but he asks you to help him. Use these notes to tell him what you know about the operation of a DBMS. Fill in the gaps in the passages choosing the words from the box.
1) A field can be made up of a combination of _______ and _______. You look at a _______ _______ in your current data base and indentify _______ _______, including type of movie, title and call number.
2) Each catalogue card with all its entries about a single movie is a _______. Since your catalogue consists of _______ and _______, you have two records for each _______ listed in your data base.
3) Your subject catalogue is one _______; your title catalogue is another. Your DBMS will eliminate _______ _______ and combine two fields.
File; duplicate records; numbers and letters; catalogue card; title and subject cards; movie; eleven fields; record.
12. Compare your answers with your partner’s in practical task. Point the exact information about typical standards in setting up of a DBMS.
Model: Some particular program allows _______ characters in a field, _______ fields
in a record; and _______ records in a file. Each letter, number or space in an
entry as _______ character(s)
13. Imagine, you are a computer lab instructor. How would you explain the main stages of setting up a DBM System? Use the starters to complete your ideas:
1. Before turning to the computer … .
2. Then look at a catalogue card in … .
3. You need two records … .
4. Your subject catalogue is one file … .
5. Your DBMS will eliminate … .
6. let’s take for example … .