Проектирование базы данных: план урока информатики, 9 класс

Theme: DESIGNING A DATABASE

School: Kokshetau, School – lyceum №21(Кокшетау, СШЛ №21)

Date: ____25.11__

Teacher’s name: Bratayeva A.D.

Grade(класс): 9G

Number present: Number absent:

Lesson objectives: All learners will be able to ( все учащиеся должны знать):  Desing a database;  Identify data types. Language objectives:

Key words: field, edge, area, to resize …

Planned timings Planned activities Resources Greeting and

organizing

moment:

Introduction of

new topic:

Main Body:

T:Good afternoon, students!

P:Good afternoon, Teacher! T: How are you? P: I am glad to see you. Welcome to this lesson. Sit down, please. T: Who is absent today? P: … T: Let’s revise the last topic! Look at the board! T: Today’s new topic is Designing a Database Our learning objectives are: • Design database; • Identify data types. What is the best way to keep information about books a library? Как лучше всего хранить информацию о книгах в библиотеке? P: … T: You are correct. Open your notebooks and write down the topic of the lesson, new words Terminology immediate - тез арада - немедленный to-do list - жұмыстар тізімі - список дел to combine - біріктіру - объединить to resize - өлшемін өзгерту - изменить размер to scroll - айналдыру - прокручивать field - алаң - поле edge - шеті - край area - аудан - область to break - бөлу – разделить Let's say new words, say louder (laudә), please! OK! Look at the board! Read 1 (first) paragraph and translate.Next!

Presentation,

physical examples

Quizlet.com

Practice:

Write down the main field types (slide 7) Design a database for a library, that will store information about each book. 1.Take a piece of paper and plan fields for your new table. 2.Write the following fields on the paper: ID, Name of book, Author, Genre, Published date, Quantity, Popularity.