Long-term plan unit: Information systems

School:

Date:

Teacher name:

Grade: 10 ICT

Number present:

Number present:

The purpose of professional development

Development of creative thinking of students through a differentiated approach to teaching

Theme of the lesson

Database basics

Learning objectives that are achieved at this lesson (Subject Programme reference)

describe relational databases and their purpose

define data types when creating a database

use the terms: attribute, object, index, record, table and tuple to describe the databases

Lesson objectives

11.4.1.1:describe relational databases and their purpose

11.4.1.4:define data types when creating a database

11.4.1.2-use the terms attribute, object, index, record, table and tuple to describe databases

11.4.1.3-explain the difference between primary composite and foreign key

11.4.1.5 define the connections between tables in database

11.4.1.6 create an entity-relationship (ER) model

Success criteria

ü  knows relational databases

ü  knows the development of skills for creating and analysing multi-table databases.

ü  knows about SQL queries and acquire skills in creating them.

Language objectives

Students can:

Understand about the database and the dbms

Identify the type of data needed for the database

Write the scripts to create database and table

Dictionary of specific terms and terminology:

Database, table, field / attribute, record, tuple, data type, primary key, composite primary key, foreign key, relational, unique, index, tuple, record, link data integrity, relationships (one to one, many to many, one to many), the atomicity of data,

normalization (1st, 2nd, 3rd normal forms)

The language of queries for SQL DDL, DML, SELECT, UPDATE, INSERT, and DELETE

A set of useful phrases for communication / writing:

Primary key is…, while the foreign key is ...

To select ... you need to create the following query ...

An attribute

A key field

A primary key

A foreign key

Normalisation
Using first normal form

Using second normal form

Assimilation of values

Sociability

The need for teamwork and teamwork planning ensures a friendly attitude of students and develops their communicative qualities for working in the collaborative learning environment: developing skills socially, culturally, ethically and interactively with other students in teamwork.

The national idea of "Mangilik yel"

Formation of children's interest in academic knowledge, training throughout life for the benefit of the motherland. Elements of the lesson are also aimed at self-education, self-education, the development of critical thinking among students and the implementation of the three-language policy in education.

The moral aspect of the lesson involves: developing a sense of responsibility for one's learning; respectful attitude to others, development of intercultural awareness.

Intersubject communication

Mathematics

Preliminary knowledge

Have experience in analyzing, developing and implementing a project in another subject area.

Course of the lesson

Planned stages of the lesson

Planned activities at the lesson

Resources

Lesson Beginning

0-2

2-3

Organizational moment, to familiarize students with the topic of the lesson

Together with students to determine the objectives of the lesson / success criteria

(К) Task 1. Communication with the last lesson. Dataflow diagrams (DFD). Flowcharts.

Presentation

Activ Inspire

Middle of the lesson

4-10

Group Work (5 Min)
Real-life examples of databases:

HOW might the following use a database? For each one list what data they need to store.

•      Police

•      Restaurant

•      Library

•      Airlines

•      Hotel

(5 Min to review)

Presentation

Activ Inspire

11-13

Explain about Database & DBMS

What is a Database?

A database is any collection of related data.

What is a Database Management System?

 A database management system (DBMS) is a collection of programs that enables users to create and maintain a database.

Presentation

13-18

Explain the functions of DBMS

Database management systems provide several functions in addition to simple file management:

•       allow concurrency

•      control security

•      maintain data integrity

•      provide for backup and recovery

•      control redundancy

•      provide non-procedural query language

•      perform automatic query optimization

Presentation

19-20

Who Interacts with a DBMS?

Many different individuals are involved with a

database management system over its life:

•      systems analysts

•      database designers

•      database administrators

•      application developers

•      users

Presentation

21-23

Explain about RDBMS

Presentation

Different types of Database

Database software includes off-the-shelf software such as 

•      Microsoft Access

•       Libre Office Base

•       Oracle

•      Microsoft SQL Server

•      MySQL

Presentation

24-28

Go through the basic data types available in MySql(slide 9)

Presentation

29-33

Explore shopping websites :www.amazon.com
(5 Min)

1. List the fields that the shopping website might store

2. Mention the types of data

Presentation

www.amazon.com

34-40

Explain about the Table

The table is a collection of related data entries and it consists of columns and rows. Following is the example of a CUSTOMERS table:

Field/column

   A field/ column in a table that is designed to maintain specific information about every record in the table.

Record / row

  A record, also called a row of data, is each individual entry that exists in a table

Explain the other terms  like Tuple,attribute and relation

Presentation

41-45

Explain about SQL

SQL stands for Structured Query Language. SQL is a database computer language designed for the retrieval and management of data in relational database.

SQL commands are divided into four subgroups, DDL, DML, DCL, and TCL.

Presentation

Explain about DDL and all the commands associated with it.

CREATE, ALTER, DROP, TRUNCATE, COMMENT, RENAME

45-50

Explain little about the XAMPP Software and

Install the XAMPP Software

Presentation

XAMPP

51-55

Practical

Instruction for opening the MySql Database

Launch XAMPP software

·         Start the Apache

·         Start the MySql

·         Click on the ‘Admin’ button on XAMPP Control Panel

Practical 1

Steps to create a database

Presentation

XAMPP

Exercise 1 -2

55-58

Creating table using GUI and also using the scripts

Presentation

XAMPP

Exercise 1 -2

59-65

Using scripts

CREATE TABLE CUSTOMER  (

CUST_ID INT NOT NULL,

CUST_NAME VARCHAR (20) NOT NULL,

City CHAR (25));

XAMPP

66-68

69-75

View the structure

1.       

2.       

3.       

4.       

5.      See the structure of the ‘customer’ table

Or type in DESC command in SQL tab

Exercise

(A )Create a table for the following structure

Table : Deptartment

DEPARTMENT_ID

MANAGER_ID

Write the sql scripts on the space below

XAMPP

Exercise 1 -2

End

75-80 min

Reflection

Little finger - the thought process: what knowledge, experience did I get today?

Unnamed finger is the proximity of the goal: what did I do today and what did I achieve?

The middle finger is a state of mind: what was my mood today, my mood?

The index finger is a service, help: how did I help others today, what did I enjoy?

Thumb - cheerfulness, physical condition

Cards

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

Differentiation can be by task, by outcome, by individual support, by selection of teaching materials and resources taking into account individual abilities of learners (Theory of Multiple Intelligences by Gardner).

Differentiation can be used at any stage of the lesson keeping time management in mind.

Use this section to record the methods you will use to assess what students have learned during the lesson.

Health promoting techniques

Breaks and physical activities used.

Points from Safety rules used at this lesson.

Reflection

Were the lesson objectives/learning objectives realistic? Did all learners achieve the LO?

If not, why?

Did my planned differentiation work well?

Did I stick to timings?

What changes did I make from my plan and why?

Use the space below to reflect on your lesson. Answer the most relevant questions from the box on the left about your lesson. 

Summary evaluation

What two things went really 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?