

-- Insert Courses
INSERT INTO Courses (course_name, course_code, description) VALUES
('Introduction to Programming', 'CST101', 'Basic programming course'),
('Web Development', 'CST154', 'Introduction to web development'),
('Data Structures', 'CST221', 'Study of data structures like arrays, linked lists, etc.'),
('Database Management Systems', 'CST310', 'Introduction to database design and management'),
('Computer Networks', 'CST415', 'Basics of computer networking and protocols'),
('Operating Systems', 'CST530', 'Introduction to operating systems and their functions'),
('Software Engineering', 'CST615', 'Study of software development methodologies'),
('Artificial Intelligence', 'CST735', 'Fundamentals of AI and machine learning'),
('Machine Learning', 'CST824', 'Introduction to machine learning algorithms'),
('Cybersecurity', 'CST920', 'Introduction to security in computer systems');

INSERT INTO Instructors (first_name, last_name, email) VALUES
('Angela', 'Brown', 'abrown@songbird.edu'),
('James', 'Lee', 'jlee@songbird.edu'),
('Monica', 'White', 'mwhite@songbird.edu'),
('Derrick', 'Taylor', 'dtaylor@songbird.edu'),
('Sophia', 'Rodriguez', 'srodriguez@songbird.edu');
-- Instructor 1
INSERT INTO instructor_courses (instructor_id, course_id) VALUES (1, 1), (1, 2);
-- Instructor 2
INSERT INTO instructor_courses (instructor_id, course_id) VALUES (2, 3), (2, 4);
-- Instructor 3
INSERT INTO instructor_courses (instructor_id, course_id) VALUES (3, 5), (3, 6);
-- Instructor 4
INSERT INTO instructor_courses (instructor_id, course_id) VALUES (4, 7), (4, 8);
-- Instructor 5
INSERT INTO instructor_courses (instructor_id, course_id) VALUES (5, 9), (5, 10);