- •English For it Students
- •Предисловие
- •Vocabulary:
- •Central Processing Unit (cpu)
- •Vocabulary:
- •Unit 2. Programming
- •Creating Computer Programs
- •Vocabulary:
- •Structured and Object-Oriented Programming
- •Vocabulary:
- •Unit 3. Databases Text 7 Databases and Database Management Systems
- •Database Structures
- •Unit 4. Networks
- •Network Structures
- •Vocabulary:
- •A(an) __________ is a way to connect computers so that they can communicate, exchange information, and share resources in real time.
- •Network Topologies
- •Internet
- •Vocabulary:
- •Unit 5. Information Systems
- •Building Information Systems
- •Vocabulary:
- •Part II
- •Unit 1. Computers around Us
- •Importance of Computer Literacy
- •Shapes of Computers Today
- •Technical Documentation
- •Types of Documentation
- •Computing Issues That Affect Us All Computer Crime
- •Computer Viruses
- •Unit 2. Input, Output, Storage Devices
- •The Mouse
- •Variants of the Mouse
- •Alternative Methods of Input Devices for the Hand
- •Optical Input Devices
- •Audiovisual Input Devices
- •Monitors and Sound Systems Monitors
- •Pc Projectors
- •Sound Systems
- •Printers
- •Types of Storage Devices
- •Magnetic Storage Devices
- •Unit 3. Operating System
- •Types of Operating Systems
- •Windows xp
- •Brief History of Linux
- •Unit 4. Application Software
- •Word Processing Software
- •Desktop Publishing Software
- •Spreadsheet Software
- •Database Management System
- •Presentation Programs
- •Managing the Small or Home Office
- •Working With Images Computer Platforms Used for Graphics
- •Types of Graphics Files
- •Getting Images Into Your Computer
- •Graphics Software
- •Digital Photography
- •Photography the Old Way
- •Multimedia
- •Creating and Distributing New Media Content
- •Technologies That Support New Media
- •Distributing New Media Content
- •Virtual Reality
- •Uses for Virtual Reality
- •Vr Hardware and Software
- •Pc As an Entertainment Center
- •Utility Software
- •Unit 5. Processor and Memory cpUs Used in Personal Computers
- •Universal Serial Bus (usb)
- •Musical Computers
- •Flash Memory and Cache Memory Flash Memory
- •Cache Memory
- •Memory and Computing Power
- •Unit 6. Programming
- •Visual Programming
- •Fourth-generation Programming Languages
- •Artificial Intelligence
- •Some Examples of ai Techniques
- •Building an Artificial Brain
- •Unit 7. Networks and the Internet Networking at Home and Around the World Data Communications Over Standard Telephone Lines
- •Networks in the Home
- •Isdn, t1, and t3
- •Dsl Technologies
- •Avoiding a Tangled Mess
- •From the History of the Internet
- •Getting Online, Working Online Accessing the Internet
- •Connecting a pc to the Internet
- •Commerce on the World Wide Web
- •Getting Published on the Internet
- •Minding Your Manners Online
- •Graphics Piracy on the Internet
- •Ignorance Is No Excuse
- •Staying Out of Trouble
- •Freebies on the Web
- •Personal Web Pages
- •Unit 8. Information Security Protecting Your Online Privacy
- •Macro Viruses
- •Viruses That Do Not Require Attachments
- •Protecting Yourself
- •Vocabulary
- •Литература:
- •Содержание Part I Computer Basics
Unit 3. Databases Text 7 Databases and Database Management Systems
I. Read and translate the text:
A database is a collection of related data or facts arranged in a specific structure. A database management system (DBMS) is a program, or collection of programs, that allows multiple users to store, access, and process data or facts into useful information.
Three of the most important terms to know about databases are a table, a record, a field. Data is stored in tables. A table is divided into records (unnamed rows), and each record is divided into fields (named columns). The table consists of a set number of fields and an arbitrary number of records. For a record to exist, it must have data in at least one field.
To help you understand how a database stores data, think about a typical address book. Each piece of information in the address book is stored in its own location, called a field. For example, each entry has a field for First Name and another field for Last Name, as well as fields for Address, City, State, ZIP Code, and Phone Number. Each unique type of information is stored in its own field. One full set of fields – that is, all the related information about one person or object – is called a record. Therefore, all the information for the first person is record 1, all the information for the second person is record 2, and so on.
A complete collection of records makes a table. Once you have a structure for storing data (whether it is a printed address book, phone book, or electronic table), you can enter and view data, create reports, and perform other tasks with the data. For example, you may create a customer report that lists customers by ZIP Code.
A DBMS provides tools to perform data management functions: creating tables, sorting tables, entering and editing data, querying the database, viewing data, generating reports.
Many different DBMS programs are available. Enterprise-level products, such as Oracle, DB2, and Sybase, are designed to manage large special-purpose database systems. Programs such as Microsoft Access, Corel's Paradox, and Lotus Approach are popular among individual and small-business database users.
Vocabulary:
database ['deitqbeis] – база данных
collection [kq'lekSn] – совокупность
relate [ri'leit] – соотносить
related [ri'leitid] – зд. cвязанный
relationship [ri'leiSnSip] – отношение
to arrange [q'reinG] – компоновать, размещать, располагать, упорядочивать
specific [spi'sifik] – заданный, специфический
database management system (DBMS) ['deitqbeis 'mxnqGmqnt 'sistqm] – система управления базой данных (СУБД)
multiple ['mAltipl] – множественный, многочисленный
term [tq:m] – термин
table ['teibl] – таблица
record ['rekLd] – запись
field [fi:ld] – поле
to name [neim] = to call [kLl] – называть
row [rqu] – ряд, строка
column ['kolqm] – колонка, столбец, графа
to set [set] (set, set) – устанавливать
number (of) ['nAmbq] – ряд, число (чего-л.)
arbitrary ['Rbitrqri] – произвольный
to exist [ig'zist] – существовать
at least [qt'li:st] – по крайней мере, не менее
to think [TiNk] (thought, thought) – зд. представлять себе
typical ['tipikl]– типичный, обычный
piece [pi:s] – порция, кусок
own [qun] – собственный
location [lqu'keiSn] – расположение
entry ['entri] – запись, содержимое, введённые данные
as well as [qz 'wel qz] – а также
ZIP Code ['zip kqud] – почтовый индекс
full [fu:l] = complete [kqm'pli:t] – полный
therefore ['DFqfL] – следовательно
once [wAns] – как только
to enter ['entq] – вводить
to view [vju:] – просматривать
to generate ['Genqreit] – создавать, производить
report [ri'pLt] – отчёт, сообщение
customer ['kAstqmq] – клиент, заказчик, покупатель
to sort [sLt] – сортировать, упорядочивать
to edit ['edit] – редактировать
to query ['kwiqri] – делать запрос
query – запрос
available [q'veilqbl] – доступный, наличный
enterprise ['entqpraiz] - предприятие
level ['levl] – уровень
such as ['sAtS qz] – такие, как
to design [di'zain] – проектировать, конструировать, разрабатывать
special-purpose ['speSql 'pq:pqs] – специализированный
popular ['popjulj] – популярный
among [q'mAN] – среди
individual [‚indi'vidjuql] – отдельный
II. Answer the following questions:
What is a database?
What is a database management system?
What are the most important terms to know about databases?
Where is data stored in a database?
What is a table? a record? a field?
What type of information is stored in the field?
What data can a field contain?
What functions does a DBMS provide?
What enterprise-level DBMS programs do you know?
What DBMS programs are popular among individual and small-business users?
III. Tell whether the following statements are true or false:
A database management system is a repository (архив) for collections of related data or facts.
A database is at the heart (в центре) of many types of computer applications.
In a database, each piece of information is stored in its own location, called a directory.
In a database, a record contains all the related information about a single (единственный) person or object.
In a database table, all the records are organized according to the same set of fields.
One full set of fields is called a table.
A database management system allows to view data, create reports and perform other tasks with the data.
DBMS programs are used only by individual users.
In a database, the number of records is set, but the number of fields is arbitrary.
A record must have data in at least one field.
IV. Fill in the blanks:
The three most important terms to know about databases are ______________, ______________, and ______________.
The table ___________ a set number of fields and an arbitrary number of records.
In a database, each unique type of information is stored in its own _____________.
All the __________ information about one person or object is called a record.
For a database record to exist, it must have data in at least one ___________.
The DBMS __________ the user with data and the tools to work with the data.
A DBMS provides tools to ________ tables, ________, ________ data, _______ the database, _______ reports.
A database management system _________ multiple users to store, access, and process data or facts into useful information.
V. Choose the right answer:
A tool that allows users to store, access, and process data is called
Database c. Form
Database management system d. Query
2. A database is a collection of related facts arranged in a specific
Database management system c. Field
Structure d. Application
In a database, names such as “Last name” and “Address” may be given to the
Records c. Fields
Files d. DBMS
A database table is a collection of
Records c. Rows
Fields d. Columns
In a database table, fields are stored as
Columns c. Reports
Rows d. None of the above
Each object’s record contains (содержит) a limited number of
Data c. Fields
Tables d. Characters
VI. Match each item to the correct statement below:
Database d. Field
Record e. Table
Database management system
A data repository.
A software tool.
Helps users process data into information.
At the heart of many types of applications.
A complete collection of records.
All the related information about one thing.
Each piece of information is stored in one.
The database has arbitrary number of them.
Can store any number of records.
The database has a set number of them.
Speak on the contents of the text using the following chart:
Text 8