Database Components and Creating a Database with Microsoft Access for SS 1

Class: SS 1
Term: Second Term
Week: 10
Age: 15 years
Duration: 60 minutes
Subject: Digital Technologies
Curriculum Theme: Data Science
Focal competence: Managing data using Database Management System Software
Key competencies/values: Communication; Innovation
Skills:

• Organizing data in a database
• Creating a functional database

Previous Lesson: Definition and Examples of DBMS, Types, Importance and Components
Topic: Introduction To Database Management System (I): Database Components
Subject Matter: Database Components

Specific Objectives

By the end of the lesson, pupils/students should be able to:

Cognitive Domain

• List examples of Database Management Systems (DBMS).
• Define Primary Key, Foreign Key, and Relationship in a database context.

Affective Domain

• Appreciate the importance of organized data management using databases.

Psychomotor Domain

• Create a database with related tables using Microsoft Access.
• Store and retrieve data from a database.
• Create at least three tables and link them using primary and foreign keys in MS Access.

Reference Materials

The following resources were used in planning this lesson:

• 2025 New Revised Senior Secondary Education Curriculum (SSEC)
• Relevant State Unified Scheme of Work
• Digital Technologies for Senior Secondary Schools, Book 1
• The HeadTeacher Scheme of work For The New Revised Senior Secondary Education Curriculum (SSEC)

Instructional Materials

The teacher will teach this lesson with the aid of:

• Computers/laptops with DBMS software (e.g., Microsoft Access, MySQL Workbench)
• Sample school datasets
• Internet access for online DBMS tutorials
• Projector and whiteboard

Rationale for the Lesson

Understanding database components and how to create a database is fundamental in today’s data-driven world. This lesson provides students with practical skills in managing information efficiently, which is essential for various academic and professional applications. It helps students appreciate how data is structured and interconnected, fostering innovation in data handling.

Prerequisite/Previous Knowledge

Students should have basic computer literacy, including knowledge of how to launch applications and navigate file systems. They should also have a general understanding of what data is and why it needs to be organised.

Lesson Content/Board Summary

Introduction To Database Management System (I): Database Components

Examples of Database Management Systems (DBMS)

A Database Management System (DBMS) is software that allows users to define, create, maintain, and control access to the database. Common examples include:

1. Microsoft Access: A desktop DBMS often used for small-scale applications.
2. MySQL: A popular open-source relational database management system.
3. Oracle Database: A powerful, widely used commercial relational database system.
4. PostgreSQL: Another robust open-source object-relational database system.
5. Microsoft SQL Server: A relational database management system developed by Microsoft.

Database Components

Databases are structured collections of data, and specific components help organise and link this data effectively:

1. Primary Key:

   A primary key is a field (or a combination of fields) in a table that uniquely identifies each record in that table. It ensures that there are no duplicate records and that each record can be accessed individually. For example, a “Student ID” in a student table would be a primary key.

2. Foreign Key:

   A foreign key is a field (or collection of fields) in one table that refers to the primary key in another table. It establishes a link or relationship between two tables. For instance, a “Course ID” in a “Student Enrollment” table that refers to the “Course ID” (primary key) in a “Courses” table is a foreign key.

3. Relationship:

   A relationship in a database is a logical connection between two tables, established by matching the values of a primary key in one table with a foreign key in another table. Relationships allow data from different tables to be combined and queried together, ensuring data integrity and consistency.

Steps to Create a Database with Microsoft Access

Creating a database in Microsoft Access involves several steps to define tables, fields, and relationships:

1. Launch the Access Application:

   Start Microsoft Access from your computer’s Start menu or desktop shortcut.

2. Create a Blank Database:

   Click on “Blank Database” from the available templates. You will be prompted to choose a location to save the file and give it a name. After selecting the location and name, click “Create.” Access will automatically open a blank table named “Table1.”

3. Define Fields in Design View:

   To set up the structure of your table, click on the “View” tab in the Ribbon and select “Design View.”

   1. Enter Field Names: In the “Field Name” column, type the names for your fields (e.g., ID, Name, Date of Birth, Address, Phone Number).
   2. Choose Data Types: In the “Data Type” column, select the appropriate data type for each field (e.g., “AutoNumber” or “Number” for ID, “Short Text” for Name and Address, “Date/Time” for Date of Birth).
4. Set a Primary Key:

   In Design View, select the field you want to be the primary key (e.g., ID). Click the “Primary Key” button in the “Tools” group on the “Design” tab. This uniquely identifies each record.

5. Save the Table:

   Click the “Save” icon on the Quick Access Toolbar or go to “File” → “Save.” Give your table a meaningful name (e.g., “Students,” “Courses,” “Teachers”).

6. Add More Tables:

   To create additional tables, go to the “Create” tab in the Ribbon and click “Table.” Repeat steps 3-5 for each new table you need (e.g., a “Courses” table with CourseID as primary key, and a “Enrollment” table with StudentID and CourseID as foreign keys).

7. Create Relationships Between Tables:

   Relationships link tables together using common fields (primary and foreign keys).

   1. Go to the “Database Tools” tab in the Ribbon.
   2. Click on “Relationships” in the “Relationships” group.
   3. Drag tables from the “Show Table” dialog box into the Relationships window.
   4. Drag the primary key from one table to the corresponding foreign key in another table to create a relationship. For example, drag “StudentID” (primary key in “Students” table) to “StudentID” (foreign key in “Enrollment” table).
   5. Ensure “Enforce Referential Integrity” is checked to maintain data consistency, then click “Create.”
8. Use the “Create” Tab for Other Database Objects:

   The “Create” tab allows you to build other database objects to interact with your data:

   1. Forms: For easy data entry and viewing.
   2. Queries: To retrieve specific data from one or more tables based on criteria.
   3. Reports: To present data in a formatted, printable layout.

Teaching Methods/Instructional Techniques

Discussion, Demonstration, Guided Practice, Question and Answer, Explanation, Practical Activity, Individual Practice

Instructional Procedures

Step 1: Introduction

Time: 5 minutes

Teaching Skill: Review/Engage

Teacher’s Activity: The teacher welcomes the students and briefly reviews the previous lesson on data organisation. The teacher then asks students about the challenges of managing large amounts of unorganised data and introduces the concept of databases as a solution.

Pupils’ Activity: Pupils respond to questions about data organisation and listen attentively to the introduction.

Learning Point: Database introduction

Step 2: Examples of DBMS

Time: 10 minutes

Teaching Skill: Explanation/Listing

Teacher’s Activity: The teacher explains what a Database Management System (DBMS) is and lists various examples such as Microsoft Access, MySQL, Oracle, and PostgreSQL, highlighting their uses. The teacher projects these examples on the whiteboard.

Pupils’ Activity: Pupils listen, observe the examples, and ask questions for clarification.

Learning Point: DBMS examples

Step 3: Database Components

Time: 10 minutes

Teaching Skill: Explanation/Definition

Teacher’s Activity: The teacher explains and defines key database components: Primary Key, Foreign Key, and Relationship. The teacher uses simple, relatable examples (e.g., student ID, course ID) to make the concepts concrete and draws diagrams on the board to illustrate relationships.

Pupils’ Activity: Pupils listen, take notes, and participate in discussions by providing their own examples.

Learning Point: Database components

Step 4: Launching MS Access and Creating a Blank Database

Time: 5 minutes

Teaching Skill: Demonstration/Guidance

Teacher’s Activity: The teacher demonstrates how to launch Microsoft Access and create a new blank database, guiding students through the steps of saving the file and naming it. The teacher ensures all students are following along on their computers.

Pupils’ Activity: Pupils follow the teacher’s instructions to launch Access and create a blank database on their individual computers.

Learning Point: Launching MS Access

Step 5: Defining Fields and Setting Primary Key

Time: 10 minutes

Teaching Skill: Guided Practice/Demonstration

Teacher’s Activity: The teacher guides students to define fields in Design View for a “Students” table (e.g., StudentID, Name, DateOfBirth) and choose appropriate data types. The teacher then demonstrates how to set “StudentID” as the primary key and save the table. Students are encouraged to create two more tables (e.g., “Courses”, “Enrollment”) with relevant fields and primary keys.

Pupils’ Activity: Pupils practice defining fields, selecting data types, setting primary keys, and saving their tables under the teacher’s guidance.

Learning Point: Defining table fields

Step 6: Creating Relationships

Time: 10 minutes

Teaching Skill: Practical Application/Demonstration

Teacher’s Activity: The teacher demonstrates how to create relationships between the “Students”, “Courses”, and “Enrollment” tables using primary and foreign keys. The teacher explains the importance of referential integrity and guides students to link their tables correctly.

Pupils’ Activity: Pupils follow the demonstration to establish relationships between their created tables, ensuring data integrity.

Learning Point: Creating relationships

Step 7: Evaluation/Review

Time: 5 minutes

Teaching Skill: Questioning/Assessment

Teacher’s Activity: The teacher evaluates the learning by asking the following questions:

1. List two examples of DBMS.
2. What is the purpose of a Primary Key in a database?
3. How do you establish a relationship between two tables in MS Access?
4. Name three steps involved in creating a new table in MS Access.

Pupils’ Activity: Pupils answer orally and in writing.

Learning Point: Database creation steps

Step 8: Note-Taking

Time: 10 minutes

Teaching Skill: Guided Writing

Teacher’s Activity: The teacher guides pupils/students to copy the essential Board Summary notes on database components and MS Access steps into their notebooks.

Pupils’ Activity: Pupils/students copy the notes carefully into their notebooks.

Learning Point: Database notes

Step 9: Conclusion

Time: 5 minutes

Teaching Skill: Consolidation

Teacher’s Activity: The teacher summarises the key concepts of database components and the process of creating a database in MS Access. The teacher reiterates the importance of databases in managing information effectively.

Pupils’ Activity: Pupils listen and ask any final questions.

Learning Point: Database management importance

Continuous Assessment/Further Study

Type: Homework/Practice Exercise

Instruction: Using Microsoft Access, create a simple database for a library system. Your database should include the following:

1. A table named “Books” with fields: BookID (Primary Key), Title, Author, ISBN, PublicationYear.
2. A table named “Borrowers” with fields: BorrowerID (Primary Key), Name, Address, PhoneNumber.
3. A table named “Loans” with fields: LoanID (Primary Key), BookID (Foreign Key), BorrowerID (Foreign Key), LoanDate, ReturnDate.
4. Establish relationships between the “Books”, “Borrowers”, and “Loans” tables using appropriate primary and foreign keys.
5. Enter at least 5 sample records into each table.

Lesson Keywords

• Database – An organised collection of structured information, or data, typically stored electronically in a computer system.
• DBMS – Database Management System, software for creating and managing databases.
• Primary Key – A field that uniquely identifies each record in a table.
• Foreign Key – A field in one table that refers to the primary key in another table, linking the two tables.
• Relationship – A logical connection between two tables in a database, established by matching primary and foreign keys.
• Microsoft Access – A desktop DBMS application used for creating and managing databases.

Differentiation

For struggling learners, the teacher can provide pre-designed table structures or step-by-step printouts for creating the database. More advanced students can be challenged to create simple forms and queries for their databases, or explore different data types and their implications.

Suggested Lesson Videos

For further understanding, students can search on YouTube for:

• “Introduction to Database Components for SS1”
• “How to create a database in Microsoft Access step by step”
• “Primary and Foreign Keys explained with examples”