O/L ICT Lesson 9: Database (දත්ත සමුදාය)

Database: A structured collection of related data that can be easily managed, updated, and retrieved.
Table: The core structure holding data in rows and columns.
Field (Column): Represents a single type of data (e.g., Student_ID, Name).
Record (Row): A complete set of fields for a single entity.
Database Benefits: Reduced data redundancy, improved accuracy, and ensured data integrity.

O/L ICT Lesson 09: Database Management Systems

Bilingual, exam-focused notes for Unit 09 of the Sri Lankan GCE Ordinary Level ICT syllabus (Grade 10). Covers database fundamentals, relational concepts, keys (primary, foreign, composite), table relationships, data types, and basic queries. Includes interactive simulators for drag-and-drop DB building, relationship mapping, SQL query building, and table design. Features structured O/L essay questions with model answers, strictly four-option MCQs with explanations, global video resources, and bilingual flashcards.