To use presentation previews, create an account for yourself ( account) Google and log in: https://accounts.google.com

Slide captions:

Tabular information models Table structure and design rules

A correctly formatted table has the following structure: Table number General table title Name column Name of rows column cell row

Simple tables Tables of the “objects - properties” type (OS) A table of the “objects - properties” type is a table containing information about the properties of individual objects belonging to the same class. General form OS type tables: Object class name Property name 1 Property name 2 ... Object name 1 Object name 2 ... Object property value

example Pupils of the 2nd “in” Pupil Year of birth Height (cm) Weight (kg) Ivanov Petya Petrov Vanya Ryzhkov Kolya

Name of the first class of objects Name of the second class of objects Name of the 1st object of the second class Name of the 2nd object of the second class ... Name of the 1st object of the first class Name of the 2nd object of the first class Simple tables Tables of the “objects - objects” type (OO) Table type "objects - objects" - this is a table containing information about some single property of pairs of objects, most often belonging to different classes. General view of a table of type OO: Value of a property of a pair of objects

example Computer science grades for 7th grade students Student Study period 1st quarter 2nd quarter 1st half year Butin Dima 4 5 5 Golubev Misha 4 4 4 Kulikov Ivan 5 5 5

Complex tables Object-Object-Multiple (UN) table A table containing information about multiple properties of pairs of objects belonging to different classes. General view of the UN type table:

Name of the first class of objects Name of the second class of objects Name of the 1st object of the second class Name of the 2nd object of the second class ... Name of the 1st property of a pair of objects Name of the 2nd property of a pair of objects ... Name of the 1st property of a pair of objects Name of the 2nd property pairs of objects ... Name of the 1st object of the first class Name of the 2nd object of the first class Values ​​of the properties of pairs of objects

Grades for half a year and for a year Last name Subject Russian language Mathematics ... I II Year I II Year Butin Dima Golubev Misha Kulikov Ivan example

Complex tables Table of the “objects-properties-objects” (OPO) type A table containing information about the properties of pairs of objects belonging to different classes, and about single properties of objects of one of the classes. General view of the OCO type table:

Name of a class of objects for which there are individual properties Names of individual properties Name of a class of objects for which there are only paired properties Names of an object from the 1st pair Names of an object from the 2nd pair Names of an object from the 3rd pair... Names of properties of a pair of objects Names of properties pairs of objects Names of properties of a pair of objects ... Names of objects Property values

example Progress of students of the 4th “b” Subject Teacher Number of lessons in the school year Pupil Ivanov Petya Petrov Vanya I half-year II half-year Year I half-year II half-year Year Russian language Koshkina A.B. 160 Mathematics Kuznetsov V.G. 160 Natural history Sidorova D.E. 64

Computer science teacher, Municipal Educational Institution “Secondary School No. 20” Pospelova G.V. Novomoskovsk, Tula Region

Topic "Tabular Information Models"

7th grade (UMK L.L. Bosova)

Lesson objectives:

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

expand students’ understanding of iconic information models;

streamline students’ existing ideas about tabular information models, repeat/develop skills in creating tables.

Tasks:

Educational:

consolidate students’ understanding of models and modeling, types of information models, mathematical models, tabular information models;

systematization of acquired knowledge.

Educational:

development of analytical-synthesizing thinking, formation of skills to observe, draw conclusions, development of resourcefulness, ability to overcome difficulties to achieve the intended goal.

Educational:

nurturing a positive attitude towards knowledge, instilling interest in Computer Science, developing self-organization and self-control skills.

Lesson type: lesson on consolidating the material being studied and developing practical skills​ and skills.

Lesson type: combined.

Forms of work in the lesson: independent, individual work.

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

Equipment:

Laptops;

Multimedia complex (PC, projector, interactive whiteboard);

Presentation 7_2.5.1 “Tabular information models.”

Basic concepts:

model,

information model,

sign information model,

tabular information model.

During the classes

1) Updating and checking the assimilation of the studied material

Issues discussed:

What is a model?

What is modeling?

What models are called full-scale?

What models are called information models?

What types of information models are there?

What information models are most common in communication?

In what cases is it better to use lists instead of text descriptions?

(numbered, labeled, multi-level)?

Why natural language is not always suitable for creating information

models?

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

1) Answer: the speed of sound propagation on a winter day at a temperature of – 35 0 C is equal to 310 m/sec, and on a summer day – at a temperature of + 30 0 C is equal to 352 m/sec.

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

2b) Answer: the time after which the cyclists will meet is calculated by the formula: minutes.

3) Answer: time is calculated based on the formula. Because t = 8 hours, B = 24 hours, then = =12 hours.

4) Answer: the wire is definitely enough to mark the flowerbed d) and not enough for option b).

When solving options a) and c), you need to mentally “unbend the steps” and make sure that in each of these cases you get a 6*10 rectangle, and, therefore, there is enough wire. 2) Explanation of new material:§ 2.5.1.

Tabular information models.

(Accompanied by presentation 7_2.5.1_ Tabular information models")

The explanation of the new material is organized in the form of a conversation, supported by a demonstration of the presentation “Tabular Information Models” (slides 2-4). It is advisable to use, to the maximum extent possible, the existing experience of schoolchildren in using tabular information models. It is important to lead students to the conclusion that the information presented in the table is visual, compact and easy to see.

Students must look at the drawings and indicate the objects and the same properties of the objects (Slide 5). The drawings depict girls in national costumes (Spanish, Russian, Indian). Each costume has a dress, headdress and musical instruments.

Make a table “National costumes” (Slide 6.)

Emphasize that the information in the table is clear, compact, and easily visible.

Give examples of tabular information models (tables) in which the information is clear, compact, and easily visible. (Slide 7).

Particular attention should be paid to the rules for formatting tables. In the future, these rules must be strictly followed. (Slide 9-11).

Note that the entire set of tables can be divided into simple and complex.

It is known that children quickly get tired in class because they are in a static position for a long time.

Physical education sessions help prevent and relieve mental fatigue.

Physical education is held 12-20 minutes from the start of the lesson.

Duration 1-2 minutes.

(Electronic physical training for the eyes is carried out.)

4) Practical work.

The practical part of the lesson (tasks No. 1 and No. 2 of work No. 6 “Creating tabular models”) is devoted to developing skills in creating and formatting tables.

When completing assignment #1, “Giants,” it is important to ensure that students do not create five different tables, but rather edit the first table using insertion and deletion operations on rows and columns, using auto-formatting, and implementing data sorting.

In task No. 2 “Nature of Russia”, students not only practice a technological technique (merging cells), but also select the information needed to fill out a table from a text document.

5) Homework

§ 2.5 (pp. 58-60); Answers to questions No. 1 – 6 (p. 69)

6) Reflection

Each student has cards on the table (green, yellow, red). When leaving class, you need to leave one of them on the teacher’s desk:

Green - I am satisfied with the lesson, the lesson was useful for me, I worked hard in the lesson, I received a well-deserved grade, I understood everything that was said in the lesson.

Yellow - The lesson was interesting, I took an active part in it, the lesson was useful to me to a certain extent, I answered from my seat, I managed to complete a number of tasks, I felt quite comfortable in the lesson.

Red - I received little benefit from the lesson, I didn’t really understand what was going on, I didn’t really need it, I wouldn’t do my homework, I wasn’t prepared for the answers in the lesson.

Literature

Computer Science and ICT: textbook for 7th grade/ L. L. Bosova. – M.: BINOM. Knowledge Laboratory, 2009. - 229 p.: ill. - ISBN: 978-5-9963-0092-1..

Computer science lessons in grades 5-7: Methodological manual / L.L. Bosova, A.Yu. Bosova. - 2nd ed., rev. and additional - M.: BINOM. Laboratory of Knowledge, 2005. - 320 pp.: ill.

Lesson 7 “Tabular information models. Tables of the "object - object" and "object - properties" types"

Target: introduce students to tabular information models.

Lesson objectives:

1) educational:

• develop skills in working with models;
• Introduce students to the concepts: “table", "OO type table", "OS type table", "object", "object class", "object property"
• Learn to give examples of tabular IMs of various types

2) developing:

• development of students' cognitive interest, creative activity of students;
• developing the ability to listen to comrades and teachers;
• development of students' logical thinking.

3) educational:

• instill interest in the subject;
• cultivate an emotionally positive orientation towards practical activities.

Lesson type: lesson on communicating new knowledge

Lesson methods: explanatory-illustrative

Lesson steps:

Organizing time:

1. missing persons check
2. checking homework (see work on the basic definitions of the previous topic)

Explanation of new material:

Another common form of information models is a table or tabular IM.

In everyday life, we can come across such tables as calculation tables, medical tables, etc.

When compiling tables, it includes only the information that interests the user. For example, the presentation of mathematical functions, static data, train schedules, airplanes, lessons, etc.

Thus, a table is a universal means of presenting information. The table can also reflect some processes occurring over time. (Table No. 1)

In this table, readings were taken over 5 days at the same time of day. Looking at the table, it is easy to compare different days in terms of temperature, humidity, etc. Therefore, this table can be considered as an IM measurement of weather conditions.

In this table, rows containing events or dates are called objects. And the information contained in the columns of the table about the state of the weather on a given day is called its (i.e., object’s) properties.

The object is what we are talking about.

A column that contains many objects combines them into a class of objects with one name (in this case, Day).

An object class is a class of objects united by some common feature.

This table also contains the characteristics of these objects or their properties.

Properties – characteristics, attributes of an object. (Each property has its own name and meaning)

So, in this table, for example, the object is the day of the month.

The object class is the entire “Day” column, and the object properties are: precipitation, temperature, etc.

This table can be classified as the most used type of table. These tables are called OS type tables.

An OS type table is a table in which objects belonging to the same class are considered and all properties relate not to a group of objects, but to a single object.

OS table schema

Rules for constructing OS tables.

1. Select objects and properties
2. Name the object class
3. Enter the name of the objects and their properties
4. Enter the property value

Another common type of table is the OO table.

OO type table is a table that describes pairs of objects that have only one property.

For example, see table. 2

OO table schema

The procedure for constructing the OO table:

1. Select objects and properties
2. Name the class of the first and second objects
3. Enter the names of the first and second objects
4. Enter property values ​​into cells

Consolidation stage:

1. What advantages do tabular models provide over verbal descriptions?
2. Can any verbal description be replaced by a table?
3. Give examples of tables that you have encountered in life.
4. Is tabular presentation of information always convenient?

Practical work:

Homework:

1. Learn notes in a notebook
2. Ugrinovich N.D. Computer Science and information Technology, 2005 Page …. P. ….

Preview:

To use presentation previews, create a Google account and log in to it: https://accounts.google.com

Slide captions:

Tabular Information Models

Tables around us Computing Medical

A table is a universal means of presenting information

Day Precipitation Temperature (degrees C) Pressure (mm Hg) Humidity (%) 03/15/97 Snow -3.5 746 67 03/16/97 No precipitation 0 750 62 03/17/97 Fog 1.0 740 100 03/18/97 Rain 3.4 745 96 03/19/97 No precipitation 5.2 760 87 Table 1. WEATHER Information model for measuring weather conditions.

Day Precipitation Temperature (degrees C) Pressure (mm Hg) Humidity (%) 03/15/97 Snow -3.5 746 67 03/16/97 No precipitation 0 750 62 03/17/97 Fog 1.0 740 100 03/18/97 Rain 3.4 745 96 03/19/97 No precipitation 5.2 760 87 Table 1. WEATHER Objects Properties of objects

The object is what we are talking about. An object class is a class of objects united by some common feature. Properties – characteristics, attributes of an object. (Each property has its own name and meaning)

Day Precipitation Temperature (degrees C) Pressure (mm Hg) Humidity (%) 03/15/97 Snow -3.5 746 67 03/16. 97 No precipitation 0 750 62 03/17/97 Fog 1.0 740 100 03/18/97 Rain 3.4 745 96 03/19/97 No precipitation 5.2 760 87 Table 1. WEATHER Object Properties of objects Object Object Object Object Property Property Property Property Class objects

An OS type table is a table in which objects belonging to the same class are considered and all properties relate not to a group of objects, but to a single object.

Name of object class Name of properties Name of objects Property values ​​Rules for constructing OS tables. Select objects and properties Name the class of objects Enter the name of the objects and their properties Enter the value of the properties OS table schema

OO type table is a table that describes pairs of objects that have only one property.

Student Study period I quarter. II quarter 1st half. Bautin Dima 4 5 5 Shkolina Ira 5 5 5 Zaitsev Ilya 4 4 4 Table 2. Grades in computer science

Name of the class of the first objects Name of the class of the second objects Name of the second objects Name of the first objects Value of the property of a pair of objects Order of constructing the OO table: Select objects and properties Name the class of the first and second objects Enter the names of the first and second objects Enter the property values ​​in the cells OO table layout

Student Study period I quarter. II quarter 1st half. Bautin Dima 4 5 5 Shkolina Ira 5 5 5 Zaitsev Ilya 4 4 4 Table 2. Grades in computer science class of first objects class of second objects of objects of objects of objects of objects properties of pairs of objects properties of pairs of objects properties of pairs of objects properties of pairs of objects properties of pairs of objects

What advantages do tabular models provide over verbal descriptions? Can any verbal description be replaced by a table? Give examples of tables that you have encountered in life. Is tabular presentation of information always convenient? let's discuss

Slide 1

Tables of the “object-property” type Table. Home library Number Author Name Year Regiment 0001 Belyaev A.R. Amphibian Man 1987 5 0002 CurwoodD. Tramps of the North 1991 7 0003 Turgenev I.S. Novels and short stories 1982 1 0004 Olesha Yu.K. Favorites 1987 5 0005 Belyaev A.R. Zvezda KETS 1990 5 0006 Tynyanov Yu.N. Kyukhlya 1979 1 0007 Tolstoy L.N. Novels and stories 1986 1

Slide 2

Slide 3

Slide 4

Why do you need many models? study of body structure, fitting of clothes, study of heredity, training of rescuers, registration of citizens of the country

Slide 5

What is a model? A model is a simplified likeness of a real object. The model reflects only some properties of the object that are significant from the point of view of the purpose of modeling.

Slide 6

What is modeling? Modeling is a human activity to create a model (full-scale or informational)

Slide 7

The concept of a modeling object must be understood in the broadest sense. It can be a material object: a ship, a comet, a living cell; natural phenomenon: thunderstorm, solar eclipse; process: rocket flight, changes in the value of shares on the stock exchange and much more.

Slide 8

Define formalization. Formalization is the result of a transition from the real properties of a modeling object to their formal designation in a certain sign system.

Slide 9

1) What is a simplified representation of a real object called? original; prototype; model; system. Answer: 3.

Slide 10

2) The process of building models is called: modeling; design; experimentation; design. Answer: 1. When is modeling used?

Slide 11

3) An information model consisting of rows and columns is called: a graph; scheme; drawing; table. Answer: 4. Besides informational ones, what are the nature of models?

Slide 12

4) What is the general name of models that represent a set of useful and necessary information about the object? material; informational; subject; verbal; Answer: 2.

Slide 13

5) The geometric model of a right triangle is: layout; definition; drawing; A+ B+ C=180°, AB2=AC2+BC2. Answer: 3.

Slide 14

Models by structure tabular models (matching pairs) hierarchical (multi-level) models network models(graphs) start finish 1 3 2 4 6 7 8 5

Slide 15

Slide 16

Tabular Models– objects and their properties are presented in the form of a list, and their values ​​are placed in rectangular cells. The list of objects of the same type is placed in the first column (or row), and the values ​​of their properties are placed in the following columns (or rows)

Slide 17

Task: Using the table, solve the problem: Masha, Olya, Lena and Valya are wonderful girls. Each of them plays a musical instrument and speaks one of the foreign languages ​​(English, Italian, French, Spanish). Their instruments and languages ​​are different: Masha plays the piano; a girl who speaks French and plays the violin; Olya plays the cello; Masha does not know Italian, and Olya does not speak English; Lena doesn't play the harp, and the cellist doesn't speak Italian. Determine what instrument each girl plays and what language she speaks. piano creaking viol harp English Italian French Spanish Masha Olya Lena Valya

Slide 18

A verbal description of the costs of planting 1 hectare of orchards and berry fields in the central regions of Russia in 1980 is given. Build a model that would help to visualize this picture more clearly. Costs for planting 1 hectare of orchards and berry fields in the central regions of Russia in 1980. Payment for labor when planting gooseberries - 167 rubles. Fuel, pesticides and herbicides for planting strawberries - 115 rubles. Fertilizers for planting black currants - 585 rubles. Material for a trellis when planting raspberries - 780 rubles. Fuel, pesticides and herbicides for planting black currants - 90 rubles. Planting material for planting strawberries - 1,750 rubles. Labor remuneration for planting black currants is 150 rubles. Convenience of rhenium when planting raspberries - 532 rubles. Fertilizers when planting gooseberries - 555 rubles. Fuel, pesticides and herbicides for planting raspberries - 89 rubles. Planting material for planting gooseberries - 594 rubles. Other expenses when planting strawberries - 584 rubles. Labor remuneration for planting raspberries - 235 rubles. Fuel, pesticides and herbicides for planting gooseberries - 92 rubles. Fertilizers for planting strawberries - 313 rubles. Other expenses when planting black currants - 260 rubles. Planting material for planting raspberries - 1200 rubles. Remuneration for planting strawberries - 316 rubles. Other expenses when planting gooseberries - 388 rubles. Planting material for planting black currants - 1100 rubles. Other expenses when planting raspberries - 474 rubles.

Slide 19

Costs for planting 1 hectare of orchards and berry fields in the central regions of Russia in 1980 gooseberries raspberries currants strawberries Labor payment for planting 167.00 rubles. 235.00 rub. 150.00 rub. RUB 316.00 Fuel, pesticides and herbicides 92.00 rub. 89.00 rub. 90.00 rub. 115.00 rub. Material for the trellis RUR 780.00 Planting material 594.00 rub. RUB 1,200.00 RUB 1,100.00 RUB 1,750.00 Other expenses upon landing 388.00 rub. 474.00 rub. 260.00 rub. 584.00 rub. Fertilizers during planting RUB 555.00 532.00 rub. 585.00 rub. RUB 313.00

Slide 20

Slide 21

Graphic information models (diagram, structure, graph) A diagram is a graphical representation of the composition and structure of a complex system. Structure is the order in which the elements of a system are combined into a single whole. A graph is a model of a process.

Slide 23

Slide 24

1. Tables of the “object-property” type 2. Tables of the “object-object” type 3. Binary matrices

Slide 25

Tables of the “object-property” type Table. Weather Day Precipitation Temperature Pressure Humidity 03/15/2015 Snow -3.5 746 67 03/16/2015 No precipitation 0 750 62 03/17/2015 Fog 1.0 740 100 03/18/2015 Rain 3.4 745 96 03/19/2015 Without precipitation 5.2 760 87

Slide 26

Tables of the “object-object” type Table. Roads This table contains information about the availability of direct roads between settlements Dachas Ozernaya Podgornaya Elovo Beavers Dachas 1 1 1 1 0 Ozernaya 1 1 0 1 1 Podgornaya 1 0 1 0 1 Elovo 1 1 0 1 1 Beavers 0 0 1 1 1

Slide 27

Binary Matrices Table. Electives The table shows information about four students attending three electives. It should already be clear to you that one means a visit, zero means a non-visit. The tables, which are binary matrices, reflect the qualitative nature of the relationship between objects. Student Geology Floriculture Dancing Rusanov 1 0 1 Semenov 1 1 0 Zotova 0 1 1 Shlyapina 0 0 1 Table design rules
Table of type "objects-properties"
Object-object-one tables
Calculation tables
Solving logical problems

Keywords

Table of type "objects-properties"
Type table
"objects-objects-one"
Calculation table
One-to-one correspondence

Tables around us

Chronological tables

Key dates in the history of computers
№
date
Event
1.
3000 BC
Accounts in China
2.
1642
Pascal's summing machine
3.
1694
Leibniz calculating machine
4.
1801
Jaccard punch cards
5.
1830s
Babbage's programmable machine
6.
1890
Hollerith calculating machine
7.
1946
First computer
8.
1948
Invention of the transistor
9.
1964
The emergence of integrated circuits

Timetable

TV program

Table D.I. Mendeleev

let's discuss

Tables are compiled to describe a number of objects,
having the same sets of properties.
Specify the objects and the same
object properties
?

National Costume

In Spain, the national dress of women is the curvy
dress with Bata de cola flounces, mantilla headdress
or cofia de papos, the instrument is a guitar and castanets.
In Russia, women's national clothing is a sundress, kokoshnik.
or a scarf. Instruments - balalaika and accordion.
In India, women wear a sari, choli, dupatta, and the national
The instrument is the sitar.
Bata de cola - a fluffy dress with flounces and frills.
Mantilla - lace cape on the head
Cofia de papos - a lace cape on the head with a high
basis
Sari is a material 5-7 meters long, which is specially
wraps itself around the body.
Choli is a short T-shirt worn under a sari.
Dupatta is a light silk scarf.

National Costume
A country
Dress type
Headdress
Tool
Spain
Dress
Bata de cola
Mantilla,
coffee de papos
Guitar,
castanets
Russia
Sundress
India
Sari, choli
Balalaika,
Kokoshnik, scarf
harmonic
Dupatta
Sitar
The information in the table is clear, compact,
easily visible.

Table structure

HEADLINE
TABLE HEAD
B
ABOUT
TO
ABOUT
IN
AND
TO
PROGRAM
LINES
CELL
COLUMN (COLUMN)

Table design rules

1. The table title should give
idea of ​​what it contains
information.
2. Column and line headings should be short.
3. The table must indicate units
measurements.
4. All table cells must be filled in.
If necessary, enter the following:
signs:
? – data unknown;
– data is not possible;
– data must be taken from
overlying cell.

Classification of tables

Table types
Simple
tables
OS
OOO
Complex
tables
UN
CCA

Table of type "objects-properties" (OS)

OS type tables contain information about
properties of individual objects belonging to
one class.
Class name
objects
Property name 1 Property name 2
...
Object name 1
Object name 2
...
Object property value

OS type table example

Unusual things
View
products
Year
manufacturing
Length
(m)
A country
Jumper
1999
Portugal
3
Scarf
1998
USA
1073
Sandals
2002
Pakistan
3.93
Travel bag
2003
Brazil
3.7

LLC type tables contain information
about some single property of pairs of objects,
most often belonging to different classes.
First name
object class
Name of the second object class
Name of 1st object
2nd class
2nd object name
2nd class
Name of 1st object
first class
2nd object name
first class
Property value of a pair of objects
...

Examples of LLC tables

Computer Science grades
Student
Period of study
I quarter
II quarter
1st half.
4
5
4
5
5
4
5
5
4
Period
training Bautin D.
Student
Bautin Dima
School Ira
Zaitsev Ilya
Shkolina I.
Zaitsev I.
I quarter
4
5
5
II quarter
5
4
5
4
5
4
1st half.

Table of type "objects-objects-multiple"

Computer Science and Mathematics Grades
Period of study
Student
I quarter
II quarter
Informatics
A
Mathematician
A
Informati
ka
Mathematician
A
Bautin
4
4
5
4
Dima
School
5
5
5
5
Tables
UN types contain information
Ira
on several properties of several pairs
Zaitsev
4
3
4
4
objects belonging to different classes.
Ilya

Table of type "objects-properties-objects"

Anthropometric data
and sports results
Exercise
Student
Height Weight,
cm
kg
Long jump
from place
Result,
cm
Grade
1000 m run
Result,
Grade
With
Bautin D.
168
56
197
5
220
5
Zaitsev I.
159
46
178
4
263
4
OCO type tables contain information about properties
pairs of objects belonging to different classes,
and about single properties of objects of one of the classes.

Calculation tables

Computational tables are tables in which


from the same table.
Product
Price, rub.)
Quantity Cost
Notebook
3
10
30
Album
5
4
20
Pen
10
5
50
...
OS type table

Calculation tables

little man
Drink
Total
Dunno
Donut
Toropyzhka
Pilyulkin
Kvass
2
0
0
1
3
Soda
1
3
2
0
6
Syrup
1
2
0
0
3
Castor oil
0
0
0
1
1
Total:
4
5
2
2
13

Solving logical problems using multiple tables

Objects of two classes can be located
in relation to one-to-one
matches:
1) these sets have the same number
objects;
2) each object of the 1st set is connected

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

let's discuss

?
Masha, Olya, Lena and Valya play on one of the musical
instruments and speak one of the foreign languages.
Their tools and languages ​​are different. Masha plays the piano.
A girl who speaks French plays the violin.
Olya plays the cello. Masha doesn't know Italian
language, and Olya does not speak English. Lena doesn't play
harp, and the cellist does not speak Italian.
Determine what instrument each player plays.
girls and what foreign language she speaks.
Girl
Musical
tool
Foreign
language

The solution of the problem

Enthusiasm
Piano
Musical Violin
Cello instrument
Girl
Masha
Olya
Lena
1
1
Harp
French
Foreign German
language
English
Italian
Olya
Masha
plays
on cello
on
Lena
does not play
plays
on the piano
harp
0
Valya

The solution of the problem

Enthusiasm
Piano
Musical Violin
Cello instrument
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
Let's fill out the first part
tables

The solution of the problem

Enthusiasm
Piano
Musical Violin
Cello instrument
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
does not own
knows
Italian
Girl,
which
speaks
French,
Cellist
Olya
Not
Not
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
Musical Violin
Cello instrument
Foreign German
language
English
Italian
We get that Masha’s hobbies are piano and English,
Olya – cello and German, Lena – violin
and French, Vali - harp and Italian.

The most important

Tables are used to describe a series
objects that have the same
sets of properties.
The table consists of columns and rows.
The information presented in the table is
clear, compact, easy to see.
Table of type "objects-properties"
contains information about properties
individual objects belonging to
one class.

The most important

Objects-objects-one table
contains information about some one
property of pairs of objects, most often
belonging to different classes.
Computational tables are those where
some property values ​​are calculated
using other property values
from the same table.

The most important

Objects of two classes are in
one-to-one relationship
compliance if:
- these classes have the same number
objects;
- every object of the first class is connected
given property with only one
object of the second class;
- every object of the second class is connected
given property with only one
first class object.

let's discuss

?
1. Give examples of tables with which
you have encountered in life.
2. Is tabular always convenient?
presentation of information?
3. What benefits do they provide?
tabular models versus
verbal description?
4. Is any verbal description possible?
replace with a table?
5. What rules should you follow?
when creating tables?
6. Give an example of an OS table.
7. Give an example of an LLC table.