Presentation of tabular information models of tables. Table information models. "Table Information Models"

Teacher Informatics MOU "SOSH №20" Pospelova G. V. Novomoskovsk Tula region

Theme "Table Information Models"

Grade 7 (UMK L.L. Bosova)

Objectives lesson:

    systematize and summarize information obtained by students in the previous lesson;

    expand students' presentings about iconic information models;

    sort the presentation of students on table information models, repeat / form table creating skills.

Tasks:

Educational:

    consolidate students' presentings about models and modeling, types of information models, mathematical models, tabular information models;

    systematization of knowledge gained.

Developing:

    the development of analytic-synthesizing thinking, the formation of skills to observe, draw conclusions, the development of resourcefulness, the ability to overcome difficulties to achieve the target target.

Educational:

    educating a positive attitude to knowledge, instilling interest in computer science, formation of self-organization skills and self-control.

Type of lesson: Lesson for fixing the material being studied and the development of practical skillsand skills.

Type of lesson: combined.

Work forms at the lesson: independent, individual work.

Methods: verbal (story),viteless illustrative, practical.

Equipment:

    Laptops;

    Multimedia complex (PC, projector, interactive board);

    Presentation 7_2.5.1 "Table Information Models".

Basic concepts:

    model,

    information model

    sign information model,

    tabular information model.

During the classes

1) actualization and verification of learned material

    Questions are discussed:

What is the model?

What is modeling?

What models are called natural?

What models call information?

What are the types of information models?

What information models are most common in communication?

In which cases, instead of text descriptions, it is better to use lists

(Numerous, marked, multi-level)?

Why the natural language is not always suitable for creating information

models?

2. Discussion of the results of the tasks number 1-4 in the textbook:

1) Answer: The speed of sound distribution on the winter day at a temperature - 35 0 From equal to 310 m / s, and on a summer day - at a temperature of + 30 0 C is 352 m / s.

2a) Answer: The number of days is calculated by the formula :.

2B) Answer: The time through which cyclists will meet are calculated by the formula: minutes.

3) Answer: time is calculated on the basis of the formula. As t. = 8 hours B. \u003d 24 hours, then \u003d \u003d 12 hours.

4) Answer: Wires are definitely enough to mark the flower beds d) and not enough for the option b). When solving options a) and c), it is necessary to mentally "break down the steps" and make sure that in each of these cases it turns out a rectangle 6 * 10, and, consequently, the wires are sufficient.

2) Explanation of the new material: Table information models.§ 2.5.1.

(Accompanied by a presentation show 7_2.5.1_ tabular information models ")

The explanation of the new material is organized in the form of a conversation supported by the demonstration of the presentation "Table Information Models" (slides 2- 4). It is desirable to use the existing experience of schoolchildren to use table information models as much as possible. It is important to summarize the students to the conclusion that the information presented in the table is visual, compact and easily promined.

Pupils should consider drawings and specify objects and identical properties of objects (slide 5). The figures depicts girls in national costumes (Spanish, Russian, Indian). Each suit has a dress, a headdress and musical instruments.

Make a table "National costumes" (slide 6.)

Emphasize that the information in the table is visual, compact, easy to see.

Create examples of tabular information models (tables), in which information is visual, compact, easy to see. (Slide 7).

Special attention should be paid to the rules for designing tables. In the future, it is necessary to strictly follow these rules. (Slide 9-11).

It should be noted that all many tables can be divided into simple and complex.

3) Fizkultminutka.

    It is known that children are quickly tired in the lessons, because long time is in a static position.

    Fizkultminthki helps the prevention and removal of mental fatigue.

    Conduct physkultminutka by 12-20 minutes from the beginning of the lesson.

    Duration 1-2 minutes.

(An electronic physical attack is carried out for the eyes.)

4) Practical work.

The practical part of the lesson (tasks number 1 and No. 2 of work No. 6 "Creating tabular models") is devoted to the formation of the skills of creating and formatting tables.

When executing a task number 1, "Giant" It is important to ensure that the students do not create five different tables, and edited the first table using the insertion and removal of strings and columns using autoformatting and implementing data sorting.

In the task number 2, the Nature of Russia, students not only work out technological reception (cell combining), but also produce selection necessary to fill out a table of information from a text document.

5) homework

§ 2.5 (p. 58-60); Answers to Questions Nos. 1 - 6 (p. 69)

6) Reflection

Each student has on the table card (green, yellow, red). Leaving the class, you need to leave one of them on the teacher's table:

    Green "I am satisfied with a lesson, a lesson was useful for me, I have a lot, with benefit worked at the lesson received a well-deserved assessment, I understood everything about what was stated in the lesson.

    Yellow - The lesson was interesting, I took an active part in it, the lesson was at a certain extent useful for me, I answered from the place, I managed to fulfill a number of tasks, I was at the lesson quite comfortable.

    Red - I received a little use from the lesson, I didn't really understand what it was about, I don't really need it, I will not fulfill my homework, I was not ready to answer the answers in the lesson.

Literature

    Informatics and ICT: textbook for grade 7 / L. L. Bosov. - M.: Binom. Laboratory of Knowledge, 2009. - 229 p .: Il.- ISBN: 978-5-9963-0092-1 ..

    Informatics lessons in 5-7 classes: Methodological manual / L.L. Bosova, A.Yu. Bosov. - 2nd ed., Act. and add. - M.: Binom. Laboratory of Knowledge, 2005. - 320 C.: Il.

"Table Information Models"

Objectives lesson:

a) educational:

    repeat the classification of models by the presentation method, defining the information model;

    get acquainted with various forms of information models (graphic, verbal, mathematical, tabular);

    remember what a table is from which parts it consists;

    introduction of concepts Table object object, object-property, combined table, matrix, binary matrix.

b) developing:

    development of interest in the subject due to the novelty of some concepts (matrix, binary matrix) and the forms of information presentation (presentation);

    development of logical thinking with a logical operation analysis;

c) Educational:

    education of the cognitive activity of students.

Equipment: PC for teacher, presentation, projector, distribution material (test).

Type of lesson - Combined.

Form lesson - At the beginning of the lesson - individual, the rest of the time is frontal.

Method - Explanatory-illustrative.

    Organizing time 5 minutes.

    Checking homework 5 minutes.

    Repetition (test) 5 minutes.

    Studying a new material 25 min.

    Summing up the lesson and job task. 5 minutes.

During the classes:

I.. Discussion of the performance of homework (because not all do it). The praise of individual students for activity in the previous lesson.

II. . Today you were asked to come up with the example of educational, scientific and technical, experienced, game and imitation models. Who coped with this task? (I check the presence of D.R., I ask you to read the most successful examples)

III. And now check how you learned the material of the previous lesson. Close, please, all notebooks and textbooks. I will give you a test. It gives 3 minutes. For each question you need to choose one correct answer. Started.

(See Test 3)

IV . And now proceed to the study of a new material. We write down the topic of today's Table Information Models lesson.

Guys, you have already met with the classification of models according to the presentation method. What two large groups share models?

- Material and informational.

(2 slide)

Let's remember what information model is?

- Information model - This is a combination of information that characterizes the properties, the state of the object and the relationship with the outside world.

Thus, the information model is a set of information. In turn, this set of information can be represented in different form. What do you think in what form it can be represented?

(3 slide all that is on the slide is recorded)

First, she M.B. Presented in graphical form, for example, in the form of a scheme, graphics, drawing, cards.

Secondly, in verbal form. What do you think is a verbal form?

Verbal shape.

That's right, the verbal form is a verbal description.

The third form is mathematical. This description of relations between the quantitative characteristics of the object on the mathematical language. For example, a triangle area formula.

And the last form, what do you think, what? This is a tabular form. It is in this form that we will stop more in detail.

Well, we got acquainted with you with four forms of the information model. But then there is such a question: what form to choose when creating a model? And the answer is actually very simple.

(4 slide, write)

The form of the information model depends on the purpose of its creation.

Let's look at this on the example.

(5 Slide orally)

We are faced with the goal to trace the temperature change in June 2006. What information do we possess? We have a temperature for every day of June. What do you think, in what form can we submit this information?

In graphical form.

Correctly we can imagine it in graphical form in the form of a graph.

(5 slide)

What can we see on this schedule?

Where the temperature grew, and where he dropped.

What day was the maximum temperature and what is it equal to?

What day was the minimum temperature and what is it equal to?

(Answer, but what day cannot say for sure.)

Thus, we see that the schedule gives us clarity, but the accuracy of the PI is lost.

Can we submit this information in any other form?

It is possible in the form of a table.

What is the convenience of this form of presentation?

The data is more accurate.

But then we will lose clarity. Well, let's consider another example.

(6 Slide orally)

We need to study which seas and oceans are washed by mainland Australia. What form of information model we are most convenient to choose.

Graphic shape, namely the card.

Is it possible anyhow somehow? Of course you can, for example, verbally. From the West Australia is washes the Indian Ocean, from the east of Tasmanovo Sea, etc. We can list all words, but will it be convenient for us to study geography thus? Not. We will not be clear.

Thus, we see that the graphic form is selected if an important requirement is visibility.

Now consider the following example. We need to explore estimates of three students for the first quarter. In what form can we submit this information model?

In graphical form in the form of a graph.

Well, look at the schedule built by me.

(7 Slide orally)

Is it convenient to study academic performance on it? And if there are a lot of students, all the graphs are confused, and it will be even more not more convenient.

How else can this information model be present?

In the form of a table.

This form is most convenient in this case, since the information is written more compact, systematized.

Thus, we see that the tabular form is selected if we need to systematize information.

Today at the lesson we will get acquainted with the tabular form of the information model. We will discuss from what the table consists of what it is characterized by what types of tables are.

As an example, consider the table. This is a testing table. This table includes estimates of three students in four subjects.

(8 Slide orally)

How many lines in this table? Name the names of the lines.

How many columns in this table? Name the names of the columns.

At the intersection of rows and columns are cells. What is listed in the cells? Thus, we can say that each table is characterized by:

    the title (and if there are several tables, then another number)

    the number of lines and their names (string headers)

    the number of columns and their names (column headers)

    content cells located at the intersection of columns and lines.

Once again inspect the table. It contains a combination of information about objects, that is, we can call this table with the information model of the academic process.

And now you will learn what types of tables exist.

(9 Slide write all that is on the slide)

The first type is the Table Object-property, the second type - the object object object and the third type - combined tables. What is this table? (Switch by reference).We write a definition:

Table object-property- This is a table in which several properties are reflected, and all objects belong to one set.

Consider an example of such a table. Table "Data on students". This table reflects four properties: date of birth, growth, etc. All objects belong to one set - a variety of students. Leave after defining the place, at home you will give your example of the Table object-property.

And now consider the Type Table Type object. We write a definition:

Table object object - This is a table that reflects one property characterizing two or more objects.

Consider an example of such a table. Table "Football Games". In this table, one property (date of the game) characterizes three objects (three classes). Leave after defining the place, at home you will give your example object object.

(next slide)

What type of table is this table? As you have already noticed in this table, several properties that characterize three objects, i.e. The table consists of two tables. Such a table is called combined. We write a definition:

Combined Table - This is a table obtained by combining in one table of several tables of the form "O.-O." and "O.-S.". Leave after defining a place, at home you will give your example of a combined table.

(next slide)

What type of table is the following table?

Object object.

Please look at the contents of its cells. The cells contain numbers. So now the rectangular table, composed of numbers, is called a matrix. We write this definition.

You probably have already noticed that the table consists of zeros and units. This table is called a binary matrix. We write this definition:

Binary matrix - This is a matrix made up of zeros and units.

It reflects the qualitative nature of the relationship between objects.

At home, come up with your example of the matrix and binary matrix.

V.. So guys, what's new you learned today at the lesson?

What is a matrix, binary matrix, what are the types of tables, how to choose the form of information model.

Are there any questions about the new material?


Table information models

Presentation performed:

iT-teacher

MBOU - Gulevskaya Oosh Klintovsky District

Bryansk region

Antonenko Maria Vladimirovna

Objectives:

  • 1. Learn the object-property type tables
  • 3. Get acquainted with binary matrices

What is the model?

One original is one model?

  • material point

Why do you need a lot of models?

studying the structure of the body

clothes fitting

study of heredity

training rescuers

accounting of citizens of the country

What is the model? The model is a simplified similarity of a real object. The model reflects only some object properties substantial in terms of modeling target. What is modeling? Modeling is a person's activities for creating a model (invention or informational). The concept of modeling should be understood in the broadest sense. It may be material object: Ship, Comet, Live Cage; natural phenomenon: thunderstorm, solar eclipse; process: Flying rockets, changing the value of shares on the stock exchange and much more. Give the definition of formalization. Formalization is the result of the transition from the real properties of the modeling object to their formal Designation in a specific iconic system. 1) What is the simplified representation of the real object?

  • original;
  • prototype;
  • model;
  • system.

2) The process of building models is called:

  • modeling;
  • constructing;
  • experimentation;
  • design.

When do modeling use?

3) The information model consisting of rows and columns is called:

  • schedule;
  • scheme;
  • drawing;
  • table.

In addition to information,

what are the models in nature?

4) What is the general name of models that are a totality of useful and necessary information about the object?
  • material;
  • information;
  • subject;
  • verbal;
5) the geometric model of the rectangular triangle is:
  • layout;
  • definition;
  • drawing;
  • A + V + C \u003d 180 °, AU2 \u003d AC2 + SU2.

Models in structure

  • table models (compliance pairs)
  • hierarchical (multi-level) models
  • network models (graphs)

Director

Chief Engineer

Chief Accountant

With the help of tables are built information models in various subject areas Table models - Objects and their properties are presented as a list, and their values \u200b\u200bare placed in the cells of the rectangular shape. The list of the same type of objects is located in the first column (or row), and the values \u200b\u200bof their properties are placed in the following columns (or rows) Task: With the help of the table, solve the task: Masha, Olya, Lena and Valya - wonderful girls. Each of them plays on some musical instrument and speaks to one From foreign languages \u200b\u200b(eng., Ial., Franz., Spanish.). They have different tools and languages: Masha plays a piano; A girl who speaks French playing a violin; Olya plays a cello; Masha does not know the Italian language, and Olya does not speak English; Lena does not play on the harp, and the cellist does not speak Italian. Determine what tool every girl is playing, and how she owns it.

The verbal description of the cost of landing 1 hectares of gardens and berries in the central regions of Russia in 1980 was given. Build a model that helped more clearly imagine this picture. The cost of landing 1 hectares of gardens and berries in the central regions of Russia in 1980. Wage during the landing of the gooseberry - 167 rubles. Fuel, Yadochimikati and herbicides for planting strawberries - 115 rubles. Fertilizers when planting black currant - 585 rubles. Material on a shpaller when boarding raspberries - 780 rubles. Fuel, Mikati and Herbicides for planting black currant - 90 rubles. Planting material when planting strawberries - 1750 rubles. Payment of work when landing black currant - 150 rubles. Configuration when landing raspberries - 532 rubles. Fertilizers when boarding the gooseberry - 555 rubles. Fuel, Yadochimikati and herbicides for landing raspberries - 89 rubles. Planting material when boarding the gooseberry - 594 rubles. Other expenses when landing strawberries - 584 rubles. Warry pay when landing raspberries - 235 rubles. Fuel, Yadochimikati and herbicides for landing gooseberry - 92 rubles. Fertilizers when planting strawberries - 313 rubles. Other expenses when boarding black currant - 260 rubles. Planting material when landing raspberries - 1200 rubles. Remuneration when landing strawberries - 316 rubles. Other expenses when boarding the gooseberry - 388 rubles. Planting material when planting black currant - 1100 rub. Other expenses when landing raspberries - 474 rubles.

The cost of landing 1 hectares of gardens and berries

in the central regions of Russia in 1980

Graphic Information Models (Scheme, Structure, Graph) The scheme is a graphical display of the composition and structure of a complex system. The structure is the order of combining the elements of the system into a single whole. The schedule is a process model.

These are drawings, photos, schemes, diagrams, and so on. They help us quickly and understand the information to the listener.

Visual information presentation forms

Table information models

1. Tables of type "Object property"

2. Table Type "Object"

3. Binary matrices

Table Type "Object Property" Table. Home Library Table Type "Object property" Table. Weather Table Table Object Table. The performance of the line belongs to students - this is the first type of objects, columns - to school subjects - a second type of objects. In each cell of the table, at the intersection of the string and column, is an assessment obtained by this student on this subject. Object Type Tables Table. Roads This table contains information about the availability of direct roads between settlements.

Podgorn

Podgorn

Binary matrices in mathematics Rectangular table, composed of numbers, is called a matrix. If the matrix contains only zeros and units, then it is called a binary matrix. The numeric part of the road table is a binary matrix binary matrices

Table. Optional

The table shows information about the visit to four disciples of the three electives. You should already be clear that the unit means visiting, zero - fisos.

In the tables representing binary matrices, the qualitative nature of communication between objects is reflected.

Tabular way to solve logical tasks

Misha does not know how to swim and never played volleyball. And Anya took the first place for swimming among girls last year. Olya does not play football. Determine what kind of sports section is visited by each of the disciples?

Summing up that you learned new today? What is the convenience of a table presentation of information? Give examples of the tables that you have to deal with school and at home. What is a matrix? What is a binary matrix?

Let's summarize the lesson:

Task1:

Gathering on the beach, funny little men decided to stock soft drinks.

Dunno took with him 2 liters of kvass, 1 liter of soda and 1 liters of raspberry syrup, donut - 3 liters of soda and 2 liters of raspberry syrup, caroring - 2 liters of soda, Dr. Pillkin - 1 liter of kvass and 1 liter of Caster.

How many liters of drinks of each species took all the little men together?

How many liters of drinks took with me each of the little men?

How many liters of drinks took all the little people together?

Submit existing information in the table

Homework:

Price, mon.

Dunno

Toropyzhin

Pilyulkin

Stub

Stub

Stub

Stub

Stub

Gazirovka, L.

Castor, L.

Task2:

It is known that 1 liter of kvass in a flower city costs 1 coin, 1 liter of soda - 3 coins, 1 liter of raspberry syrup - 6 coins, 1 liter of Caster - 2 coins.

How many coins I spent on the purchase of drinks every little man?

How many coins spent on the purchase of drinks of each species?

How much money is spent by all the little people together?

Table design rules
Table type "Object properties"
Types of "object objects-one"
Computing tables
Solution of logical tasks

Keywords

Table type "Object properties"
Table type
"Object objects-one"
Computing table
Mutually unambiguous compliance

Tables around us

Chronological tables

Basic dates in computer history

date
Event
1.
3000 BC.
Accounts in China
2.
1642
Summing car Pascal
3.
1694
Accounting machine Leibnitsa
4.
1801
Jacquar cards
5.
1830s
Programmable Babbja Machine
6.
1890
Hollyrite countable car
7.
1946
First EUM.
8.
1948
The invention of the transistor
9.
1964
The appearance of integrated circuits

schedule of lessons

TV program

Table D.I. Mendeleev

let's discuss

Tables are for describing a number of objects,
possessing identical sets of properties.
Specify objects and the same
Properties of objects
?

the National costume

In Spain, women's national clothing is magnificent
Dress with Bata de Cola swans, headdress - Mantilla
or Kofya de Papos, instrument - guitar and cassays.
In Russia, National Women's Clothing - Sarafan, Kokoshnik
or handkerchief. Tools - Balalaika and harmonica.
In India, women wear sari, chole, dupattu, and national
The tool is sitar.
Bata de Cola is a magnificent dress with flocks and frills.
Mantilla - lace cape
Kofya de Pospos - lace cape on the head with high raised
base
Sari - a material of 5-7 meters long, which is special
The way turns around the body.
Choli is a short T-shirt dressed in Sari.
Dupaatta - light silk handkerchief.

the National costume
Country
Type of dress
Headdress
Tool
Spain
Dress
Bata de Cola.
Mantilla,
Kofya de Pospos
Guitar,
castanets
Russia
Sarafan.
India
Sari, Choli.
Balalaika,
Kokoshnik, scarf.
harmonic
Dupatta
Sitar
Information in the table is visual, compact,
Easy to foresee.

Table structure

Title
Head Table
B.
ABOUT
TO
ABOUT
IN
AND
TO
Programmer
Strings
CELL
Graphs (columns)

Table design rules

1. The title of the table should give
The idea of \u200b\u200bthe contained in it
information.
2. The headlines of the graph and lines must be brief.
3. The table must contain units
Measurements.
4. All table cells must be filled.
If necessary, they are asked the following
Signs:
? - data are unknown;
- data is impossible;
- The data must be taken from
overlying cell.

Classification of tables

Types of tables
Simple
Tables
OS.
Ltd
Sophisticated
Tables
UN
OSO

Table type "Properties" (OS)

OS Tables contain information about
properties of individual objects belonging
one class.
Class name
Objects
Property Name 1 Property Name 2
...
Object name 1.
Object name 2.
...
The value of the properties of the object

Sample OS Type Table

Unusual things
View
Product
Year
manufacturing
Length
(m)
Country
Jumper
1999
Portugal
3
Scarf
1998
USA
1073
Sandals
2002
Pakistan
3.93
Sakvoyuzh
2003
Brazil
3.7

Ltd. Tables contain information
about some one property of object pairs,
Most often owned by different classes.
First name
class objects
The name of the second class of objects
Name of the 1st object
2nd class
Name of the 2nd object
2nd class
Name of the 1st object
First class
Name of the 2nd object
First class
Value Property Couple Objects
...

Examples of tables OOO

Estimates on computer science
Student
Period of study
I DNTV.
II CHTV.
1st half.
4
5
4
5
5
4
5
5
4
Period
Training Bautin D.
Student
Bautin Dima
Skolina Ira
Zaitsev Ilya
Skolina I.
Zaitsev I.
I DNTV.
4
5
5
II CHTV.
5
4
5
4
5
4
1st half.

Table type "Object objects-several"

Computer science and mathematics
Period of study
Student
I quarter
II quarter
Informatik
but
Mathematician
but
Informati
ka
Mathematician
but
Bautin
4
4
5
4
Dima
Skolina
5
5
5
5
Tables
UN type contain information
Ira
About multiple properties of several pairs
Zaitsev
4
3
4
4
Objects belonging to different classes.
Ilya

Table type "Object object objects"

Anthropometric data
and sports results
The exercise
Student
Height Weight,
cm
kg
Long jump
from place
Result,
cm
Evaluation
Running per 1000 m
Result,
Evaluation
from
Bautin D.
168
56
197
5
220
5
Zaitsev I.
159
46
178
4
263
4
OSO Types contain properties information
pairs of objects belonging to different classes,
and about single properties of objects of one of the classes.

Computing tables

Computing tables - tables in which


From the same table.
Product
Price, rub.)
Number of cost
Notebook
3
10
30
Album
5
4
20
Pen
10
5
50
...
Table type OS.

Computing tables

Man
Drink
Total
Dunno
Donut
Toropany
Pilyulkin
Kvass
2
0
0
1
3
Hazing
1
3
2
0
6
Syrup
1
2
0
0
3
Castor oil
0
0
0
1
1
TOTAL:
4
5
2
2
13

Solution of logical tasks using multiple tables

Objects of two classes may be
in relation to mutually unambiguous
Compliance:
1) in these sets the same amount
objects;
2) each object of the 1st set is associated

2nd set;
3) each object of the 2nd set is associated
object
1st set.

let's discuss

?
Masha, Olya, Lena and Valya play on one of the musical
Tools and speak in one of the foreign languages.
They are different tools and languages. Masha plays a piano.
A girl who speaks French playing a violin.
Olya plays a cello. Masha does not know italian
Language, and Olya does not speak English. Lena does not play on
The harp, and the cellist does not speak Italian.
Determine which tool is playing each of
Girls and what foreign language she owns.
Girl
Musical
tool
Foreign
language

The solution of the problem

Enthusiasm
Piano
Music violin
Cello tool
Girl
Masha
Olya
Lena
1
1
Harp
French
Foreign German
language
English
Italian
Olya
Masha
Playing
on cello
on the
Lena
does not play
Playing
on the piano
Arfe
0
Valya

The solution of the problem

Enthusiasm
Piano
Music violin
Cello tool
Harp
Girl
Masha
Olya
Lena
Valya
11
0
0
0
0
0
1
0
0
11
0
0
0
0
00
1
French
Foreign German
language
English
Italian
Fill the first part
Tables

The solution of the problem

Enthusiasm
Piano
Music violin
Cello tool
Harp
Girl
Masha
Olya
Lena
Valya
1
0
0
0
0
0
1
0
0
1
0
0
0
0
0
1
French
1
Foreign German
language
English
Italian
0
0
0
Masha
Sleepy
knows
Italian
Girl,
that
He speaks
French,
CIOLOCELECT
Olya
not
not
He speaks
English
in Italian
playing the violin

The solution of the problem

Enthusiasm
Girl
Masha
Olya
Lena
Valya
1
0
0
0
0
0
1
0
0
1
0
0
Harp
0
0
0
1
French
0
0
1
0
0
1
0
0
1
0
0
0
0
0
0
1
Piano
Music violin
Cello tool
Foreign German
language
English
Italian
We get that the hobbies of Masha - Piano and English,
Oli - Cello and German, Lena - Violin
And French, Vali - Harp and Italian.

The most important thing

Tables are used to describe a number.
objects possessing the same
set properties.
The table consists of columns and lines.
The information presented in the table
Visual, compact, easy to see.
Table type "Object properties"
contains information about properties
individual objects belonging
one class.

The most important thing

Table type "object objects-one"
contains information about some one
Property of pair of objects, most often
belonging to different classes.
Computationally called tables, where
The values \u200b\u200bof some properties are calculated
using the values \u200b\u200bof other properties
From the same table.

The most important thing

Objects of two classes are in
With respect to mutually unambiguous
Conformity, if:
- in these classes the same amount
objects;
- Each first class object is associated
specified property with only one
second class object;
- Each second class object is associated
specified property with only one
First class object.

let's discuss

?
1. Give examples of tables with which
You faced life.
2. Is it always convenient to a table
Presentation of information?
3. What advantages provide
Table models compared to
verbal description?
4. any verbal description can
Replace table?
5. What rules should be held
When drawing up tables?
6. Give an example of the OS table.
7. Give an example of the Table LLC.





Table Filling Rules 1. Table heading should give an idea of \u200b\u200bthe information contained in it. 2. The headlines of the graph and lines must be brief. 3. The table must contain units of measurement. 4. All table cells must be filled. If necessary, they enter the following signs :? - data are unknown; - data is impossible; - data is impossible; - The data must be taken from the overlying cell. - The data must be taken from the overlying cell.




OS Tables contain information about the properties of individual objects belonging to one class; OS Tables contain information about the properties of individual objects belonging to one class; Each string contains information about one object; Each string contains information about one object; Each column contains a separate characteristic (property) of all class objects. Each column contains a separate characteristic (property) of all class objects. Table Type "Property Object"


Examples of Type-Property Types Autopulating Copyright 1 Belyaev A.R. Man amphibian Kerwood D. Straws of the North Turgenev I.S. Tale and stories olesha Yu.K. Favorites19875 home library (objects books, properties -, author, name, year of publication, regiment)


Examples of Table Types Type-Property Type Merities Humidity (%) Snow-3, without precipitation fog1, rain3, information model of the weather status change




Object Table Tables Type OO contain information reflecting the relationship between different objects; OO Types contain information reflecting the relationship between different objects; At the intersection of rows and columns reflects the relationship between objects of different classes; At the intersection of rows and columns reflects the relationship between objects of different classes; At the intersection of rows and columns reflects the relationship between different objects of the same class. At the intersection of rows and columns reflects the relationship between different objects of the same class.


Examples of objects such as "Object Object" TablekiRIRALGEBRACHIMIMIFizer Belyaev R Volkov and Galkina N Ivanov T Perfection (objects of different classes: students and objects)






Tables of type "Binary Matrix" Tables Type DM contain information about the relationships of objects in the form of numbers: zeros and units; DM Tables contain information about the relationships of objects in the form of numbers: zeros and units; In the tables representing binary matrices, the qualitative nature of communication between objects is reflected (there is a road or not, visits or not, etc.); In the tables representing binary matrices, the qualitative nature of communication between objects is reflected (there is a road or not, visits or not, etc.); DM Tables are used to solve logical tasks. DM Tables are used to solve logical tasks.


Examples of Tables of type "Binary Matrix" StudentComputerGeattergeanTeeMusca Belyaev R Volkov and Galkina N Ivanova T Hobbies, Hobbies (1 - Yes, 0 - No)


Examples of Tables of type "Binary Matrix" Servers C1S2S3S4S5 C C C C with C with Binary Matrix Determine which server is nodal if it directly be associated with all other servers.


Solution of logical tasks using tables of DM Task: Task: 4 teenagers learn at school: Ivan, Peter, Alexey and Andrei. The following is known about them: 1. Ivan and Alexey were present in the gym, when the athlete was engaged there. 2. Peter and hockey player together were on a basketball player training. 3. Hockey player was friends with Andrey, and now indeed with Ivan. 4. Ivan does not like basketball. Who is interested in?




Solving the problem of the football player player's soccer player Ivan 10 - (from claim 4) 0 - (from clause 1) 0 - (from clause 3) PETR00 - (from clause 2) 1 Alexei000 - (from paragraph 1) 1 Andrei (from p. 3)