Informatics 9. Билингвальный учебник - страница 12

Get information about Database types.

Would you like to help your family to arrange goods in your family shop?

Familyshopdatabase

В этом уроке мы будем разрабатывать небольшую базу данных, которая поможет нам подсчитать товар в магазине. Сначала сделаем форму для ввода данных в нашу базу данных.

Создайте форму с названием: «Our shop». Add 5 fields with the following types:

1. Name of the product - Short answer;

2. Category of product - Dropdown (at least 4 categories);

3. Quantity - Short answer;

4. Price - Short answer;

5. Expire date - Date.

Practice 1

Заполните форму как минимум с 5 записями.

Practice 2

1. Now start working with the database table. Apply “sorting” of all goods according to ‘Price’ in descending order.

2. Filter all goods according to any two categories.

3. Add a pivot table to show all the records according to some types. For example: Show goods quantity in different categories

4. Finally, create a chart to represent information details.

Types of Database

Centralized database - Users from different locations can access this database from a remote location at the central database, that store entire information and application programs at a central computing facility for processing.

Operational database - This is more of a basic form of data that contain information relating to the operations of an enterprise.

End-user database - End user is the user of software, application or a product. This is a shared database which is shared by users and is meant for use by the end users, just like managers at different levels.

Commercial database - This is a database that contains information which external users may require. However, they will not be able to afford to maintain such huge database by themselves.

Personal database - The personal databases are maintained, generally, on personal computers. They contain information that is meant for use only among a limited number of users, generally working in the same department.

Distributed database - These databases have contributions from the common databases as well as the data captured from the local operations.

Fact

A database management system (DBMS) is a computer software application that interacts with end users, other applications, and the database itself to capture and analyze data. A general purpose DBMS allows the definition, creation, querying, update, and administration of databases.

Fact

Your responsibility as a database administrator (DBA) will be the performance, integrity, and security of a database. You’ll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.

You’ll ensure that:

- data remains consistent across the database;

- data is clearly defined;

- users access data concurrently, in a form that suits their needs;

- there is provision for data security and recovery control (ensuring all data is retrievable in an emergency).

Terminology

performance - өнімділік - представление

integrity - тұтастық - целостность

security - қауіпсіздік - безопасность

troubleshoot - ақаулықтарды жою - устранение неполадок

enterprise - кəсіпорын - предприятие

CHECK YOURSELF

1. Where can we use databases? (Give at least 3 examples)

2. Which parts does a database system consist from?

3. Describe the steps of planning a database

4. What data types do we have in Google Sheets?

5. What are the ways of creating a form?

6. How to apply a filter to table?

7. What is pivot table?

8. Describe the way of creating a spreadsheet table by using Form.

9. Describe functions of filter in Google sheet.

10. Describe way to apply pivot table.

11. Give 3 examples of where you can use Google Forms

12. Describe types of charts

13. Describe way to apply chart to your table.

CHAPTER 3. PROGRAMMING

3.1 PYTHON LIST

You will:

Create python list and use;

Learn to change list items.

How can you create a program that will store your classmates’ names?

Список в Python

На этом уроке раскрываются подробности работы со списками: удаление и добавление элементов, методы списков.

Что такое список (