// TABLES

▸ Modules

moduleID	moduleCode	moduleName
1	ICT2611	Internet Programming
2	ICT2613	Internet Programming
3	ICT3612	Advanced Internet Programming
4	ICT3715	Web App Development
5	ICT3721	Database Design

▸ Lecturers

lecturerID	firstName	lastName	email	ACT
1	John	Smith	smithj@unisa.ac.za	[EDIT]
2	Mary	Johnson	johnsonm@unisa.ac.za	[EDIT]
3	Peter	Williams	williamsp@unisa.ac.za	[EDIT]
4	Susan	Brown	browns@unisa.ac.za	[EDIT]
5	David	Jones	jonesd@unisa.ac.za	[EDIT]

▸ Roles

roleID	roleName	roleDescription
1	Primary Lecturer	Main lecturer
2	Secondary Lecturer	Supporting
3	Internal Moderator	QA internal
4	External Moderator	QA external
5	Critical Reader	Content review

▸ ModuleLecturerRole

ID	Module	Lecturer	Role	ACT
1	ICT2611	John Smith	Primary Lecturer	[EDIT]
2	ICT2611	Mary Johnson	Secondary Lecturer	[EDIT]
3	ICT2611	Peter Williams	Internal Moderator	[EDIT]
4	ICT2613	John Smith	Primary Lecturer	[EDIT]
5	ICT2613	Susan Brown	Secondary Lecturer	[EDIT]
6	ICT2613	David Jones	External Moderator	[EDIT]
9	ICT3612	John Smith	Internal Moderator	[EDIT]
7	ICT3612	Mary Johnson	Primary Lecturer	[EDIT]
8	ICT3612	Peter Williams	Secondary Lecturer	[EDIT]
12	ICT3715	John Smith	External Moderator	[EDIT]
10	ICT3715	Susan Brown	Primary Lecturer	[EDIT]
11	ICT3715	David Jones	Secondary Lecturer	[EDIT]
15	ICT3721	Mary Johnson	Internal Moderator	[EDIT]
13	ICT3721	Peter Williams	Primary Lecturer	[EDIT]
14	ICT3721	David Jones	Secondary Lecturer	[EDIT]

// CRUD FORMS

// SELECT QUERIES

ORDER BY: SELECT * FROM Modules ORDER BY moduleCode
LIKE: SELECT * FROM Lecturers WHERE email LIKE "%@unisa.ac.za"
JOIN: SELECT m.moduleCode,CONCAT(l.firstName," ",l.lastName)as lecturer,r.roleName FROM ModuleLecturerRole mlr JOIN Modules m ON mlr.moduleID=m.moduleID JOIN Lecturers l ON mlr.lecturerID=l.lecturerID JOIN Roles r ON mlr.roleID=r.roleID
WHERE AND: SELECT * FROM Lecturers WHERE firstName LIKE "J%" AND email LIKE "%@unisa.ac.za"
MAX: SELECT MAX(moduleID) as maxID FROM Modules