SHS2 Computing · Semester 2 Week 15: Web Technologies and Databases

Lesson notes

Learning Objectives

Indicator: 2.2.3.LI.3 - Create a relational database model of a database.

By the end of the lesson, learners can:

Define a relational database and explain the key components: tables, records, fields, primary keys, and foreign keys.
Identify relationships (one-to-one, one-to-many, many-to-many) between tables in a given scenario.
Design a relational database model from a real-world scenario by identifying entities, attributes, and relationships.
Draw an entity-relationship (ER) diagram using standard symbols to represent tables and their connections.
Justify design decisions in a relational database model, explaining how primary and foreign keys link tables and maintain data integrity.

Sign in with your phone number to read the full note and download the GES plan - free.

Sign in with phone number

Curriculum details

Strand: Computational Thinking (programming Logic) (Strand 2)
Sub-strand: Web Technologies and Databases (2.3)
Content standard: 2.2.3.CS.1 - Demonstrate knowledge and understanding of Web Development and Databases 2.2.3.LO.1 Apply acquired skills and knowledge to design and develop simple web pages
Indicator: 2.2.3.LI.3 - Create a relational database model of a database.
Suggested placement: Semester 2, Week 15 (Week 35 of the year)
Our suggestion, laid out in curriculum order across three terms of twelve weeks. NaCCA does not fix the week, so follow your school's scheme of learning.
Curriculum reference: NaCCA curriculum document, p. 72

Exemplars (from the NaCCA curriculum)

Project-Based Learning Approach:
- Engage in whole-class discussions to explore databases
- Conduct practical sessions in individual and mixed-ability/gender-sensitive group work.
- Employ interactive multimedia presentations and video analysis to facilitate discussions and demonstrate techniques for creating a relational database model
Teaching and Learning Materials:
- * Notepad or exercise book * Pen * Smartphones * Laptops * Desktop computers
- Tablets
- YEAR THREE
- * TV and Radio * Open Educational Resources (including YouTube,
- MOOCs - Udemy/Coursera, Khan Academy, and
- TESSA) * The iBox/iCampus (CENDLOS)
- Productivity tools ix. Subject-based application software
- Instructional Laboratories (with multimedia equipment and smartboards)
- Maintenance and repair workshops
Assessment (2.2.3.AS.3). The document marks these depth-of-knowledge levels for this indicator: Level 4 Extended critical thinking and reasoning.