A/L ICT Lesson 08: Database Systems
Bilingual, exam-focused notes for Unit 8 of the Sri Lankan GCE Advanced Level ICT syllabus. Covers fundamental database concepts (data vs information, structured vs unstructured data), database models (flat-file, hierarchical, network, relational, object-relational), and relational database components (attributes, tuples, relationships). Detailed sections on database constraints (NOT NULL, UNIQUE, PK, FK, CHECK), ER and EER diagrams, data normalization (1NF, 2NF, 3NF), and SQL (DDL and DML). Features interactive tools including a functional dependency analyzer, SQL query builder, and an ER-to-Relational schema converter, alongside structured essay questions, 5-option MCQs, and a bilingual glossary.
Loading the lesson...