1Lesson №56 Primary key in Database Lesson plan

4 term.

Long-term Plan Unit: 10.4А Information Systems

Lesson: №56

School: 

Date:

Teacher Name:

Grade: 10

Number Present:  

Absent:

Theme of the Lesson:

Primary key in database

Learning

Objectives

10.3.1.3 determine the primary key in the database

Lesson

Objectives

Define a primary key in a database

Assessment criteria

Understanding:

-list types of keys in Database

Synthesis:

-make the definition of primary key

-make the definition of foreign key

Analyses:

-distinguish the differences between types of keys in Database

-define primary key in Database

Language

Objectives

Students can:

Discuss various types of keys in the database

Explain the difference between the types of keys in the database

Subject vocabulary and terminology:

Field, record, database, DBMS, primary key, foreign key

A set of useful phrases for communication / writing:

In this database, the primary key can be identified ...

This field cannot be used as a primary key, because ...

Values

Instilled

Provide support to classmates, help in the assimilation of the material. Be restrained and responsive to others.

Previous

Learning

MSExcel, Data Types, Basic Database Concepts

Course of the lesson

Planned
Timings

Planned Activities

Resources

Class start

0-1 minutes

2-5 minutes

6-8 minutes

Mid-lesson

9-18 minutes

19-20 minutes

21-26 minutes

27-31 minutes

32-36 minutes

End of the lesson

37-40 minutes

Class room management: greeting, checking absentees.

Reactivating prior knowledge:

Students repeat the main points of the last lesson using the online resource https://learningapps.org/

Assessment:

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

Discussion:

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 database?

2. Why do I need a primary key?

3. What is a foreign key?

4. How many tables are considered on an example?

5. How to distinguish a primary key from a foreign key?

Assessment.

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.

Assessment

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 database

-Explain your choice

Assessment

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.

Reflection

Orally frontally answer questions on the flipchart. Summarize the lesson.

Flipchart

clck.ru/GgPz5

clck.ru/GhYHa

Flipchart

https://www.youtube.com/watch?v=6fXVL_uJ1I0

https://castlots.org/razdelit-na-gruppy/

Flipchart

Flipchart

Definition 1

Flipchart

Flipchart

Differentiation

Assessment

Health and Safety

Reflection

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 well?

If not, why?

Summary Evaluation

What two things went well (consider both teaching and learning)?

1:

2:

What two things would have improved the lesson (consider both teaching and learning)?

1:

2:

What have I learned from this lesson about the class or achievements/difficulties of individuals that will inform my next lesson?