2Lesson №59 Database development Lesson plan
Оценка 5

2Lesson №59 Database development Lesson plan

Оценка 5
docx
09.05.2020
2Lesson №59 Database development Lesson plan
2Lesson №59 Database development Lesson plan.docx

4 term.

Long-term Plan Unit: 10.4А Information Systems

Lesson: №59

School: 

Date:

Teacher Name:

Grade: 10

 

Number Present:  

Absent:

Theme of the Lesson:

Database Development

Learning

Objectives

10.3.2.3 create a multi-table database (SQL)

Lesson

Objectives

- create a multi-table database using SQL queries and constructor

Success

Criteria

Knowledge and understanding:

- to know types of relationships between tables in database;

- to know how to specify a primary key and foreign key in queries;

- to know queries for creating/working with a multi-table database;

 

Applying:

- make a query for linking tables in a multi-table database;

- make queries for selecting of data from a multi-table database

 

Analysis:

- to design a multi-table database;

- identify primary key in a multi-table database.

Language

Objectives

Specific vocabulary and terminology:

Multi-table database, foreign key, queries for selecting, data joining, types of connections.

 

Useful phrases for conversation / writing

To link these tables, we must use ... type of connection

To specify a foreign key, we use the command ...

Request ... is used to ...

Primary key in the table ... is the field ..., because ...

Values

Instilled

 

Ability to work in a team to achieve results.

Respect for other people's opinions.

Mutual respect and support.

Cross-curricular

Links

English (key words in queries)

Previous

Learning

Data types in MySQL DBMS;

Creating single-table databases.

Course of the lesson

Planned
Timings

Planned Activities

Resources

Beginning

0-2 minutes

 

3-4 minutes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

5-6 minutes

 

 

7-10 minutes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

11-14 minutes

 

 

 

 

 

 

 

 

 

Middle

15-23 minutes

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

24-27 minutes

 

 

 

 

 

 

 

28-32 minutes

 

 

 

 

 

 

 

33-36 minutes

 

 

 

 

 

 

End

37-40 minutes

 

 

 

Class room management: greeting, checking absentees.

 

Problem-solving situation:

The teacher reads the email that he received:

Dear students of the 10th grade!

We are going to expand our business;therefore, we ask you to develop a forum for our corporate website!

Our forum will serve as a place for sharing ideas and experiences for like-minded people.

Sincerely, Director of QZ-COMPANY!

 

The teacher asks questions:

-What is the forum?

-What data need to be stored?

-Is it possible to use one table in the database to organize a forum?

-If there will be one table, is it convenient to store and search for data?

 

 

Introduction lesson topic, objectives and discussion of assessment criteria.

 

Actualization of knowledge:

The teacher asks questions:

What is a primary key?

What is a foreign key and what is it used for?

There are 3 types of relationships between tables:

•one to one;

• one to many;

• many to many.

Give examples of each type of communication.

In 90% of cases using one-to-many communication.

 

How do you think, how many tables you need to create a forum?

What tables do we need?

What data will be in each of the tables?

 

Demonstration:the teacher demonstrates the structure of the future database consisting of three tables: Users, topics and messages.

The teacher explains the structure of the database.

Users must be registered, and they must have a key field, for example, EMAIL, so that each user is unique. Message and topic will have a unique ID field.

A user creates a topic and writes messages. In this case, the user can write messages in topics that are not created by him.

 

Practicalworkinpair:Each student pulls a random number out of the bag. Then pairs are formed on the basis of 1 and 2, 3 and 4, and so on.

If number of studentsis odd, one student works individually, with support of the teacher.

Tasks:

1. Write a query to create a database “forum”

2. Write a query to create the “users” table.

Students work in pairs, if it is necessary, they can use the Internet to find out information. After that you can discuss the result:

 

CREATE TABLE users (

    email varchar(30),

    name varchar(30),

    surname varchar(30),

    age int,

    PRIMARY KEY (email));

 

One of the students is called to the whiteboard. The teacher asks by analogy to write a query to create the "themes" table. Remind that we have to link the “email” field from the “users” table to the “author_email” field from the “themes” table. You need to know how to specify in the request which field will be a foreign key and which field to connect it with.

 

1. Students individually learn the process of creating a foreign key using the proposed resource.

 

2. The teacher asks to complete on the board the request to create the “themes” table. In the process of writing the request, students correct mistakes and give help for their classmate.

Discussion of the request:

 

CREATE TABLE themes (

    id int,

    topic varchar(20),

author_emailvarchar(30),

    PRIMARY KEY (id),

    FOREIGN KEY (author_email) REFERENCES users (email));

 

3. Using the structure proposed by the teacher and the previously obtained knowledge, the students independently in pairs write the third request for creating the table “messages”:

 

CREATE TABLE messages (

    id int,

    message text,

author_emailvarchar(30),

theme_idvarchar(30),

    PRIMARY KEY (id));

 

4. Students write requests to fill three tables with data on their own. At least 3 records in each table.

 

Explainingnewmaterial:the teacher explains what joining is and how to make it. Provides an example of a simple joining:

 

SELECT имена_столбцов_таблицы_1, имена_столбцов_таблицы_2 FROM имя_таблицы_1, имя_таблицы_2;

 

Demonstration: the teacher demonstrates and explains the requests:

1. Request to display information about the authors of topics on the forum:

SELECT users.name, themes.topic FROM users, themes WHERE users.email = themes.author_email;

 

2. Request for selecting of names and surnames of users and their messages:

SELECT users.name, users.surname, messages.message FROM users, messages WHERE users.email = messages.author_email;

 

Summary:

Students work in pairs and write a request that displays name and surname of a particular user and forum topics that he/she created.

Students can help to each other. Remind about logic operation AND from programming languages.

 

 

 

Reflection:

1. In your opinion, did you get useful knowledge in class today?

2. Where can you use this knowledge?

3. What do you need to implement your ideas?

4. What do you think we will do in the next lesson and will it be related to the topic of the current lesson?

 

 

 

Presentation (slide_1)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Presentation (slides_2-3)

 

Presentation (slides_4-5)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Presentation (slide_6)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Presentation (slide_7)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Online resource:

https://sql-language.ru/foreign-key.html

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Presentation (slide_8)

 

 

 

 

 

 

 

 

 

 

 

Presentation (slide_9-10)

 

 

Presentation (slide_11)

 

 

 

 

 

 

Presentation (slide_12)

 

 

 

 

 

Presentation (slide_13)

 

 

 

 

 

 

 

 

Presentation (slide_14)

 

 

 

 


 

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?

 

 

 

 

 

 

 

 

 


 

Скачано с www.znanio.ru

Long-term Plan Unit : 10.4А Information

Long-term Plan Unit : 10.4А Information

Middle 15-23 minutes 24-27 minutes 28-32 minutes 33-36 minutes

Middle 15-23 minutes 24-27 minutes 28-32 minutes 33-36 minutes

End 37-40 minutes Class room management: greeting, checking absentees

End 37-40 minutes Class room management: greeting, checking absentees

Beginning 0-2 minutes 3-4 minutes 5-6 minutes 7-10 minutes 11-14 minutes

Beginning 0-2 minutes 3-4 minutes 5-6 minutes 7-10 minutes 11-14 minutes

Differentiation Assessment

Differentiation Assessment

2Lesson №59 Database development Lesson plan

2Lesson №59 Database development Lesson plan
Скачать файл