Designing a database

Subject: Informatics

Chapter : 2 Database Basics

School:

Theme: 2.2 Designing a database

Date:

Teacher s name:

Grade:9

Number present:

absent:

Learning objectives

Identify the date types

To explain and to know new terminology on topic the designing a database

Lesson objectives

All learners will be able to: to explained the designing a database.

Identify and practiced design a database

To discuss of date types and design a database

Language objective

To use new terminology during the lesson

To customise-баптау

To do list-жұмыстар тізімі

To resize-өлшемін өзгерту

Edge-шеті

To combine-біріктіру

Area-аудан

To break-бөлу

To scroll-айналдыру

Immediate-тез арада

Previous learning

What is a database?

Planned timings

Planned activities

Resources

Start

5 min

Main Part

30 min

End

Greeting.T greets learners

Checking up the homework

You’ll divide into 3 groups,then introduces to the learning objectives and asks to find out the topic of the lesson looking at the picture.

Presentationlessonobjectives

Let^,s start new lesson with questions:

What is abest way to keep information about books at a library?

On previous chapter we talk about library and bookkeeper. How do you think what will be a good way to keep

Work in group with posters

1.GroupTo explain design a database

2.Group :To find the types of database data

3. Group :To make a database data

Group assessment

Answering this questions identifies the content of the table and name of the table and the field types.

What is your aspect and events to be tracked and processed?

Which fields do you need to organize similar values and data?

Which type of data will you store in these fields?

Work in pairs.Work the book:

Complete the table.Write a group of characters reference

Work in individual (жеке жұмыс)

Practical work:№1 First of all take a piece of paper and try to plan field for your new table. Write the following fields o the paper: ID, name of book, author, Genre, Published date, Quantity ,popularity. Now try to identify what field types are required for the fields you have written. Draw the following table:

№2 To draw your own database

№3Choose one of the options below and try to make a database design. Discuss database designs with your classmates.Think about what fields can be used:

1Student registration form

2.computer Lab inventory

3.Music and movie store

Formative assessment(using geometrical shapes) No mistakes

1-2 mistakes3-4 mistakes

H ow do we build a new database?

Where do we use a table in daily life?

Interactive board

pictures

Poster,pictures

Informatics.Book.9grade

кесте

Worksheet

stickers

Assessment

Peer assessment. Group assessmentFormative assessment(using geometrical shapes)

Homework

Make at least 10 fields with different data types and apply them into your database.

presentation

Reflection

Ss are given stickers to write 3 sentences about what they have learnt today.