Task 3. Choose the ending for each sentence from the two versions given.



1. The key to an effective database is

a) its initial design.

b) to determine what data must be collected and stored.

2. The term database structurerefers to

a) the arrangement of fields, tables, and relationships in a database.

b) the concept of breaking data into fields.

3. From a technical perspective, a data typespecifies

a) the way data can be manipulated.

b) the way data is represented on the disk and in RAM.

4. Character data contains

a) letters, numerals and symbols not used for calculations.

b) numbers that can be manipulated mathematically.

5. The goal of normalization is

a) to produce timely, meaningful, and accurate information for decision making.

b) to minimize data redundancy-the amount of data that is repeated or duplicated in a database.

6. After the design for the database structure is completed, it is time

a) to determine the order in which records are stored.

b) to load the database with an initialset of data.


Task 4. Decide if the sentences are true or false.

1. Information is entered into the database via records. 2. Records are grouped together into files. 3. A card index system is much faster to consult and update than a computer database. 4. A great advantage for managers of different departments is that they have the direct access to a common database. 5. A database program can be protected by related information. 6. If you want to share your personal commission, you can protect the commission field.

Task 5. Complete the sentences with the words in the box. Translate.

passwords  field  layout  merging   record sorted    updated   security devices database

1. In order to personalize a standard letter you can use ‘mail …’ (a technique which consists of combining a database with a document made with a word processor). 2. Records can be automatically … into any order. 3. You can decide how many fields you want to have on a … . 4. Files can easily be … by adding new information or deleting the old one. 5. Most aspects of the program can be protected by user-defined … . 6. Thanks to …, you can share part of your files on a network and control who sees the information. 7. A … program can be used to store, organize and retrieve information of any kind. 8. The … of the records can be designed by the user. 9. Each piece of information is given in a separate … .

 

Task 6. Discuss the following questions:

—   What is a database?

—   How is information entered into the database?

—   What does each field hold?

—   What does ‘updating’ a file mean? 

—   What are the advantages of a database program over a manual filing system?

—   How can access to a common database be protected?

—   What is the goal of a well-designed database?

—   What does the term ”database structure” refer to?

—   Speak on the first step in structuring a relational database. What is the next step?

—   Why are the last names stored in a different field than the first names?

—   What makes each record unique?

—   How does a database designer know what data types to use?

—   Can a database designer prevent people from entering inaccurate data?

—   What is normalization?

—   What are the principles that a designer might consider to improve this database?

—   How is data loaded into database tables?


Task 7. Say which word does not belong to the group.

a) initial, original, primary, subsequent;

b) allow, permit, let, advice (v)

c) current, visual, intuitive, efficiently;

d) carry out, execute, fulfill, specify;

e) reduce, decrease, minimize, grow up;

f) tool, device, equipment, gadget.

 

Task 8. Fill in the blanks choosing from the variants given.

1. In a well-designed database, the data can be … manipulated to produce timely, meaningful, and accurate information for decision making.

a) flexibly              b) smoothly           c) slowly                d) hardly

2. The term database structurerefers to the … of fields, tables, and relationships in a database.

a) agreement b) allocation                      c) arrangement       d) appointment

3. A primary keyis a … that contains the data unique to record.

a) space                  b) field                              c) table                   d) file

4. When designing a database, you should … and envision any potential data entry errors.

a) think ahead b) think about                    c) think over          d) think out

5. Entering data … can take a long time, however, and mistakes such as misspelling are common.

a) electronically     b) automatically     c) in a written form           d) manually

6. A conversion routine … the data from its current format into a format that can be automatically incorporated into a new database.

a) provides             b) transfers            c) converts                         d) supplies


Дата добавления: 2018-10-26; просмотров: 297; Мы поможем в написании вашей работы!

Поделиться с друзьями:






Мы поможем в написании ваших работ!