Task 2. Match the meaning of the following English words with the Ukrainian equivalents.
1. conversion routine а) избыточность данных
2. data redundancy b) порядок сортировки
3. BLOB c) индекс базы данных
4. variable-length field d) конверсионная подпрограмма
5. primary key e) первичный ключ
6. sort order f) целочисленный тип данных
7. validation rule g) большой двоичный объект
8. fixed-length field h) поле неподвижной длины
9. integer data type i) правило ратификации
10. database index j) поле переменной длины
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 structure refers 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, data type specifies
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
a) to produce timely, meaningful, and accurate information for decision making.
b) is 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 initial set of data.
Task 4. Decide if the sentences are true or false.
1. Information is entered on a 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 direct access to a common database. 5. 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 on a 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 last names stored in a different field than first names?
What does make 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. 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, 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 structure refers to the … of fields, tables, and relationships in a database.
a) agreement b) allocation c) arrangement d) appointment
3. A primary key is a … that contains data unique to record.
a) space b) field c) table d) file
4. When designing a database, you should … and envision 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 written form d) manually
6. A conversion routine … the data from its current format into a format that can be automatically incorporate into the new database.
a) provides b) transfers c) converts d) supplies
Task 9. Transform the given sentences using the word in brackets without any change in meaning. You may omit, change or add words as required.
The goal of database design is to store information so that it easy to access and maintain (aim).
The treatment of first and last name illustrates the concept of breaking data into fields (shows).
BLOBs can be just about any kind of data you would typically store as a file, such as an MP3 music track (usually).
The information produced by reports and processing routines is only as accurate as the information in the database (exact).
No single way of organizing the data accommodates everyone need’s, but tables can be sorted or indexed in multiple ways (satisfies).
Typically, you would use either an import routine or an export routine to move data from one location to another, but not both. (place).
Task 10. Fill in the gaps in the text.
The first step in designing relational data base is to define its fields by specifying a ___and data type. Integer, date and ___ data types are used for fields that might be mathematically manipulated. The ___ data type is used for fixed-length fields containing text that is not intended to be mathematically manipulated. The ___ data type is a variable-length field for entering text. The ___ data type is used to store true/false or yes/no data. The ___ data type is used to store binary data, such as MP3 files or graphics. When designing fields, a database designer can also include field formats, field ___ rules, and lookup routines to reduce data entry errors.
Task 11. Read the text and do the tasks below.
TEXT 21B. SQL
Adding records, finding information and making updates are all important aspects of database use. Most people who access a database on a “casual” basis interact with very simple user interfaces. These user interfaces shield users from the intricacies of sophisticated query languages. Nevertheless, a little background in query languages can help you understand the power and capabilities of databases.
Query languages like SQL (Structured Query Language) typically work behind the scenes as an intermediary between the database client software provided to users and the database itself. Database client software provides an easy-to-use interface for entering search specifications, new records, data updates, and so on. The client software collects your input, and then converts it into an SQL query, which can operate directly on the database to carry out your instructions.
An SQL query is a sequence of words, much like a sentence. Most implementations of SQL accept either uppercase or lowercase keywords.
The SQL query language provides a collection of special command words called SQL keywords, such as SELECT, FROM, INSERT, and WHERE, which issue instructions to the database. Most SQL queries can be divided into three simple elements that specify an action, the name of database table, and a set of parameters. Let’s look at each of these elements.
An SQL query typically begins with an action keyword, or command, which specifies the operation you want to carry out. For examples, the command word DELETE removes a record from a table, the command word CREATE creates a database or table, the command word INSERT is used to add a record, the command word JOIN uses the data from two tables, SELECT searches for records and UPDATE changes data in the field.
SQL keywords such as USE, FROM, or INTO can be used to construct a clause specifying the table you want to access. The clause consists of a keywords followed by the name of the table. For example, the clause FROM Tracks indicates that you want to use the Tracks table from the Vintage Music Shop’s database.
The term parameter refers to detailed specifications for a command. Keyword such as WHERE usually begin an SQL clause containing the parameters for a command.
One of the most common database operations is to query for a particular record or group of records by using the SELECT command. The phrase, for example, SELECTAlbumTitle, Album Cover specifies that the database should show you only the album title and cover, and until you confirm that is the album you are interested in, it will not show you additional information such as the price or list of tracks.
You can change records in a database only if you have authorization to do so. At Vintage Music Shop’s site, for example, customers do not have authorization to change album prices or alter the name of the songs on an album. The process of purchasing an album, however, does cause an update in the whole database. Your purchase just reduces the number of albums in the shop’s inventory. To accomplish this update, one of the software modules in the shop’s inventory system issues an SQL UPDATE command to reduce the number in the InStock field record. In addition to changing the data in a single record, SQL can perform a global update that changes the date in more than one record at a time. It means that is possible to update a group of records. Suppose you’re Vintage Music Shop’s marketing manager, and you want to put all The Rolling Stones albums on sale by reducing the DiscountPrice to $9.95. You could do it the hard way by searching for an ArtistName field that contains “Rolling Stones”, adjusting the DiscountPrice field for that record, and then looking for the next Rolling Stones album. However, it would be easier to change all records with a single command. The following SQL statement accomplish this global update:
UPDATE Albums
SET DiscountPrice=9.95
WHERE ArtistName=”Rolling Stones”
Let’s see how this command performs a global update. The UPDATE command means you want to change the data in some or all of records. Albums is the name of the record type containing the data you want to change. SET DiscountPrice=9.95 tells the DBMS to change the data in the DiscountePrice field to $9.95. WHERE ArtistName=”Rolling Stones” tells the DBMS to change only those records where the artist name is Rolling Stones. Although the global update function is powerful, it works only for records that have similar characteristics.
Recall that the process of normalization creates tables that can be related by fields that exist in both tables. In SQL terminology, the creating a relationship between tables is referred to as joining tables. To take advantage of the relationship between two tables, you first have to join the tables. Why? Remember that in relational database, the tables are essentially independent unless you join them together. The SQL JOIN command allows you to temporarily join and simultaneously access the data in more than one table.
SQL is a very extensive and powerful language that can be used not only to manipulate data, but also to create databases, tables and reports. Because SQL is one of the most popular database tools, many computer professionals consider SQL fluency as essential career skill.
Task 12. Match the meaning of the following English words with their Russian definitions.
1. SQL query a) запис
2. Database client software b) повне оновлення
3. Relation database c) мова запитів
4. Record d) регуляційна база даних
5. Global update e) ключове слово
6. Parameter f) програмне забезпечення клієнта бази даних
7. Keyword g) SQL-запит
8. Query language h) слово-команда
9. Command word i) об’єднання таблиць
10. Joining tables j) параметр
Task 13. Match the beginning of the sentences in the first column with the endings in the second.
1. Adding records, finding information, and making updates 2. Query languages like SQL typically work behind the scenes 3. Database client software provides 4. An SQL query is 5. The process of purchasing an album 6. The SQL JOIN command allows you |
a) as an intermediary between database client software provided to users and the database itself. b) are all important aspects of database use. c) a sequence of words, much like a sentence. d) only if you have authorization to do so. e) an easy-to-use interface for entering search specifications, new records, data updates and so on. f) does cause an update in the whole database. Your purchase just reduce the numbers of albums in the shop’s inventory. |
Task 14. Put the letters in the words in brackets into the correct order.
A little … in query languages can help you understand the power and capabilities of databases (roducknabg).
An SQL query typically begins with an action …, or command, which specifies the operation you want to carry out (weykdor).
The clause consists of a keywords followed by the name of the … (ablet).
Your … just reduces the numbers of albums in the shop’s inventory (sacherup).
The term … refers to detailed specifications for a command (earpmaret).
Although the global update function is powerful, it works only for … that have similar characteristics (coerdrs).
Task 15. Fill in the blanks choosing from the variants given.
1. Most people who access a database on a “casual” basis … with very simple user interface.
a) manipulate b) work c) operate d) interact
2. A little … in query languages can help you understand the capabilities of databases.
a) certainty b) background c) career skills d) experience
3. The SQL query language provides a collection of special command … called SQL keywords, such as SELECT, FROM, INSERT, and WHERE, which issue instructions of the database.
a) words b) passwords c) names d) numbers
4. Most SQL queries can be divided into three simple elements that … an action, the name of database table, and a set of parameters.
a) execute b) indicate c) construct d) specify
5. Customers do not have … to change album prices or alter the name of the songs on an album.
a) authorization b) rights c) permission d) possibilities
6. SQL is a very extensive and powerful language that can be used not only to … data, but also to create databases, tables and reports.
a) enter b) manipulate c) to make updates d) input
Task 16. Match the beginnings and the endings of the steps given and put them into correct order.
1 SET DiscountPrice=9.95 tells 2. WHERE ArtistName=”Rolling Stones” tells 3. Albums is 4. The UPDATE command means 5. It means that 6. SQL can perform a global update |
a) the name of the record type containing the data you want to change. b) to change the data in the DiscountePrice field to $9.95. c) to change only those records where the artist name is Rolling Stones. d) you want to change the data in some or all of records. e) that changes the date in more than one record at time. f) is possible to update a group of records. |
Task 17. Fill in the gaps in the text.
SQL is a database query language that typically works behind the scenes as an intermediary between the database ___ software provided to users and the database itself. Although the specifications for searchers and other database tasks are collected by easy-to use graphical user interfaces, those specifications are converted into SQL ___ which can communicate directly with the database. An SQL query contains SQL ___ such as SELECT, FROM, INSERT, JOIN and WHERE, plus ___ that specify the details of the command. Records can be removed from a database using the SQL ___ command. Record can be added to a table using the SQL ___ command. To search for data, you can use the SQL ___ command. To change or replace the data in a field requires the SQL ___ command.
Task 18. Speaking. Discuss the following questions.
What are the most important aspects of database use?
Why is so important to have a little background in query languages?
What does the abbreviation SQL stand for?
How does a query language like SQL work?
What does a simple SQL query look like?
How does SQL specify the action that someone wants carried out in the data base? Speak on the most commonly used SQL command words.
How does SQL specify which table to use?
How do SQL queries carry out searches?
Is it possible to change the contents of records or to update a group of records? What does the process of purchasing cause?
How is the date retrieved from more than one table at a time? What command does allow you to access the data in more than one table?