Lesson Notes By Weeks and Term - Senior Secondary 1

Term: 3rd Term

Week: 10

Class: Senior Secondary School 1

Age: 15 years

Duration: 40 minutes of 2 periods each

Date:       

Subject:      Data Processing

Topic:-       Database Management III

SPECIFIC OBJECTIVES: At the end of the lesson, pupils should be able to

1. Create a database
2. Create a table
3. Query a database

INSTRUCTIONAL TECHNIQUES: Identification, explanation, questions and answers, demonstration, videos from source

INSTRUCTIONAL MATERIALS: Videos, loud speaker, pictures, Data Processing for senior Secondary Education by Hiit Plc, WAPB Computer Studies for Senior Secondary I by Adekunle et al, On-line Materials.

INSTRUCTIONAL PROCEDURES

PERIOD 1-2

NOTE

DATABASE MANAGEMENT

Creating Table

After clicking the Create button, a new window shows up with a table already created with a default name Table1. This very window is called the Datasheet View.

If the Database is storing information about a school, then the entities in a school include Student, Teacher, and Subject etc. So if we are going to create a table that stores student information, then we list the attributes of a typical student such as StudentID, Firstname, Lastname, Gender, DOB, Address, Nationality etc

The above listed attributes are what make the fields (column name). To define the structure of the Student table, do the following:

1. On the Home tab, click the View button on the top left corner (directly below the File tab)
2. Then click Design view

The window that shows up is called the Design View, and has a part called Field Name and on the left the Data Type column. The Field name is the attribute of the student i.e. Lastname, StudentID etc. while the Data Type has to do with the type of data value each field takes. For example, if the field name is Lastname, then the appropriate data type is Text (since your name is a combination of alphabets). The following are the data types available in MS Access 2010.

Other data types are OLE Object, Hyperlink, Attachment and Lookup Wizard.

Now enter the following field names and select the appropriate data type as indicated in the table below:

Note that the field name can be up to 64 characters long. They can include combination of letters of the English alphabet, numbers, blank space and special characters except a period (.), an exclamation mark (!), and brackets ([]).

You must make sure that you set the primary key (PK) field. A primary key is any field that contains values that are unique for each record in the table. In the case of this, the PK field is StudentID, since no two students can have the same StudentID.

After typing as indicated in the table above, Save it, then click View to return to Datasheet View. You can start filling the table with data values that form records.

QUERYING THE DATABASE

Querying the database means asking the database to extract a subset of the information saved in it based on the criteria you are giving it.

CLASS ACTIVITY: Create a database for learners in SS1 using the below appropriate field names

EVALUATION:    1. How can you query the database?

CLASSWORK: As in evaluation

CONCLUSION: The teacher commends the students positively