A set of useful phrases for
communication / writing:
In this database, the primary key can be
field cannot be used as a primary key, because ...
support to classmates, help in the assimilation of the material. Be
restrained and responsive to others.
Data Types, Basic Database Concepts
Course of the lesson
End of the lesson
Class room management: greeting,
Reactivating prior knowledge:
Students repeat the main points of the
last lesson using the online resource https://learningapps.org/
At the end of the time, the teacher
needs to display the correct answer and discuss with the students.
Introduction lesson topic,
objectives and discussion of assessment criteria.
The topic and objectives of the lesson
are displayed on the screen.
Have students self-compose assessment
criteria. If necessary, bring students to the criteria for the lesson.
Learning new material.
Students watch the video. Before
watching, students should familiarize themselves with the questions for
discussion and try to find answers when watching the video
Division into groups
Students divided into 3 groups
Students in the group should discuss the
following questions. Listen to everyone’s opinion and prepare a complete
answer with examples for an answer
Questions for discussion:
1. What types of keys are in the
2. Why do I need a primary key?
3. What is a foreign key?
4. How many tables are considered on an
5. How to distinguish a primary key from
a foreign key?
Students need to be interviewed to gain
an understanding of new material.
Task 1. Using the
prepared material Definition 1, students in the group must draw up a
definition of the primary and foreign key.
The teacher displays the correct option
on the board, students check their results. If necessary, discuss emerging
issues. Students should save the correct version of the definition in their
resource or write in notebooks.
Task 2. (G)
- Build an example relational database
-Define the primary key for this
-Explain your choice
After listening to the options of each
group, the teacher needs to give feedback to the work of each group.
Identifying the positive and negative points in the work.
Orally frontally answer questions on the
flipchart. Summarize the lesson.
Were the lesson objectives/learning
objectives realistic? Did I stick to timings?
What changes did I make from my
plan and why?
Did all learners achieve the LO?
Did my planned differentiation work
If not, why?
What two things went well (consider both
teaching and learning)?
What two things would have improved the
lesson (consider both teaching and learning)?
What have I learned from this lesson
about the class or achievements/difficulties of individuals that will inform
my next lesson?