faculties.sql

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

-- Insert faculties
INSERT INTO faculties (name) VALUES
                             ('Faculty of Business and Management'),
                             ('Faculty of Computer Science and Technology'),
                             ('Faculty of Creative Arts and Design'),
                             ('Faculty of Education'),
                             ('Faculty of Environmental Studies'),
                             ('Faculty of Social Sciences'),
                             ('Faculty of Information Technology and Security');


-- Insert programmes
INSERT INTO programmes (name, code, description, "durationInMonths", "facultyId")
VALUES
  ('Event Planning and People Management', 'EPPM001', 'Sample description for Event Planning and People Management', 24, 2),
  ('Virtual, Mixed and Augmented Reality Applications', 'VMARA001', 'Sample description for Virtual, Mixed and Augmented Reality Applications', 36, 3),
  ('Graphic Design, Animation and Gaming', 'GDAG001', 'Sample description for Graphic Design, Animation and Gaming', 48, 4),
  ('Digital Learning Technology for Teachers', 'DLTT001', 'Sample description for Digital Learning Technology for Teachers', 12, 5),
  ('Cloud Computing', 'CC001', 'Sample description for Cloud Computing', 24, 3),
  ('Artificial Intelligence Application', 'AIA001', 'Sample description for Artificial Intelligence Application', 36, 3),
  ('Digital and Social Media Marketing', 'DSMM001', 'Sample description for Digital and Social Media Marketing', 48, 2),
  ('Digital Forensic Accounting', 'DFA001', 'Sample description for Digital Forensic Accounting', 12, 2),
  ('Waste Management and Recycling', 'WMR001', 'Sample description for Waste Management and Recycling', 24, 6),
  ('Blockchain Technology', 'BT001', 'Sample description for Blockchain Technology', 36, 3),
  ('Virtual, Personal/Executive Assistant', 'VPEA001', 'Sample description for Virtual, Personal/Executive Assistant', 48, 8),
  ('Security Studies', 'SS001', 'Sample description for Security Studies', 12, 7),
  ('Christian Discipleship', 'CD001', 'Sample description for Christian Discipleship', 24, 7),
  ('Islamic Discipleship', 'ID001', 'Sample description for Islamic Discipleship', 36, 7),
  ('Security Information and Environmental Management (SIEM)', 'SIEM001', 'Sample description for Security Information and Environmental Management', 48, 8),
  ('Interior Design', 'ID001', 'Sample description for Interior Design', 12, 4),
  ('Data Science and Informatics', 'DSI001', 'Sample description for Data Science and Informatics', 24, 3)