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
На этом уроке раскрываются подробности работы со списками: удаление и добавление элементов, методы списков.
Что такое список (list) в Python?
Список (list) – это структура данных для хранения объектов различных типов. В нем можно хранить объекты различных типов. Размер списка не статичен, его можно изменять. писок по своей природе является изменяемым типом данных.