In an era defined by Big Data, understanding how information is stored, organized, and retrieved is a vital skill. For GCE O/L ICT students, Lesson 9: Electronic Databases introduces the architecture behind modern information systems.

This post combines the essential theoretical framework from our LMS with the practical, hands-on experience offered by the SchoolICT.net Database Simulator.

1. Introduction to Databases

A Database is an organized collection of related data. While manual filing systems (like a library card catalog) are databases, the ICT syllabus focuses on Electronic Databases, specifically Relational Database Management Systems (RDBMS).

Why move from Manual to Electronic?

• Reduced Data Redundancy: Prevents the same data from being stored in multiple places.
• Data Integrity: Ensures information remains accurate and consistent.
• Speed: Searching for a record takes seconds compared to hours in a paper-based system.
• Security: Data can be encrypted and protected with user permissions.

2. The Building Blocks of a Relational Database

To understand a database, you must understand its hierarchy. Think of it like a ladder, moving from the smallest unit to the largest.

A. Fields (Attributes)

The smallest unit of meaningful data. For example, “Student_Name” or “Date_of_Birth.”

B. Records (Tuples)

A collection of related fields that describe one entity. One row in a table representing one specific student is a Record.

C. Tables (Relations)

A collection of related records. For example, a “Students” table contains records of all students in a school.

D. Database

The entire container that holds multiple tables (e.g., Students, Teachers, and Exams) and the relationships between them.

3. Keys: The Secrets of Organization

In the GCE O/L exam, “Keys” are a high-frequency topic. You must be able to distinguish between the three main types:

Primary Key

A field that uniquely identifies each record in a table. It cannot be null (empty) and cannot contain duplicate values.

• Example: Admission_Number in a school database.

Candidate Key

Any field or combination of fields that could potentially serve as a Primary Key.

• Example: A student’s NIC number and Admission Number are both Candidate Keys.

Foreign Key

A field in one table that links to the Primary Key of another table. This is how “Relationships” are built between different tables.

[Image showing a Primary Key in one table connecting to a Foreign Key in another table]

4. Database Relationships

Tables do not exist in isolation. They interact through three types of relationships:

1. One-to-One (1:1): One record in Table A is linked to exactly one record in Table B. (e.g., One Citizen has one Passport).
2. One-to-Many (1:M): One record in Table A is linked to many records in Table B. (e.g., One Class has many Students). This is the most common relationship.
3. Many-to-Many (M:M): Many records in Table A link to many records in Table B. (e.g., Many Students follow many Subjects).

5. Data Types in Databases

Choosing the right data type ensures your database is efficient. Common O/L data types include:

• Text/Char: For names and addresses.
• Number/Integer: For quantities and ages.
• Currency: For prices and salaries.
• Date/Time: For birthdays and appointment times.
• Boolean (Yes/No): For logic (e.g., “Is_Paid”).

6. Interactive Learning: The Database Simulator

Theory can only take you so far. At SchoolICT.net, our Database Learning Tool allows students to visualize how data moves within a system.

How to use the Tool:

• Table Creation: Use the simulator to define fields and assign data types.
• Data Entry: Enter records and see how the system rejects duplicate Primary Keys (Data Integrity).
• Relationship Mapping: Draw lines between tables to understand how Foreign Keys connect data.
• Query Practice: Simulate basic “Searches” to find specific records based on criteria (e.g., “Find all students older than 15”).

7. Data Normalization (Basic)

While advanced normalization is for A/L, O/L students should understand the goal: Eliminating Redundancy. If you find yourself typing “Grade 10 – Mr. Perera” next to 40 different students, it is better to have a “Classes” table and link it via a code. This saves space and prevents errors.

8. Exam Preparation & Success Tips

1. Identify the Primary Key: In Paper I, you are often given a table and asked to identify the best Primary Key. Look for the field that is absolutely unique (usually an ID or Admission number).
2. Referencing Tables: Practice drawing the lines between tables. Remember, the “Many” side of a relationship usually holds the Foreign Key.
3. Validation vs. Verification: * Validation: Checking if data is “sensible” (e.g., a month cannot be 13).
   • Verification: Checking if data is “correct” (e.g., double-entering a password).
4. Practice Shortcuts: Know that SQL (Structured Query Language) is the standard language used to interact with these databases.

Conclusion: Bridging Theory and Practice

Mastering Lesson 9 is essential for any student aiming for an ‘A’ in ICT. Databases are the heart of every app, website, and banking system you use. By using our LMS notes and the interactive simulator, you aren’t just memorizing definitions—you are building the skills of a future data architect.

Ready to start?

• 📖 Read the Detailed GCE O/L Database Notes
• 💻 Try the Interactive Database Simulator