ЖИ көмекші
ЖМЦ бағыты бойынша информатика пәні ағылшын тілінде өткізілген ашық сабақ жоспары
Жүктеу
#1 слайд
Look at the following situation
•
You wanted to get a book about molecular
biology. You went to the nearest library and asked
for it . Unfortunately a bookkeeper could not find
the book and did not even know whether such
book exists in the library. The interesting thing is
that you are sure that you got this book from this
library a year before.
•
How would you solve this problem?
•
What would you suggest to avoid such kind of
problems?
1 слайд
Look at the following situation • You wanted to get a book about molecular biology. You went to the nearest library and asked for it . Unfortunately a bookkeeper could not find the book and did not even know whether such book exists in the library. The interesting thing is that you are sure that you got this book from this library a year before. • How would you solve this problem? • What would you suggest to avoid such kind of problems?
#2 слайд
The topic of the lesson:
Database
Learning objectives(s)
9.2.3.2 explanation of the terms
record, field, table
2 слайд
The topic of the lesson: Database Learning objectives(s) 9.2.3.2 explanation of the terms record, field, table
#3 слайд
Terminology
English Kazakh Russian
Database деректер қоры база данных
Field алан поле
Record жазба запись
Column баған столбец
Row жол строка
Table кесте таблица
Query сұраныс запрос
Report баяндама отчет
3 слайд
Terminology English Kazakh Russian Database деректер қоры база данных Field алан поле Record жазба запись Column баған столбец Row жол строка Table кесте таблица Query сұраныс запрос Report баяндама отчет
#4 слайд
•
A database is an aggregate of a large amount
of data systematized by certain properties.
•
Databases: catalogs of libraries; phonebook;
bank customer data; workforce data; hospital
patient list; school magazines
4 слайд
• A database is an aggregate of a large amount of data systematized by certain properties. • Databases: catalogs of libraries; phonebook; bank customer data; workforce data; hospital patient list; school magazines
#5 слайд
Database types
Tabular
single-table or
multi-table, but
connected to
each other hierarchical
the first element
is considered the
main, the rest are
subordinate to it N etwork
a collection of
data in which
each element can
be associated
with any other
element
5 слайд
Database types Tabular single-table or multi-table, but connected to each other hierarchical the first element is considered the main, the rest are subordinate to it N etwork a collection of data in which each element can be associated with any other element
#6 слайд
Database consists of tables
•
Table consists of columns and rows.
•
Field is a table column that reflects certain
properties of an object
•
A record is a row of a table containing a set of
values described in the database fields.
6 слайд
Database consists of tables • Table consists of columns and rows. • Field is a table column that reflects certain properties of an object • A record is a row of a table containing a set of values described in the database fields.
#7 слайд
record
fieldfield
name
7 слайд
record fieldfield name
#8 слайд
Work in group
•
Draw your own vision of database of your
class on a sheet of paper. You need to think
what kind of information must be in your
database. Make 6 fields at least that may be
‘name’, ’surname’, ’birthday’, ets.
8 слайд
Work in group • Draw your own vision of database of your class on a sheet of paper. You need to think what kind of information must be in your database. Make 6 fields at least that may be ‘name’, ’surname’, ’birthday’, ets.
#9 слайд
Literacy
•
How did people store information before
database?
•
How they made such operations like
searching, storing and managing an
information?Where database used in daily
life?
9 слайд
Literacy • How did people store information before database? • How they made such operations like searching, storing and managing an information?Where database used in daily life?
#10 слайд
Reflection.
•
What did you know and
what did you learn today?
•
What work did you like
more?
•
Why?
10 слайд
Reflection. • What did you know and what did you learn today? • What work did you like more? • Why?
#11 слайд
Homework
Using the POPS formula, answer the question
« Do we need a data base in life?»
1.I think ......
2. Because ....
3. For example .....
4. I conclude ....
11 слайд
Homework Using the POPS formula, answer the question « Do we need a data base in life?» 1.I think ...... 2. Because .... 3. For example ..... 4. I conclude ....
Жүктеушағым қалдыра аласыз
Бұл курс Қазақстан Республикасы Оқу-ағарту министрлігімен келісілген
