sqlfile.php

-- school_init.sql
CREATE DATABASE IF NOT EXISTS school_system CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE school_system;

-- users (admins, teachers, students could be user roles)
CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  username VARCHAR(100) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  email VARCHAR(150),
  full_name VARCHAR(200),
  role ENUM('admin','teacher','student','staff') NOT NULL DEFAULT 'student',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  is_active TINYINT(1) DEFAULT 1
);

-- departments
CREATE TABLE departments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(150) NOT NULL,
  code VARCHAR(20) UNIQUE,
  description TEXT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- students (profile + link to users)
CREATE TABLE students (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT UNIQUE, -- optional link to users table if login per student
  student_number VARCHAR(50) UNIQUE NOT NULL,
  first_name VARCHAR(100),
  last_name VARCHAR(100),
  department_id INT,
  email VARCHAR(150),
  phone VARCHAR(50),
  admission_date DATE,
  status ENUM('active','suspended','dismissed','graduated') DEFAULT 'active',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE SET NULL,
  FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE SET NULL
);

-- staff
CREATE TABLE staff (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT UNIQUE,
  staff_number VARCHAR(50) UNIQUE,
  first_name VARCHAR(100),
  last_name VARCHAR(100),
  role_title VARCHAR(100),
  department_id INT,
  email VARCHAR(150),
  phone VARCHAR(50),
  hire_date DATE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE SET NULL,
  FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE SET NULL
);

-- assignments
CREATE TABLE assignments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255),
  description TEXT,
  posted_by INT, -- staff.user id
  department_id INT,
  due_date DATE,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (posted_by) REFERENCES users(id) ON DELETE SET NULL,
  FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE SET NULL
);

-- notices
CREATE TABLE notices (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255),
  body TEXT,
  posted_by INT,
  visible_to ENUM('all','students','staff','admins') DEFAULT 'all',
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (posted_by) REFERENCES users(id) ON DELETE SET NULL
);

-- messages (simple inbox)
CREATE TABLE messages (
  id INT AUTO_INCREMENT PRIMARY KEY,
  sender_id INT,
  recipient_id INT,
  subject VARCHAR(255),
  body TEXT,
  is_read TINYINT(1) DEFAULT 0,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (sender_id) REFERENCES users(id) ON DELETE SET NULL,
  FOREIGN KEY (recipient_id) REFERENCES users(id) ON DELETE SET NULL
);

-- results (per student per semester)
CREATE TABLE results (
  id INT AUTO_INCREMENT PRIMARY KEY,
  student_id INT,
  course_code VARCHAR(50),
  course_title VARCHAR(255),
  semester VARCHAR(30),
  grade VARCHAR(10),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (student_id) REFERENCES students(id) ON DELETE CASCADE
);

-- timetable
CREATE TABLE timetables (
  id INT AUTO_INCREMENT PRIMARY KEY,
  department_id INT,
  course_code VARCHAR(50),
  venue VARCHAR(100),
  start_time DATETIME,
  end_time DATETIME,
  instructor_id INT, -- staff.user id
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE SET NULL,
  FOREIGN KEY (instructor_id) REFERENCES users(id) ON DELETE SET NULL
);

-- payments
CREATE TABLE payments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  student_id INT,
  amount DECIMAL(10,2),
  method ENUM('card','mobile_money','bank') DEFAULT 'bank',
  reference VARCHAR(200),
  status ENUM('pending','completed','failed') DEFAULT 'pending',
  paid_at DATETIME,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (student_id) REFERENCES students(id) ON DELETE CASCADE
);

-- courses (for course registration)
CREATE TABLE IF NOT EXISTS courses (
  id INT AUTO_INCREMENT PRIMARY KEY,
  code VARCHAR(50) NOT NULL,
  title VARCHAR(255) NOT NULL,
  department_id INT,
  credits INT DEFAULT 3,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE SET NULL
);

-- registrations (student course registrations)
CREATE TABLE IF NOT EXISTS registrations (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  course_id INT NOT NULL,
  semester VARCHAR(50),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  UNIQUE (user_id, course_id, semester),
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
  FOREIGN KEY (course_id) REFERENCES courses(id) ON DELETE CASCADE
);

-- assignment_uploads (students upload solutions)
CREATE TABLE IF NOT EXISTS assignment_uploads (
  id INT AUTO_INCREMENT PRIMARY KEY,
  assignment_id INT NOT NULL,
  user_id INT NOT NULL,
  filename VARCHAR(255) NOT NULL,
  filepath VARCHAR(500) NOT NULL,
  uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (assignment_id) REFERENCES assignments(id) ON DELETE CASCADE,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- exams
CREATE TABLE IF NOT EXISTS exams (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  department_id INT,
  duration_minutes INT DEFAULT 30,
  start_at DATETIME,
  end_at DATETIME,
  created_by INT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (department_id) REFERENCES departments(id) ON DELETE SET NULL,
  FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET NULL
);

-- exam_questions
CREATE TABLE IF NOT EXISTS exam_questions (
  id INT AUTO_INCREMENT PRIMARY KEY,
  exam_id INT NOT NULL,
  question TEXT NOT NULL,
  option_a VARCHAR(255),
  option_b VARCHAR(255),
  option_c VARCHAR(255),
  option_d VARCHAR(255),
  correct_option CHAR(1), -- 'a'..'d'
  points INT DEFAULT 1,
  FOREIGN KEY (exam_id) REFERENCES exams(id) ON DELETE CASCADE
);

-- exam_submissions (student answers & score)
CREATE TABLE IF NOT EXISTS exam_submissions (
  id INT AUTO_INCREMENT PRIMARY KEY,
  exam_id INT NOT NULL,
  user_id INT NOT NULL,
  score INT DEFAULT 0,
  total INT DEFAULT 0,
  submitted_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (exam_id) REFERENCES exams(id) ON DELETE CASCADE,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- exam_answers (store each selected answer)
CREATE TABLE IF NOT EXISTS exam_answers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  submission_id INT NOT NULL,
  question_id INT NOT NULL,
  chosen CHAR(1),
  FOREIGN KEY (submission_id) REFERENCES exam_submissions(id) ON DELETE CASCADE,
  FOREIGN KEY (question_id) REFERENCES exam_questions(id) ON DELETE CASCADE
);

-- attendance (biometric placeholder)
CREATE TABLE IF NOT EXISTS attendance (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  recorded_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  status ENUM('present','absent','late') DEFAULT 'present',
  method ENUM('manual','biometric') DEFAULT 'manual',
  notes TEXT,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);

-- transcripts (cached / generated snapshots)
CREATE TABLE IF NOT EXISTS transcripts (
  id INT AUTO_INCREMENT PRIMARY KEY,
  user_id INT NOT NULL,
  generated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  data TEXT, -- JSON or CSV text
  filename VARCHAR(255),
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
);


-- sample admin user
INSERT INTO users (username, password_hash, email, full_name, role) VALUES
('admin', '{REPLACE_WITH_HASH}', 'admin@school.local', 'System Administrator', 'admin');

-- Note: replace {$2y$10$8KCYeffmuc/sZjOue.n5/OU/IAaZpvFmIZrFwT5UYW8B/IeAscS8i} with an actual hash generated using password_hash in PHP,
-- or create the admin user later through a seed script.








INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(1, 'CSC101A', 'History of Computing'),
(1, 'CSC101B', 'Computer Hardware Basics'),
(1, 'CSC101C', 'Introduction to Algorithms'),
(1, 'CSC101D', 'Digital Logic Foundations');


INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(2, 'CSC102A', 'Variables & Data Types'),
(2, 'CSC102B', 'Control Structures in C'),
(2, 'CSC102C', 'Functions in C'),
(2, 'CSC102D', 'Pointers and Memory'),
(2, 'CSC102E', 'File Handling in C');



INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(3, 'BAM111A', 'Introduction to Management'),
(3, 'BAM111B', 'Organizational Behavior'),
(3, 'BAM111C', 'Decision Making'),
(3, 'BAM111D', 'Leadership & Motivation');



INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(4, 'ENG201A', 'AC Circuit Analysis'),
(4, 'ENG201B', 'Network Theorems II'),
(4, 'ENG201C', 'Power Calculations'),
(4, 'ENG201D', 'Resonance in Circuits');


INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(5, 'NUR105A', 'Cells & Tissues'),
(5, 'NUR105B', 'Skeletal System'),
(5, 'NUR105C', 'Muscular System'),
(5, 'NUR105D', 'Nervous System');


INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(6, 'MCM120A', 'History of Broadcasting'),
(6, 'MCM120B', 'Radio Production Basics'),
(6, 'MCM120C', 'TV Presenting Skills'),
(6, 'MCM120D', 'Broadcast Equipment Basics');


INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(7, 'CYS210A', 'Introduction to Cyber Attacks'),
(7, 'CYS210B', 'Footprinting & Recon'),
(7, 'CYS210C', 'Scanning Networks'),
(7, 'CYS210D', 'Vulnerability Assessment');


INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(8, 'SWE201A', 'Requirements Gathering'),
(8, 'SWE201B', 'Functional vs Non-Functional Requirements'),
(8, 'SWE201C', 'Use Case Modeling'),
(8, 'SWE201D', 'Software Specification Techniques');




INSERT INTO courses (level_id, code, title, credit, department_id, level, semester, description)
VALUES (1, 'LAW101', 'Law', 3, NULL, '100 Level', 'First Semester', 'Law department main course');

INSERT INTO courses (level_id, code, title, credit, department_id, level, semester, description)
VALUES (1, 'MKT101', 'Marketing', 3, NULL, '100 Level', 'First Semester', 'Marketing department main course');

INSERT INTO courses (level_id, code, title, credit, department_id, level, semester, description)
VALUES (1, 'SCI101', 'Science', 3, NULL, '100 Level', 'First Semester', 'Science department main course');

SELECT id, title FROM courses WHERE level_id = 1;

INSERT INTO course_subjects (course_id, subject_name)
VALUES
 (10, 'Business Law'),
 (10, 'Account Law'),
 (10, 'Sales Law');

 INSERT INTO course_subjects (course_id, subject_name)
VALUES
 (11, 'Strategic Marketing'),
 (11, 'Profit and Loss'),
 (11, 'Auditing');

 INSERT INTO course_subjects (course_id, subject_name)
VALUES
 (12, 'Agriculture'),
 (12, 'Biology'),
 (12, 'Chemistry');


 INSERT INTO courses_subjects(course_id,subject_code,subject_title) VALUES 
(1,'AC101','Recording Financial Transactions'),  
(1,'AC101','Information management'),  
(1,'AC101','Maintaining Financial Records');

INSERT INTO courses_subjects(course_id,subject_code,subject_title) VALUES 
(2,'AHSC101','Responsibility of a health and social worker'),
(2,'AHSC101','Person-centred Approaches in Health and Social Care Settings '),
(2,'AHSC101',' Effective Communication and Ethical Practice in Health and Social Care'),
(2,'AHSC101','Health Promotion'),
(2,'AHSC101',' Diabetes Awareness'),
(2,'AHSC101','Stroke Awareness and Management'),
(2,'AHSC101','Dementia Awareness'),
(2,'AHSC101','Mental Health Awareness');





JOURNALISM  
Introduction To Journalism 
Media & Society 
Media Ethics & Regulation 
English For Journalists & Writers

OFFICE MANAGEMENT 
Accounting 
Business Management & Administration 
Computer Appreciation & Applications 
International Business Communications 
Office Procedures & Administration 

MANAGING HEALTH AND SAFETY  
Essentials Of Health & Safety Management 
Working Practices, Hazards & Controls 
Working Environment & Occupational Health 
Accident & Emergency Procedures 

MARKETING MANAGEMENT 
Business Management & Administration 
International Business Communications 
Marketing 
Numeracy & Statistics 

TOURISM AND BUSINESS STUDIES  
Characteristics Of World Destinations 
Fundamentals Of The Hotel & Catering Industry 
Numeracy & Statistics 
Retail Travel Operations 
Structure Of Travel & Tourism 

DATA SCIENCE 
The Field of Data Science 
Python for Data Science 
Creating and Interpreting 
Visualisations in Data Science 
Data and Descriptive Statistics in Data Science 
Fundamentals of Data Analytics 
Data Analytics with Python 
Machine Learning Methods and Models in Data Science 
The Machine Learning Process 
Linear Regression in Data Science 
Logistic Regression in Data Science 
Decision Trees in Data Science 
K-means Clustering in Data Science 
Synthetic Data for Privacy and Security in Data Science 
Graphs and Graph Data Science 

EARLY CHILDHOOD EDUCATION 
Supporting healthy lifestyles for children through food, nutrition and exercise 
Supporting physical care routines for children and for unwell children 
Promoting children’s emotional well-being, social and emotional development 
The role of the Early Years practitioner 
Legislation relating to Early Years practice 
Working in partnership 
Supporting children through play in Early Years 
Developing the literacy, mathematical and communication skills of children 
Understand the needs of the child in preparing for school 
Understanding children’s cognitive development 
Promoting the physical development of children 
Supporting children with additional needs 
Using studies and tools to promote the development of children 
Professional development for Early Years Educators 
Understanding the needs of the mother and baby pre-conception, during pregnancy and the first year of 
life



INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(4, 'CS101', 'Threat and Risk: Expecting the Unexpected'),
(4, 'CS101', 'Network Architecture: Communications and Protocols'),
(4, 'CS101', 'Mobile Device and Data Risks'),
(4, 'CS101', 'Investigations and Incident Response'),
(4, 'CS101', 'Solutions: Future-Proofing your Business'),
(4, 'CS101', 'EU GDPR and Data Security');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(5, 'ET101', 'Understanding roles, responsibilities and relationships in education and training'),
(5, 'ET101', 'Facilitate Learning and Development for Individuals'),
(5, 'ET101', 'Facilitate Learning and Development in Groups'),
(5, 'ET101', 'Understanding Assessment in Education and Training'),
(5, 'ET101', 'Understanding the Principles and Practices of Assessment'),
(5, 'ET101', 'Understanding and using inclusive teaching and learning approaches in education and training');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(6, 'ENG101', 'Engineering Principles'),
(6, 'ENG101', 'Design Technology'),
(6, 'ENG101', 'Electricity'),
(6, 'ENG101', 'Mechanics'), 
(6, 'ENG101', 'Introducing Statistics'),
(6, 'ENG101', 'Mathematics');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(7, 'HSC101', 'Responsibilities of a Health and Social Care worker'),
(7, 'HSC101', 'Personal and Professional Development in Health and Social Care'),
(7, 'HSC101', 'Effective Communication and Ethical Practice in Health and Social Care'),
(7, 'HSC101', 'Health, Safety and Wellbeing in Health and Social Care Settings'),
(7, 'HSC101', 'Person-centred Approaches in Health and Social Care Settings'),
(7, 'HSC101', 'Effective Handling of Information in Health and Social Care Settings');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(8, 'IT101', 'Computer Systems'),
(8, 'IT101', 'Coding and Website Development'),
(8, 'IT101', 'Networks'),
(8, 'IT101', 'Mobile Communications'),
(8, 'IT101', 'Cyber Security'),
(8, 'IT101', 'Social Media for Business');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(9, 'HM101', 'Hotel & Catering Law'),
(9, 'HM101', 'Accounting, Purchasing & Cost Control'),
(9, 'HM101', 'The Human Resource In Hospitality'),
(9, 'HM101', 'Hospitality Management'),
(9, 'HM101', 'Marketing For Hospitality & Tourism');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(10, 'PY101', 'D/651/4741 Getting Started with Python'),
(10, 'PY101', 'F/651/4742 Writing Python Programmes'),
(10, 'PY101', 'H/651/4743 Data Types and Classes'),
(10, 'PY101', 'J/651/4744 Building and Running Python Applications');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(11, 'LAW101', 'K/650/9381 Introduction to Law and Practice'),
(11, 'LAW101', 'L/650/9382 Principles of Contract Law'),
(11, 'LAW101', 'M/650/9283 Principles of Criminal Law'),
(11, 'LAW101', 'R/650/9384 Introduction to Employment Law');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(12, 'JM101', 'Introduction To Journalism'),
(12, 'JM101', 'Media & Society'),
(12, 'JM101', 'Media Ethics & Regulation'),
(12, 'JM101', 'English For Journalists & Writers');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(13, 'OM101', 'Accounting'),
(13, 'OM101', 'Business Management & Administration'),
(13, 'OM101', 'Computer Appreciation & Applications'),
(13, 'OM101', 'International Business Communications'),
(13, 'OM101', 'Office Procedures & Administration');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(14, 'MHS101', 'Essentials Of Health & Safety Management'),
(14, 'MHS101', 'Working Practices, Hazards & Controls'),
(14, 'MHS101', 'Working Environment & Occupational Health'),
(14, 'MHS101', 'Accident & Emergency Procedures');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(15, 'MM101', 'Business Management & Administration'),
(15, 'MM101', 'International Business Communications'),
(15, 'MM101', 'Marketing'),
(15, 'MM101', 'Numeracy & Statistics');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(16, 'TBS101', 'Characteristics Of World Destinations'),
(16, 'TBS101', 'Fundamentals Of The Hotel & Catering Industry'),
(16, 'TBS101', 'Numeracy & Statistics'),
(16, 'TBS101', 'Retail Travel Operations'),
(16, 'TBS101', 'Structure Of Travel & Tourism');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(17, 'DS101', 'The Field of Data Science'),
(17, 'DS101', 'Python for Data Science'),
(17, 'DS101', 'Creating and Interpreting Visualisations in Data Science'),
(17, 'DS101', 'Data and Descriptive Statistics in Data Science'),
(17, 'DS101', 'Fundamentals of Data Analytics'),
(17, 'DS101', 'Data Analytics with Python'),
(17, 'DS101', 'Machine Learning Methods and Models in Data Science'),
(17, 'DS101', 'The Machine Learning Process'),
(17, 'DS101', 'Linear Regression in Data Science'),
(17, 'DS101', 'Logistic Regression in Data Science'),
(17, 'DS101', 'Decision Trees in Data Science'),
(17, 'DS101', 'K-means Clustering in Data Science'),
(17, 'DS101', 'Synthetic Data for Privacy and Security in Data Science'),
(17, 'DS101', 'Graphs and Graph Data Science');

INSERT INTO course_subjects (course_id, subject_code, subject_title) VALUES
(18, 'ECE101', 'Supporting healthy lifestyles for children through food, nutrition and exercise'),
(18, 'ECE101', 'Supporting physical care routines for children and for unwell children'),
(18, 'ECE101', 'Promoting children’s emotional well-being, social and emotional development'),
(18, 'ECE101', 'The role of the Early Years practitioner'),
(18, 'ECE101', 'Legislation relating to Early Years practice'),
(18, 'ECE101', 'Working in partnership'),
(18, 'ECE101', 'Supporting children through play in Early Years'),
(18, 'ECE101', 'Developing the literacy, mathematical and communication skills of children'),
(18, 'ECE101', 'Understand the needs of the child in preparing for school'),
(18, 'ECE101', 'Understanding children’s cognitive development'),
(18, 'ECE101', 'Promoting the physical development of children'),
(18, 'ECE101', 'Supporting children with additional needs'),
(18, 'ECE101', 'Using studies and tools to promote the development of children'),
(18, 'ECE101', 'Professional development for Early Years Educators'),
(18, 'ECE101', 'Understanding the needs of the mother and baby pre-conception, during pregnancy and the first year of life');


EARLY CHILDHOOD EDUCATION  
H/650/1099 Academic Writing and Research Skills   
J/651/3763 Nurturing Growth and Development in Early Childhood   
K/651/3764 Fostering Collaborative and Inclusive Relationships in Early Childhood Setting   
L/651/3765 Learning and Development Through Play  
M/651/3766 Unlocking Words: Exploring Early Language and Communication   
R/651/3767 Early Personal, Social and Emotional Development 

ACCOUNTING 
H/650/1099 Academic Writing and Research Skills  
T/650/1760 Business and the Economic Environment  
R/650/1912 Principles of Financial Accounting  
M/650/1911 Quantitative Methods in a Business Context   
Y/650/1914 Management Accounting  
T/650/1148 Leading and Managing Teams 

BUSINESS MANAGEMENT 
H/650/1099 Academic Writing and Research Skills  
L/650/1145 Business Operations   
M/650/1146 Communication in Business   
R/650/1147 Finance and Accounting  
T/650/1148 Leading and Managing Teams  
Y/650/1149 Operating in a Global Context 

LAW  
R/650/4965 An Introduction to the English Legal System  
T/650/4966 Academic Writing and Research Skills for Law   
Y/650/4967 Contract Law   
A/650/4968 Business Law  
D/650/4969 Public Law  
J/650/4970 Criminal Law   
K/650/4971 Company Law and Corporate Governance   
L/650/4972 Employment Law 
M/650/4973 International Business Law  
R/650/4974 Land Law  
T/650/4975 Tort Law  
Y/650/4976 Legal Research Methods and Professional Skills  

INFORMATION TECHNOLOGY  
D/650/3383 Cyber Security  
F/650/3384 Principles of Computer Programming  
F/617/2266 Systems Analysis and Design  
H/650/3385 Web and Mobile Applications  
L/617/2268 Computer and Network Technology  
J/650/3386 Managing Digital Information 

CYBER SECURITY  
A/651/4218 Information Technology Security 
D/651/4219 Principles of Computer Science  
J/651/4220 Algorithms and Data Structures   
K/651/4221 Computer Networks 
L/651/4222 Mathematics for Computer Science  
M/651/4223 Operating Systems  
R/651/4224 Security Testing  
T/651/4225 Artificial Intelligence   
Y/651/4226 Databases  
A/651/4227 Digital Forensics  
D/651/4228 Ethical Hacking 

TOURISM AND HOSPITALITY MANAGEMENT  
H/650/1099 Academic Writing and Research Skills   
A/650/1159 Business Environment for Tourism and Hospitality  
T/650/1157 Services Marketing in Tourism and Hospitality   
Y/650/1158 Sustainability in Tourism and Hospitality  
H/650/1160 Events Management  
J/650/1161 The Development of the Tourism and Hospitality Industry 

JOURNALISM AND MEDIA STUDIES 
Broadcast Journalism 
Newspaper Reporting 
Sub-editing 
Freelance & Feature Writing 
Media Law & Ethics 

MARKETING MANAGEMENT  
Business Management & Administration 
International Business Communications 
Marketing 
Numeracy & Statistics 

LOGISTICS AND SUPPLY CHAIN MANAGEMENT 
H/650/1099 Academic Writing and Research Skills  
R/650/1100 Logistics and the Business Environment  
T/650/1101 Operations and Logistics Management  
Y/650/1102 Finance and Accounting  
A/650/1103 Communication in Business   
D/650/1104 Leading and Managing Teams 

OIL AND GAS MANAGEMENT  
Introduction to Petroleum Geology 
Petroleum Exploration and Production 
Project Start-Up and Analysis 
Risk Analysis and Management 

HEALTH AND SOCIAL CARE 
K/650/1117 Promoting Equality, Diversity and Inclusion in Health and Social Care  
K/650/1144 Professional Development and Academic Writing  
L/650/1118 Communication in the Caring Professions  
M/650/1119 Principles of Health and Safety for Health Professions 
L/650/1136 Assessment Processes in Health and Social Care Settings  
M/650/1137 Resource Management in Health and Social Care 

HUMAN RESOURCE DEVELOPMENT 
Business and its External Environment  
Strategic Management 
Strategic HRM and Organizational Effectiveness 
Human Resource Management in Practice 
Business Law 
Business Management & Administration 
Human Resource Development I 
International Business Communications 

BANKING AND FINANCE  
Introduction to Banking and Financial Management 
Introduction to Accounting and Financial Analysis 
Introduction to Economics 
Investment Management 
Business and the Financial Environment 

PROJECT MANAGEMENT 
M/650/4856 Principles of Project Management  
R/650/4866 People Management   
T/650/4867 Introduction to Business Finance  
A/650/4869 Fundamentals of Management in Projects  
Y/650/4868 Business Marketing  
H/650/4870 Personal and Professional Development  
J/650/4871 Operations Management in Projects 
K/650/4872 Project Quality Management  
L/650/4873 Business Strategy and Sustainability   
M/650/4874 Responsible Business Practices   
R/650/4875 Project Planning, Execution and Evaluation  
T/650/4876 Digital Business Practices  

MANAGING HEALTH AND SAFETY  
Essentials Of Health & Safety Management 
Working Practices, Hazards & Controls 
Working Environment & Occupational Health 
Accident & Emergency Procedures 
SECURITY AND RISK MANAGEMENT 
Strategic Knowledge Areas in Security and Risk Management  
Security and Risk Management in Practice 
Conflict Management 
Health and Safety Management 
Strategic Problem Solving 

EDUCATION AND TRAINING 
K/650/3918 Principles of Education and Training   
A/650/3913 Design Education and Training Provision   
A/617/4985 Engage Learners in Education and Training  
F/617/4986 Plan, Allocate and Monitor Work in Own Area of Responsibility  
J/617/4987 Evaluate Education and Training Provision  
D/650/3914 Professional Development and Reflection 

PSYCHOLOGY  
D/650/1277 The Scope of Psychology  
F/650/1278 Introduction to Social and Development Psychology  
H/650/1279 Biopsychology   
L/650/1280 The Development of Attachments  
M/650/1281 Processes of Human Memory  
R/650/1282 Research Methods and Investigating Psychology  

TOURISM AND BUSINESS STUDIES  
Accounting 
Business Management & Administration 
Management Of Travel & Tourism Operations 
Tour Operations 
Tourism Marketing & Promotion 
OFFICE MANAGEMENT 
Business Law 
Human Resources Management 
Management Theory & Practice 
Purchasing Management 
Sales & Sales Management 

ARTIFICIAL INTELLIGENCE  
Introduction to Artificial Intelligence and Applications 
Mathematical Foundations for Machine Learning 
Data Science Using Python 
Big Data Management 
Introduction to Deep Learning 
Artificial Intelligence Ethics