Programming with Python – Complete Study Guide 2026 Latest Updated for beginners

UNIT 9 – PYTHON PROGRAMMING (A/L ICT Sri Lanka)
Complete guide covering Introduction to Programming, Algorithms, Flowcharts, Python Fundamentals, Control Structures, Data Structures, Functions, File Handling, and Error Handling. This covers the core theory expected for Unit 9 and aligns perfectly with the Sri Lankan A/L ICT syllabus.

9.1 Introduction to Programming

Basic Definitions

• Program: A set of instructions given to a computer to perform a task.
• Programming: The process of writing, testing, debugging, and maintaining computer programs.

Why Programming? Automates tasks, solves problems efficiently, reduces human errors, and saves time.

Programming Languages

• 1GL (Machine Language): Binary code (e.g., 10110011). Fast execution but difficult to understand and error-prone.
• 2GL (Assembly Language): Uses mnemonics (e.g., MOV A,10). Requires an Assembler.
• 3GL (High-Level Languages): Python, Java, C++, Pascal. Easy to read, easy debugging, and portable. (Python belongs to this category).

Language Translators

Feature	Compiler (C, C++)	Interpreter (Python)
Translation	Whole program at once	Line by line
Execution Speed	Faster	Slower
Object Code	Generates object code	No object code
Debugging	Harder	Easier

A/L Exam Question: Python uses which translator?
Answer: Interpreter.

9.2 Algorithms

Definition & Characteristics

An algorithm is a finite sequence of instructions for solving a problem.

• Input: Accepts data (e.g., INPUT A).
• Output: Produces result (e.g., PRINT SUM).
• Definiteness: Every step must be clear.
• Finiteness: Must end after finite steps.
• Effectiveness: Each step must be practical.

Example: Add Two Numbers

START
INPUT A
INPUT B
SUM ← A + B
PRINT SUM
STOP

Control Structures

1. Sequence: Instructions executed one after another.

INPUT A, B
SUM = A + B
PRINT SUM

2. Selection: Decision making.

IF MARK >= 50 THEN
   PRINT PASS
ELSE
   PRINT FAIL
ENDIF

3. Iteration: Repeating instructions.

FOR I = 1 TO 5
   PRINT I
NEXT I

9.3 Flowcharts

Definition

A graphical representation of an algorithm using standard symbols.

Standard Symbols

Symbol Shape	Purpose
Oval	Start / Stop
Rectangle	Process (Calculations)
Parallelogram	Input / Output
Diamond	Decision (Yes/No)
Arrow	Flow Direction

Example: Find Area of Rectangle

START
  ↓
INPUT L, W
  ↓
AREA = L × W
  ↓
PRINT AREA
  ↓
STOP

9.4 Python Fundamentals

Features & First Program

Features: Simple syntax, Interpreted language, Open source, Cross-platform.

# First Python Program
print("Hello World")

Comments

# Single line comment

"""
Multi-line 
comment
"""

Variables & Naming Rules

Variables store data. Valid: student, student_name, age1. Invalid: 1age, student-name, class.

name = "Amal"
age = 18

Data Types

• Integer: x = 10
• Float: x = 10.5
• String: name = "Kamal"
• Boolean: status = True

Input and Output

# Input
name = input("Enter name:")
age = int(input())      # Integer input
salary = float(input()) # Float input

# Output
print(name)

Operators in Python

Arithmetic Operators

Operator	Meaning
+	Add
-	Subtract
*	Multiply
/	Divide
//	Integer Division
%	Modulus (Remainder)
**	Power

Example: print(10 % 3) outputs 1.

Relational Operators

Operators: ==, !=, >, <, >=, <=

Example: 10 > 5 outputs True.

Logical Operators

Operators: and, or, not

Example: 5 > 2 and 4 < 8 outputs True.

Selection Statements & Loops

Selection (IF Statements)

# Simple IF
mark = 70
if mark >= 50:
    print("Pass")

# IF ELSE
mark = 45
if mark >= 50:
    print("Pass")
else:
    print("Fail")

# IF ELIF ELSE
mark = 80
if mark >= 75:
    print("A")
elif mark >= 65:
    print("B")
else:
    print("C")

Loops (Iteration)

# For Loop
for i in range(5):
    print(i) 
# Output: 0, 1, 2, 3, 4

# While Loop
i = 1
while i <= 5:
    print(i)
    i = i + 1

Data Structures: Strings & Lists

Strings

name = "Python"

# Indexing (Starts at 0)
print(name[0])  # Output: P

# Length
print(len(name)) # Output: 6

Lists

# Creating & Accessing
marks = [45, 67, 89]
print(marks[0])  # Output: 45

# Updating
marks[1] = 90

List Methods

• marks.append(100) - Adds to the end
• marks.insert(1, 50) - Inserts at index 1
• marks.remove(67) - Removes value 67
• marks.sort() - Sorts ascending
• marks.reverse() - Reverses the list

Functions

Function Types

# 1. Without Parameters
def display():
    print("ICT")
display() # Calling the function

# 2. With Parameters
def add(a, b):
    print(a + b)

# 3. With Return Value
def add(a, b):
    return a + b
result = add(5, 10)

File Handling

Opening Files

f = open("data.txt", "r")  # Read Mode
f = open("data.txt", "w")  # Write Mode
f = open("data.txt", "a")  # Append Mode

Reading, Writing & Closing

# Write to file
f.write("Hello")

# Read from file
data = f.read()

# Always close the file
f.close()

Errors in Python

• Syntax Error: Violates grammar rules.
  Example: if x > 5 (Missing colon at the end).
• Runtime Error: Occurs during execution.
  Example: 10 / 0 (Division by zero).
• Logical Error: Program runs but produces incorrect output.
  Example: Using area = length + width instead of area = length * width.

🌟 Frequently Asked A/L Questions

Q1: What are the three control structures?
Answer: 1. Sequence, 2. Selection, 3. Iteration.

Q2: Differentiate Compiler and Interpreter.

Compiler	Interpreter
Whole program translated	Line by line
Faster execution	Slower execution
Generates object code	No object code

Q3: Write a Python program to find the largest of two numbers.

a = int(input())
b = int(input())

if a > b:
    print(a)
else:
    print(b)

Q4: Write a program to print numbers from 1 to 10.

for i in range(1, 11):
    print(i)

Q5: Create a list and print all values.

num = [10, 20, 30, 40]

for x in num:
    print(x)

🎓 Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.

---

🎓 University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

• 🏫 Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
• 🔬 Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
• 🤖 AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
• ✅ Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

---

🏫 School ICT & Corporate Beginner Classes

• 💻 Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
• 🎒 Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
• 📝 Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
• 🌍 Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

---

📢 Software Development & Digital Marketing Services

• ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
• 🎯 Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
• 📈 Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

---

📞 Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com

---

🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

• 📺 YouTube Tutorials: Subscribe to our Channel
• 💼 Professional Network: Connect on LinkedIn
• ✍️ Tech Blog: Visit our WordPress Site
• ❓ Project Q&A: Follow our Quora Guide Profile
• 📰 Monthly Updates: Read Our Newsletter
• 🌐 Official Portfolios: Wix Site | Google Business | Strikingly Portfolio
• 🗣️ Student Forum: Join our ElaKiri Discussion Thread

Database Normalization for Beginners GCE A/L ICT Unit 8 Exam Notes and Question ICT Classes English Tamil Medium

📖 Database Normalization for Beginners

Database normalization is a process used to organize data in a database properly.

Goals of normalization:

• Reduce data redundancy (duplicate data)
• Avoid anomalies (problems when inserting/updating/deleting)
• Improve consistency
• Make database easier to manage

ICT Online Class 0729622034

🔑 Important Terms

1. Redundancy

Redundancy means duplicate or repeated data.

Example

StudentID	StudentName	Course	Lecturer
1	Ali	DBMS	Silva
1	Ali	Web	Perera

Here, student name Ali is repeated many times. This wastes space and can create errors.

---

2. Anomaly

Anomaly means problems caused by bad database design.

a) Insert Anomaly

Cannot insert data properly.

• Cannot add a new course unless a student joins it.

b) Update Anomaly

Need to update same data in many places.

• Lecturer Silva changes to Fernando.
• Must update every row.
• If one row is missed → inconsistent data.

c) Delete Anomaly

Deleting one row removes important information.

• If last student leaves a course, course information is lost too.

ICT Online Class 0729622034

🟢 What is 1NF (First Normal Form)?

A table is in 1NF if:

1. Each column has atomic values
2. No repeating groups
3. Each row is unique

---

Atomic Value

Atomic means:

• One cell should contain only ONE value
• Cannot store multiple values in one field

Wrong Example

StudentID	Name	PhoneNumbers
1	Ali	0777,0711

PhoneNumbers contains multiple values. This is NOT atomic.

Correct Example

StudentID	Name	PhoneNumber
1	Ali	0777
1	Ali	0711

Now each cell has only one value. This is atomic.

---

Repeating Group

Repeating group means multiple similar columns storing same type of data.

Wrong Example

StudentID	Subject1	Subject2	Subject3
1	DBMS	Web	AI

This repeats subject columns. NOT 1NF.

Correct Example

StudentID	Subject
1	DBMS
1	Web
1	AI

Now no repeating groups.

---

Things That Should NOT Exist in 1NF

❌ Multiple values in one cell
❌ Repeating columns
❌ Array/list inside a field
❌ Duplicate rows
❌ Non-atomic values

---

Steps to Convert to 1NF

1. Find repeating groups (e.g., Phone1, Phone2, Phone3)
2. Remove multiple values from one cell
3. Create separate rows for repeated data
4. Ensure each row is unique using primary key

---

Example of Converting to 1NF

Before 1NF

OrderID	Customer	Products
101	Ahmed	Pen,Book

Problems: Multiple values in Products, Not atomic

After 1NF

OrderID	Customer	Product
101	Ahmed	Pen
101	Ahmed	Book

Now: ✔ Atomic ✔ No repeating groups ✔ 1NF achieved

ICT Online Class 0729622034

🟡 2NF (Second Normal Form)

A table is in 2NF if:

1. Already in 1NF
2. No partial dependency

Partial Dependency

Occurs when:

• Table has composite primary key
• Non-key attribute depends on only PART of key

Example

StudentID	CourseID	StudentName	CourseName
1	C1	Ali	DBMS

Primary Key = (StudentID, CourseID)

Problems:

• StudentName depends only on StudentID
• CourseName depends only on CourseID

This is partial dependency. NOT 2NF.

---

How to Remove Partial Dependency

Split table.

Student Table

StudentID	StudentName
1	Ali

Course Table

CourseID	CourseName
C1	DBMS

Enrollment Table

StudentID	CourseID
1	C1

Now: ✔ No partial dependency ✔ 2NF achieved

---

Rules of 2NF

✔ Must be in 1NF
✔ No partial dependency
✔ Non-key columns depend on full primary key

Steps to Convert to 2NF

1. Ensure table is in 1NF
2. Find composite key
3. Check if any column depends on only part of key
4. Separate into smaller tables

ICT Online Class 0729622034

🟠 3NF (Third Normal Form)

A table is in 3NF if:

1. Already in 2NF
2. No transitive dependency

Transitive Dependency

Occurs when a non-key column depends on another non-key column.

Example

StudentID	StudentName	DeptID	DeptName
1	Ali	D1	Computing

Problem: DeptName depends on DeptID, DeptID depends on StudentID
So: StudentID → DeptID → DeptName (Transitive Dependency)

This is NOT 3NF.

---

How to Remove Transitive Dependency

Split table.

Student Table

StudentID	StudentName	DeptID
1	Ali	D1

Department Table

DeptID	DeptName
D1	Computing

Now: ✔ No transitive dependency ✔ 3NF achieved

---

Rules of 3NF

✔ Must be in 2NF
✔ No transitive dependency
✔ Non-key attributes depend only on primary key

Steps to Convert to 3NF

1. Ensure table is in 2NF
2. Find non-key to non-key dependency
3. Create separate tables

ICT Online Class 0729622034

🔵 4NF (Fourth Normal Form)

A table is in 4NF if:

1. Already in 3NF
2. No multi-valued dependency

Multi-Valued Dependency

Occurs when one entity has multiple independent values.

Example

Student	Hobby	Language
Ali	Cricket	English
Ali	Cricket	Tamil
Ali	Football	English
Ali	Football	Tamil

Problem: Hobbies and languages are independent. Data repeats unnecessarily. NOT 4NF.

---

How to Remove Multi-Valued Dependency

Split into separate tables.

StudentHobby Table

Student	Hobby
Ali	Cricket
Ali	Football

StudentLanguage Table

Student	Language
Ali	English
Ali	Tamil

Now: ✔ No unnecessary repetition ✔ 4NF achieved

ICT Online Class 0729622034

📊 Quick Summary & Memory Tricks

Normal Form	Removes
1NF	Repeating groups & non-atomic values
2NF	Partial dependency
3NF	Transitive dependency
4NF	Multi-valued dependency

---

Easy Way to Identify

• 1NF Check: Any multiple values in one cell? Any repeating columns? If YES → not 1NF
• 2NF Check: Composite key exists? Any column depends on part of key only? If YES → not 2NF
• 3NF Check: Any non-key column depends on another non-key column? If YES → not 3NF
• 4NF Check: Any independent multiple values causing repetition? If YES → not 4NF

---

🧠 Final Simple Memory Trick

• 1NF → One value per cell
• 2NF → Full key dependency
• 3NF → Only key dependency
• 4NF → No multiple independent lists

ICT Online Class 0729622034

📘 UNIT 8 – Databases (GCE A/L ICT) Exam Notes

🧠 SECTION A: THEORY RECAP (Quick Revision)

Normalization Key Points

• 1NF → Atomic values, no repeating groups
• 2NF → No partial dependency
• 3NF → No transitive dependency
• 4NF → No multi-valued dependency

ER Diagram Key Points

• Entity → real-world object (Student, Course)
• Attribute → property (Name, ID)
• Relationship → connection (Enrolls)
• Primary Key → unique identifier
• Cardinality → 1:1, 1:M, M:M

ICT Online Class 0729622034

🧾 Past Paper & Unit Test Questions

🔵 QUESTION 1 – 1NF

OrderID	CustomerName	Products
O01	Kamal	Pen, Book
O02	Nimal	Pencil, Eraser

Questions: 1. State TWO problems. 2. Convert to 1NF. 3. Define atomic value.

✔ Examiner Focus: Detect repeating group, Split into rows

---

🔵 QUESTION 2 – 2NF

StudentID	CourseID	StudentName	CourseName	Lecturer

PK = (StudentID, CourseID)

Questions: 1. Identify dependency type. 2. Explain why NOT 2NF. 3. Convert into 2NF tables.

✔ Expected: Partial dependency exists (StudentName→StudentID, CourseName→CourseID)

---

🔵 QUESTION 3 – 3NF

EmpID | EmpName | DeptID | DeptName | DeptLocation

Questions: 1. Identify transitive dependency. 2. Why not 3NF? 3. Normalize to 3NF.

✔ Examiner Focus: DeptName depends on DeptID (not EmpID)

---

🔵 QUESTION 4 – 4NF

Student	Skill	Language
S1	Cricket	English
S1	Football	Tamil

Questions: 1. Explain redundancy. 2. Convert to 4NF. 3. Define multi-valued dependency.

---

🔵 QUESTION 5 – ER Diagram Design

System stores: Student (ID, Name, Address), Teacher (ID, Name, Subject). Each student enrolls in multiple subjects. Each subject taught by one teacher.

Tasks: 1. Identify entities/attributes. 2. Draw ER diagram. 3. State cardinality Student–Subject. 4. Identify PKs.

✔ Examiner expects: M:N (Student–Subject), 1:M (Teacher–Subject)

---

🔵 QUESTION 6 – ER to Table Conversion

Given: Student, Course, Relationship: Enrolls (M:N)

Tasks: 1. Convert to relational tables. 2. Identify PKs & FKs. 3. Explain why junction table is needed.

---

🔵 QUESTION 7 – Relationship Types

• One student has one ID card → 1:1
• One teacher teaches many students → 1:M
• Many students enroll in many courses → M:N

---

🔹 SECTION D: Unit Test Short Questions

1. Define redundancy. 2. What is an anomaly? 3. State TWO anomaly types. 4. What is atomic value? 5. What is a repeating group?
2. State TWO rules of 1NF. 6. What is partial dependency? 7. What is transitive dependency? 8. Why is 2NF important? 9. Goal of normalization?
3. Define entity/attribute/relationship. 10. What is cardinality? 11. Draw PK symbol. 12. Diff between 1:M & M:N. 13. What is composite key?

ICT Online Class 0729622034

💡 Exam Tips & Quick Revision

🧠 EXAM TIPS (VERY IMPORTANT)

• Always show steps (not only final answer)
• Use arrows in dependency explanation
• Clearly mark primary key (PK) and foreign key (FK)
• ER diagrams: Rectangle = Entity, Oval = Attribute, Diamond = Relationship

---

📌 QUICK REVISION SUMMARY

Topic	Exam Focus
1NF	Atomic values, remove repeating groups
2NF	Remove partial dependency
3NF	Remove transitive dependency
4NF	Remove multi-valued dependency
ERD	Entities, relationships, cardinality

ICT Online Class 0729622034

📚 Unit 8 DBMS Syllabus Coverage

Database Fundamentals

• Data vs Information
• Database, DBMS, RDBMS

Relational Database Concepts

• Table (Relation), Record (Tuple), Field (Attribute)
• Domain, Primary Key, Foreign Key, Candidate Key, Composite Key

Database Design

• Entity, Attribute, Relationship, ER Diagram (ERD)

Normalization

• UNF, 1NF, 2NF, 3NF

SQL Commands

• CREATE, ALTER, DROP
• INSERT, UPDATE, DELETE
• SELECT, WHERE, ORDER BY, GROUP BY

Database Security

• Access Rights, Data Integrity, Backup, Recovery

ICT Online Class 0729622034

📝 Question Types & Most Repeated Topics

A. MCQ Questions

Usually 5–12 MCQs directly or indirectly related to DBMS appear in Paper I.

• Database Basics: Primary key, foreign key, DBMS model, data redundancy.
• SQL MCQ: Purpose of SELECT * FROM Student;
• ERD MCQ: Identify cardinality, One-to-many relationship.
• Normalization MCQ: Which table is in 1NF? Identify partial dependency.

B. Structured Questions

• Convert ER Diagram to Relations: e.g., Student, Course, Registration → Relational schema.
• SQL Writing: CREATE TABLE, INSERT INTO, UPDATE, DELETE.
• Normalization: Given a table, convert to 1NF, 2NF, 3NF.

C. Essay Questions

• Advantages of DBMS over file systems.
• Explain normalization with examples.
• Explain ERD and relational mapping.
• Explain SQL commands with examples.
• Database security and integrity.

---

Most Repeated Topics (2011–2024 Analysis)

Topic	Frequency
Primary Key	Very High
Foreign Key	Very High
ER Diagram	Very High
ERD → Relation Mapping	Very High
Normalization	Very High
SQL SELECT	Very High
SQL INSERT / UPDATE	High
DDL vs DML	High
Database Security / Integrity	Medium

ICT Online Class 0729622034

✍️ Fill in the Blanks, Matching & True/False

Fill in the Blanks

• A Primary Key uniquely identifies a record.
• SQL stands for Structured Query Language.
• A table row is called a Tuple.
• A table column is called an Attribute.
• Repetition of data is called Data Redundancy.

---

Matching Questions

Column A	Column B
Primary Key	Unique Identifier
Foreign Key	Reference Field
SQL	Query Language
ERD	Database Design
1NF	Atomic Values

---

True / False Questions

• Every table must have a primary key. True ✔
• Foreign key ensures relationship between tables. True ✔
• SQL is a programming language. False ✘
• 3NF reduces redundancy. True ✔
• ERD is used before implementation. True ✔

ICT Online Class 0729622034

💻 Practical SQL Questions

Common Exam Tasks

Create Table

CREATE TABLE Student (
  StudentID INT,
  Name VARCHAR(30)
);

Insert Record

INSERT INTO Student VALUES(1,'Ali');

Select Records

SELECT * FROM Student;

Update Record

UPDATE Student SET Name='Ahmed' WHERE StudentID=1;

Delete Record

DELETE FROM Student WHERE StudentID=1;

ICT Online Class 0729622034

🟢 PART A – MCQ Questions & Answers

1. Which key uniquely identifies a record in a table?
   Answer: C. Primary Key
   Explanation: A primary key uniquely identifies every record in a table.
2. A row in a relational table is called a:
   Answer: D. Tuple
   Explanation: A row is called a tuple, while a column is called an attribute.
3. Which SQL command retrieves data?
   Answer: C. SELECT
   Explanation: SELECT is used to retrieve records from a table.
4. Which normal form removes repeating groups?
   Answer: A. 1NF
   Explanation: First Normal Form requires atomic values and no repeating groups.
5. A foreign key is used to:
   Answer: C. Link tables
   Explanation: Foreign keys establish relationships between tables.
6. Which SQL command adds new records?
   Answer: B. INSERT INTO
   Explanation: INSERT INTO adds records to a table.
7. Data duplication is called:
   Answer: B. Redundancy
   Explanation: Redundancy means storing the same data multiple times.
8. Which key can contain multiple attributes?
   Answer: A. Composite Key
   Explanation: Composite keys consist of more than one attribute.
9. Which SQL clause filters records?
   Answer: C. WHERE
   Explanation: WHERE specifies conditions.
10. Which command changes existing data?
    Answer: A. UPDATE
    Explanation: UPDATE modifies existing records.

ICT Online Class 0729622034

🟡 PART B, C & D – Blanks, True/False & Short Qs

PART B – Fill in the Blanks

1. A Primary Key uniquely identifies a record.
2. A column in a table is called an Attribute.
3. SQL stands for Structured Query Language.
4. A row in a table is called a Tuple.
5. The process of reducing redundancy is called Normalization.
6. The set of allowed values for an attribute is called a Domain.
7. A database containing tables is known as a Relational database.
8. The Foreign key references a primary key in another table.
9. Referential integrity ensures foreign key validity.
10. CREATE TABLE is used to create a table.

---

PART C – True / False

1. Every table should have a primary key. True
2. A foreign key must always be unique. False (Multiple records can share the same foreign key.)
3. Normalization reduces redundancy. True
4. SELECT is a DDL command. False (Belongs to DML.)
5. ERD is used during database design. True
6. 2NF comes before 1NF. False
7. UPDATE modifies existing records. True
8. DELETE removes records. True
9. Primary keys may contain NULL values. False
10. SQL is used to communicate with databases. True

---

PART D – Short Questions

1. What is a DBMS?
   Software used to create, manage and retrieve data from databases (e.g., MySQL, Oracle).
2. What is a Primary Key?
   An attribute that uniquely identifies each record (e.g., StudentID).
3. What is a Foreign Key?
   An attribute referencing the primary key of another table.
4. What is an ER Diagram?
   A graphical representation of entities and relationships.
5. What is Normalization?
   The process of organizing data to reduce redundancy.

ICT Online Class 0729622034

🔵 PART E – Normalization Questions & Answers

Question 1: Convert to 1NF

StudentID	StudentName	Subject1	Subject2
S001	Amal	ICT	Maths

Answer

StudentID	StudentName	Subject
S001	Amal	ICT
S001	Amal	Maths

Explanation: Repeating groups removed.

---

Question 2: Convert to 2NF

Given: | OrderID | ProductID | ProductName | Qty | (PK: OrderID, ProductID)

Answer

Order Table: | OrderID | ProductID | Qty |

Product Table: | ProductID | ProductName |

Explanation: ProductName depends only on ProductID (Partial dependency removed).

---

Question 3: Convert to 3NF

Given: | StudentID | StudentName | ClassID | ClassName |

Answer

Student Table: | StudentID | StudentName | ClassID |

Class Table: | ClassID | ClassName |

Explanation: Removed transitive dependency (ClassName depends on ClassID, not StudentID).

ICT Online Class 0729622034

🟠 PART F & G – SQL & Essay Questions

PART F – SQL Questions

1. Create Student table:
   CREATE TABLE Student(StudentID INT PRIMARY KEY, Name VARCHAR(50), City VARCHAR(30));
2. Insert student:
   INSERT INTO Student VALUES(1,'Amal','Colombo');
3. Display all students:
   SELECT * FROM Student;
4. Display only Colombo students:
   SELECT * FROM Student WHERE City='Colombo';
5. Update city:
   UPDATE Student SET City='Kandy' WHERE StudentID=1;
6. Delete student:
   DELETE FROM Student WHERE StudentID=1;

---

PART G – Essay Questions

Essay 1: Advantages of DBMS over file systems

• Reduced redundancy, Better security, Data sharing, Data integrity, Faster retrieval, Backup/recovery, Multiple user access.

Essay 2: Explain normalization

• 1NF (Atomic values, no repeating groups), 2NF (Remove partial dependency), 3NF (Remove transitive dependency). Benefits: Reduced redundancy, improved consistency, easier maintenance.

Essay 3: Primary Key vs Foreign Key

• PK: Unique, Not NULL. FK: References another table, maintains relationships.

Essay 4: DDL and DML

• DDL: CREATE, ALTER, DROP. DML: SELECT, INSERT, UPDATE, DELETE.

Essay 5: Database Security

• User authentication, Password protection, Access control, Backup, Recovery, Encryption, Audit logs.

ICT Online Class 0729622034

🔷 ER DIAGRAM (ERD) Concepts (Q1-Q8)

1. What is an Entity?
   A real-world object, person, place, event, or thing about which data is stored (e.g., Student, Teacher). Entities become tables.
2. What is an Attribute?
   A property or characteristic of an entity (e.g., StudentID, Name). Attributes become columns.
3. What is a Relationship?
   Describes how two entities are associated (e.g., Student → Enrolls → Course).
4. Draw ERD for Students and Courses (M:N)
   Student M -------- M Course (Many-to-Many relationship).
5. Identify Relationship: One teacher teaches many students.
   Teacher 1 -------- M Student (One-to-Many).
6. Identify Relationship: One customer can place many orders.
   Customer 1 -------- M Order.
7. Identify Relationship: One employee manages one department.
   Employee 1 -------- 1 Department (One-to-One).
8. What is Cardinality?
   Specifies the number of entity instances participating in a relationship. Types: 1:1, 1:M, M:N.

ICT Online Class 0729622034

📐 ER DIAGRAM (ERD) Drawing & Conversion (Q9-Q15)

Question 9: School ERD

One class has many students. Answer: Class 1 ------- M Student

---

Question 10: Library ERD

Members can borrow many books. Books can be borrowed by many members.
Answer: Member M ------- M Book. Needs an associative entity: Borrow(BorrowID, Date) between Member(1) and Book(M).

---

Question 11: Company ERD

One department employs many employees.
Answer: Department 1 -------- M Employee

---

Question 12: Hospital ERD

One doctor treats many patients.
Answer: Doctor 1 -------- M Patient

---

Question 13: Convert ERD to Relations (1:M)

Student 1 ------ M Exam
Answer:
Student(StudentID PK, Name)
Exam(ExamID PK, Subject, StudentID FK)
Foreign key goes to the "many" side.

---

Question 14: Convert ERD to Relations (M:N)

Customer M ------ M Product
Answer:
Customer(CustomerID PK, Name)
Product(ProductID PK, ProductName)
Order(CustomerID FK, ProductID FK)
Many-to-Many requires a junction table.

---

Question 15: Steps in designing an ER Diagram

1. Identify entities.
2. Identify attributes.
3. Select primary keys.
4. Identify relationships.
5. Determine cardinality.
6. Draw entities and attributes.
7. Connect relationships.
8. Validate design.

ICT Online Class 0729622034

🏆 Frequently Asked ERD Scenarios & Golden Rules

Frequently Asked A/L ERD Scenarios

Scenario	Relationship
Student – Course	M:N
Customer – Order	1:M
Department – Employee	1:M
Teacher – Class	1:M
Doctor – Patient	1:M
Library Member – Book	M:N
Supplier – Product	M:N
Hotel – Room	1:M
Passenger – Ticket	1:M
Employee – Project	M:N

---

🌟 Golden Rule for Exams

1:1 Relationship
→ Foreign key in either table.

1:M Relationship
→ Foreign key on the MANY side.

M:N Relationship
→ Create a new associative (junction) table containing both foreign keys.

Mastering these three cases will help solve almost every ERD question in GCE A/L ICT Unit 8.

ICT Online Class 0729622034

🎓 Expert ICT, Coding, School Classes, Digital Marketing & University Project Guidance

Struggling with your university final year project? Want to master coding, upscale your business with expert digital marketing, or learn absolute computer basics from scratch? We offer high-quality individual and group online classes conducted in English, Sinhala, or Tamil mediums. Get guaranteed academic success and professional growth with tailored guidance.

---

🎓 University Final Year Project Guidance & AI

Get specialized, end-to-end mentoring and technical support to pass your degree or master's program with flying colors:

• 🏫 Targeted Institutes: Expert guidance tailored for BIT UCSC, UoM, SLIIT, NIBM, and other leading universities.
• 🔬 Postgraduate Support: Comprehensive assistance for MSc Software Final Year Projects.
• 🤖 AI & Smart Applications: Step-by-step implementation of AI, Machine Learning (ML), and automation modules.
• ✅ Guaranteed Success: Help with documentation, system architecture, coding, and viva preparation.

---

🏫 School ICT & Corporate Beginner Classes

• 💻 Non-IT Staff Computer Basics: Absolute beginner-friendly online classes covering essential computer skills, office tools, and internet operations.
• 🎒 Primary & Secondary (Grades 1-10): Interactive online ICT classes tailored to build strong foundations from early ages.
• 📝 Exam Prep: Dedicated training packages for GCE O/L, GCE A/L ICT, and GIT exams.
• 🌍 Global Syllabuses: Complete curriculum coverage for Local, Edexcel, and Cambridge in English & Tamil Mediums.

---

📢 Software Development & Digital Marketing Services

• ⚙️ Software & Web Development: Professional custom software application and website development built using PHP & MySQL.
• 🎯 Social Media Management: Content creation, publishing, and channel management for Facebook, Instagram, TikTok, and YouTube.
• 📈 Ad Boosting: Highly targeted paid advertising campaigns to drive leads, traffic, and sales to your business.

---

📞 Connect With Us Instantly

Book your slot for online classes or get a premium tech service quote today!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com

---

🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

• 📺 YouTube Tutorials: Subscribe to our Channel
• 💼 Professional Network: Connect on LinkedIn
• ✍️ Tech Blog: Visit our WordPress Site
• ❓ Project Q&A: Follow our Quora Guide Profile
• 📰 Monthly Updates: Read Our Newsletter
• 🌐 Official Portfolios: Wix Site | Google Business | Strikingly Portfolio
• 🗣️ Student Forum: Join our ElaKiri Discussion Thread

Microsoft Word Guide, Basic to Advanced, Masterclass 2026 Edexcel Cambridge Local ICT best Microsoft Word guide Beginner Student Friendly

Microsoft Word Master Course (Basic to Advanced)

A comprehensive, practical guide with best practices, examples, and keyboard shortcuts.

Module 1: Introduction to Microsoft Word

What is Microsoft Word?

Microsoft Word is a powerful word-processing application developed by Microsoft, used to create, edit, format, and print text-based documents. Common uses include:

• Letters & Business Correspondence
• CVs / Resumes
• Reports & Academic Assignments
• Books & E-books
• Invoices & Forms
• Flyers, Newsletters & Certificates

Word File Extensions

Extension	Description
.docx	Modern Word Document (Default, XML-based, smaller file size)
.doc	Older Word Document (Word 97-2003 format)
.pdf	Portable Document Format (Read-only, preserves formatting)
.dotx	Word Template (Used to create new documents with pre-set formatting)
.rtf	Rich Text Format (Cross-platform compatibility)
.txt	Plain Text (No formatting, fonts, or images)

Module 2: Understanding the Word Interface

The Ribbon Interface

The Ribbon is the strip of buttons and icons located above the work area. It is organized into three logical parts:

• Tabs: Home, Insert, Design, Layout, References, etc.
• Groups: Categories of related commands within each tab (e.g., "Font", "Paragraph").
• Commands: The actual buttons, boxes, or menus you click to perform an action.

Key Interface Elements

• Quick Access Toolbar (QAT): Located at the very top left. Customize it with frequently used commands like Save, Undo, and Print.
• Title Bar: Displays the document name and application.
• Ruler: Helps set margins, indents, and tabs. (Enable via View > Ruler).
• Status Bar: Located at the bottom. Shows page number, word count, language, and document view shortcuts.

💡 Best Practice: Right-click the Ribbon and select "Collapse the Ribbon" (or press Ctrl + F1) to maximize your screen space while writing.

Module 3: Basic Formatting & Editing

Essential Text Formatting

• Font & Size: Change typeface and size via the Home tab.
• Emphasis: Bold (Ctrl + B), Italic (Ctrl + I), Underline (Ctrl + U).
• Highlight & Text Color: Use the 'A' with a color bar for text color, and the marker icon for highlighting.

Paragraph Formatting

• Alignment: Left (Ctrl + L), Center (Ctrl + E), Right (Ctrl + R), Justify (Ctrl + J).
• Line Spacing: Adjust space between lines (1.0, 1.5, 2.0) via the Paragraph group.
• Bullets & Numbering: Organize lists for better readability.

Top 5 Essential Shortcuts

Action	Windows Shortcut	Mac Shortcut
Save Document	Ctrl + S	Cmd + S
Undo Action	Ctrl + Z	Cmd + Z
Find Text	Ctrl + F	Cmd + F
Replace Text	Ctrl + H	Cmd + Shift + H
Select All	Ctrl + A	Cmd + A

Module 4: Intermediate Skills (Layout & Objects)

Working with Pages

• Page Breaks: Never press "Enter" repeatedly to reach a new page. Use Ctrl + Enter to insert a clean Page Break.
• Margins & Orientation: Go to Layout > Margins or Orientation (Portrait/Landscape).

Tables, Images & Shapes

• Tables: Insert via Insert > Table. Use the contextual Table Design and Layout tabs to merge cells and adjust borders.
• Images: Insert via Insert > Pictures.
• Text Wrapping: Crucial for formatting. Click the image, select the Layout Options icon, and choose "Square" or "Tight" to allow text to flow around it.

💡 Best Practice: Always use Styles (Heading 1, Heading 2, Normal) from the Home tab instead of manually changing font sizes. This is required for generating an automatic Table of Contents later.

Module 5: Advanced Features

Headers, Footers & Page Numbers

Double-click the very top or bottom of any page to open the Header/Footer area. Use Insert > Page Number to automatically number pages.

Table of Contents (TOC)

1. Apply Heading 1 to main chapters and Heading 2 to sub-chapters throughout your document.
2. Place your cursor at the beginning of the document.
3. Go to References > Table of Contents and select an automatic style.
4. To update: Right-click the TOC and select "Update Field".

Mail Merge

Used to create bulk letters, labels, or emails personalized for each recipient.

1. Prepare your data source (e.g., an Excel spreadsheet).
2. In Word, go to Mailings > Start Mail Merge.
3. Select Select Recipients > Use an Existing List and choose your Excel file.
4. Insert Merge Fields (e.g., «First_Name») into your document.
5. Click Preview Results, then Finish & Merge.

Track Changes & Comments

• Track Changes: Review > Track Changes. Records every insertion, deletion, and formatting change.
• Comments: Highlight text and click Review > New Comment to leave notes without altering the text.

Module 6: Professional Best Practices & Pro Shortcuts

Document Hygiene Best Practices

• Use Styles, not manual formatting: Ensures consistency and enables automated TOCs.
• Turn on Formatting Marks: Click the ¶ button (Home tab) or press Ctrl + Shift + 8 to see hidden spaces, tabs, and paragraph breaks.
• Save as PDF for sharing: Prevents formatting shifts when the recipient opens it on a different device.
• Use Section Breaks: (Layout > Breaks > Next Page) when you need different page orientations or margin settings in the same document.

Pro-Level Keyboard Shortcuts

Action	Shortcut
Format Painter (Copy/Paste formatting)	Ctrl + Shift + C / Ctrl + Shift + V
Insert Hyperlink	Ctrl + K
Go to specific page/section	Ctrl + G
Repeat last action	F4 or Ctrl + Y
Insert Non-breaking Space	Ctrl + Shift + Spacebar

Microsoft Word Practical Workbook

Hands-on exercises to build muscle memory and real-world skills.

Exercise 1 – Creating and Saving a Document

Objective

Learn how to open Microsoft Word, create a new document, and save it.

Task

Create a document named My First Word Document and save it in a folder called MS Word Practice.

Step-by-Step Instructions

1. Open Microsoft Word: Click Start Menu > Type "Word" > Click Microsoft Word (OR double-click the Desktop icon).
2. Create New Document: Click "Blank Document" OR press Ctrl + N.
3. Type Text: Enter the text: My First Word Document.
4. Save Document: Click File > Save As > Browse. Create a new folder named "MS Word Practice". Set File Name to Exercise 01.docx and click Save.

Keyboard Shortcuts

Function	Shortcut
New Document	Ctrl + N
Save	Ctrl + S

🏆 Challenge: Create another document named "My Second Document" and save it yourself without looking at the steps.

Exercise 2 – Basic Typing Practice

Objective

Learn typing, editing, and cursor movement.

Task

Type the following paragraph exactly as written:

"Microsoft Word is one of the most popular word processing applications in the world. It is used to create letters, reports, resumes, books and business documents."

Step-by-Step Instructions

1. Open a new document (Ctrl + N).
2. Type the paragraph exactly.
3. Save as: Exercise 02 Typing Practice.docx.
4. Practice moving the cursor through the text using: Arrow Keys, Home Key, and End Key.

Shortcuts

Function	Shortcut
New Document	Ctrl + N
Save	Ctrl + S
Beginning of Line	Home
End of Line	End

🏆 Challenge: Add a second paragraph describing yourself and your goals.

Exercise 3 – Selecting Text

Objective

Learn different methods of selecting text efficiently.

Task

Open "Exercise 02" and practice the following selection methods.

Step-by-Step Instructions

• Select One Word: Double-click any word. (Observe: Word becomes highlighted).
• Select One Sentence: Hold Ctrl and click anywhere inside the sentence.
• Select Paragraph: Triple-click the paragraph OR move cursor to the left margin and double-click.
• Select Entire Document: Press Ctrl + A.

Shortcuts

Function	Shortcut
Select All	Ctrl + A

🏆 Challenge: Select only the first paragraph using the mouse margin trick, then copy and paste it to the bottom of the page.

Exercise 4 – Bold, Italic and Underline

Objective

Learn text emphasis formatting.

Task

Type: Microsoft Word Formatting Practice

Step-by-Step Instructions

1. Bold Text: Select "Microsoft". Click Home Tab > Bold (B) OR press Ctrl + B.
2. Italic Text: Select "Word". Click Italic (I) OR press Ctrl + I.
3. Underline Text: Select "Formatting". Click Underline (U) OR press Ctrl + U.

🏆 Challenge: Make the word "Practice" both Bold and Italic at the same time.

Exercise 5 – Font Size and Font Style

Objective

Learn changing fonts and sizes.

Task

Type the following three lines and apply the specific formatting.

Step-by-Step Instructions

1. Type the text lines.
2. Select the text, go to the Home Tab, and use the Font dropdown to change the style.
3. Use the Font Size box to change the size.

Text to Type	Font	Size
Arial Example	Arial	14
Calibri Example	Calibri	16
Times New Roman Example	Times New Roman	18

Shortcuts

Function	Shortcut
Increase Font Size	Ctrl + Shift + >
Decrease Font Size	Ctrl + Shift + <

🏆 Challenge: Type your full name, set the font to Arial, and make the size 24.

Exercise 6 – Paragraph Alignment

Objective

Learn text alignment.

Task

Type the four lines below and apply the corresponding alignment to each.

Step-by-Step Instructions

• Type: Left Align → Select → Press Ctrl + L
• Type: Center Align → Select → Press Ctrl + E
• Type: Right Align → Select → Press Ctrl + R
• Type: Justify Align → Select → Press Ctrl + J

🏆 Challenge: Write a full 4-sentence paragraph and apply Justify alignment to make the edges perfectly straight.

Exercise 7 – Creating a Professional Letter

Objective

Learn business letter formatting.

Step-by-Step Instructions

1. Sender Info: Type your name, address, and date (e.g., 15 June 2026).
2. Recipient Info: Press Enter twice. Type: HR Manager, ABC Company, Colombo.
3. Subject Line: Type: Subject: Application for Office Assistant. Make the entire subject line Bold.
4. Salutation: Type: Dear Sir/Madam,
5. Body: Type a brief 3-sentence letter body explaining your application.
6. Closing: Type: Yours Faithfully, followed by your name.

🏆 Challenge: Write a formal "Sick Leave Application" letter using this exact format.

Exercise 8 – Creating a Professional CV

Objective

Create a modern, structured resume.

Step-by-Step Instructions

1. Header: Type your name. Set Font Size to 20, make it Bold, and Center Align it.
2. Contact Info: Below your name, add your Phone, Email, and Address (Center Aligned).
3. Education: Type "Education". Apply the Heading 1 style from the Home tab.
4. Details: Add your education details using bullet points.
5. Skills: Type "Skills" (Heading 1). Add a bulleted list of 3-5 professional skills.
6. References: Type "References" (Heading 1) and add placeholder text.

🏆 Challenge: Insert a professional profile photo next to your name, and export the final document as a PDF (File > Save As > PDF).

🎓 Master ICT, Coding & Digital Marketing: Expert Project Guidance & Training

Struggling with your MSc, BIT, BSc, or HND final year project? Stop stressing. Get guaranteed success with our customized online training, tailored specifically to your academic and career goals. We offer individual and group online classes conducted in your preferred language: English, Sinhala, or Tamil.

---

🚀 Our Expert Training Programs

• 💻 Software Development: Complete mastery in PHP & Python.
• 🗄️ Automation & Databases: Hands-on training in MySQL & Oracle.
• 🌐 Web Development: Build modern Digital Marketing & E-Commerce sites.
• 🤖 Future Tech: Advanced training in AI & Machine Learning (ML) applications.
• 🛠️ Career Skills: Step-by-step guidance for Freelancing & Database Design.
• 📚 School & Uni Prep: All Grade ICT tutorials, comprehensive notes, and exam preparation.

---

🌟 Why Choose Us?

• ✅ Guaranteed Success: Step-by-step guidance for university and higher diploma projects.
• 🕒 Flexible Learning: Fully interactive online classes that fit your schedule.
• 🗣️ Multilingual Support: Learn complex coding concepts easily in English, Sinhala, or Tamil.

---

📞 Connect With Us Instantly

Take the first step toward clearing your exams and finishing your project with confidence!

💬 WhatsApp: +94 729622034

📧 Email: ITClassSL@gmail.com

---

🌐 Explore Our Resources & Communities

Stay updated with our latest tutorials, project ideas, and student guides across all our official platforms:

• 📺 YouTube Tutorials: Subscribe to our Channel
• 💼 Professional Network: Connect on LinkedIn
• ✍️ Tech Blog: Visit our WordPress Site
• ❓ Project Q&A: Follow our Quora Guide Profile
• 📰 Monthly Updates: Read Our Newsletter
• 🌐 Official Portfolios: Wix Site | Google Business | Strikingly Portfolio
• 🗣️ Student Forum: Join our ElaKiri Discussion Thread