- They can solve cases where many users want to access (and possibly change) the same entries of data.
- They manage access rights (who is allowed to see the data, who can change it)
- When there are many users asking questions to the database, the questions must be answered faster. So, the last person to ask a question can get an answer in a reasonable time.
- Certain attributes are more important than others, they can be used to find other data. This is called indexing. An index contains all the important data and can be used to find the other data.
- They ensure that the data always has context (makes sense). There are a lot of different rules that can be added to tell the database system if the data makes sense. One of the rules might say November has 30 days. This means if someone wants to enter November 31 as a date, this change will be rejected.
Fact
A database administrator could...
Design a digital database of medical records that can be instantly transferred between clinics, unlike paper patient records.
Protect bank accounts from hackers by adding security features to a bank’s financial database.
Make an inventory database for a chain of candy stores to help them keep the most popular candies in stock.
Create a database of DNA from people with multiple sclerosis to help researchers pinpoint the genes involved in the disease.
Literacy
1. How do we build a new database?
2. Where do we use a table in daily life?
Terminology
immediate - тез арада - немедленный
to-do list - жұмыстар тізімі - список дел
to combine - біріктіру - объединить
to resize - өлшемін өзгерту - изменить размер
to scroll - айналдыру - прокручивать
field - алаң - поле
edge - шеті - край
area - аудан - область
to break - бөлу - разделить
to customize - баптау - настроить
2.3 BUILDING A DATABASE
You will:
Create forms;
Create tables.
How to build a database system to find books in the library faster?
Creatingform
Для того, чтобы начать создавать базу данных, необходимо создать форму, которая добавит новую информацию о книгах в нашу библиотеку.
- Откройте Google диск
- Нажмите «Создать» и выберите «Google Forms»
- Нажмите «Новая форма» и введите имя новой формы. Например: «Добавить новую книгу»
- Нажмите «Вопрос без заголовка», чтобы ввести вопрос. Пример: «Название книги».
- Выберите тип ответа для своего вопроса. Пример: «Короткий ответ».
- Нажмите «+» справа и добавьте новые вопросы:
«Жанр» с типом «Раскрывающийся список»