1_DB_development_lp_l3_v1

Long-term plan unit:

 10.3A Information Systems

School

Date:

Teacher name:

Grade: 10

Number present:

Grade:

The topic of the lesson:

Database Development

Learning objectives(s) that this lesson is contributing to

10.3.2.3 create a multi-table database  (SQL)

Assessment criteria

●        Define database field data types

●        Able to create multi-table databases using data types

●        Knows the types of relationships

Success criteria

All learners will be able to know:

create multi-table database

 the advantages and disadvantages of a multi-table database

Application

-Creates a database (first single-table);

-Creates a relationship between tables

Language objectives

Students can:

Explain the database creation algorithm.

Select a key field.

Vocabulary and terminology specific to the subject:

DBMS, single-table, multi-table, constructor, data types, key field.

Useful expressions for conversations and writing:

To create a table you need ...

The field is key field, because ...

I propose to link the field ... with the field ... because ...

Value links

Group work , co-operation, time management, academic integrity

Cross curricular links

English

Previous learning

 -

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Beginning

0-15

Warm up

Definition of the topic.

Setting lesson objectives and success criteria

Problem situation. The teacher asks questions to summarize the topic:

1. It is necessary to add a new entry to the database, how can this be done?

(Approximate student response: using a table in Table Mode.)

The teacher moves the hiding image down and shows the second question on the slide.

2. How can I view the records in the database if the table contains a field with the data type "Attachment"? (Approximate student response: open each attachment file separately in spreadsheet mode)

Teacher's explanation: The teacher moves the text “Answer” up and shows the correct answer. For more convenient work with the data of one or several interconnected tables, database objects are intended, which are called forms. Working with the form, the user can add, delete and modify records of tables, as well as view and receive calculated data.

3. Need to print information from the database to print, how can this be done?

The teacher listens to the students' answers, then moves the text “Answer” up and shows the correct answer.

Teacher's explanation: To output the necessary information from the database to print, reports are used that provide the output of interrelated data from many tables, their grouping, and the calculation of totals.

Middle

11-20

Announcement of the topic and lesson objectives:

The teacher introduces the subject and purpose of the lesson to the students.

Normalization is the partitioning of a table into two or more, which have better properties when switching on, changing and deleting data.

Appendixes 1-3

To add new fields to our DB Movies

-Film director

-Number of collected Oscars

-Film genre

-Name actor

- age of actor

-Rating actor

-status

better to break our database into several tables. Demonstrates his version on the board, page 11.

For data integrity, you need to link tables. There are three types of links:

One-to-many links

Many-to-many links

One-to-one links

For a better understanding, you can give a home task to watch a video.

https://www.youtube.com/watch?v=pYRPYfqWiUo

20-38

Practical work.

Participants must download the finished DB Movies and use the instructions (Practical work 2) to link the three tables together.

End

 38-40

Reflection

The teacher displays the assessment criteria on the blackboard, the participants discuss what happened and what was difficult

Feedback:

The teacher gives feedback to couples or to each student on the results of the lesson.

Homework is displayed on the screen

board

Differentiation – how do you plan to give more support? How do you plan to challenge the more able learners?

Assessment – how are you planning to check students’ learning?

Health and safety regulations

Additional support.

Work in pairs / groups - support for classmates.

Help the teacher, if required.

More capable learners can demonstrate aspects of their decisions that seem interesting / more complex to the other learners.

Answers questions and a session of answers.

Use questions when completing a task.

Use survey questions to understand the results / success of learners at each stage of the lesson.

Remind of some safety rules when working with computer equipment, for example, that you must be careful when installing the screen, keyboard and mouse; beware of wires, as they pose a threat to movement.