SQL Database Design and Data Insertion for Course Management System

CREATE TABLE courses (\n course_id INT PRIMARY KEY,\n course_name VARCHAR(100)\n);\n\nCREATE TABLE questions (\n question_id INT PRIMARY KEY,\n course_id INT,\n question_text VARCHAR(500),\n option_a VARCHAR(100),\n option_b VARCHAR(100),\n option_c VARCHAR(100),\n option_d VARCHAR(100),\n correct_answer VARCHAR(1),\n FOREIGN KEY (course_id) REFERENCES courses(course_id)\n);\n\nCREATE TABLE exam_results (\n student_id INT,\n course_id INT,\n score INT,\n PRIMARY KEY (student_id, course_id),\n FOREIGN KEY (student_id) REFERENCES students(student_id),\n FOREIGN KEY (course_id) REFERENCES courses(course_id)\n);\n\n\nInserting Sample Data:\n\nCourses:\n\nINSERT INTO courses (course_id, course_name) VALUES (1, 'Mathematics');\nINSERT INTO courses (course_id, course_name) VALUES (2, 'English');\nINSERT INTO courses (course_id, course_name) VALUES (3, 'Science');\n\nQuestions:\n\nINSERT INTO questions (question_id, course_id, question_text, option_a, option_b, option_c, option_d, correct_answer) VALUES (1, 1, 'What is 2+2?', '3', '4', '5', '6', 'B');\nINSERT INTO questions (question_id, course_id, question_text, option_a, option_b, option_c, option_d, correct_answer) VALUES (2, 1, 'What is the square root of 16?', '2', '4', '6', '8', 'B');\nINSERT INTO questions (question_id, course_id, question_text, option_a, option_b, option_c, option_d, correct_answer) VALUES (3, 2, 'What is the opposite of "good"?', 'Bad', 'Nice', 'Happy', 'Sad', 'A');\nINSERT INTO questions (question_id, course_id, question_text, option_a, option_b, option_c, option_d, correct_answer) VALUES (4, 2, 'What is the past tense of "eat"?', 'Eating', 'Ate', 'Eaten', 'Eats', 'B');\nINSERT INTO questions (question_id, course_id, question_text, option_a, option_b, option_c, option_d, correct_answer) VALUES (5, 3, 'What is the boiling point of water?', '50ﾰC', '75ﾰC', '100ﾰC', '125ﾰC', 'C');\nINSERT INTO questions (question_id, course_id, question_text, option_a, option_b, option_c, option_d, correct_answer) VALUES (6, 3, 'What is the largest organ in the human body?', 'Heart', 'Liver', 'Lungs', 'Skin', 'D');\n\nExam Results:\n\nINSERT INTO exam_results (student_id, course_id, score) VALUES (101, 1, 80);\nINSERT INTO exam_results (student_id, course_id, score) VALUES (102, 1, 90);\nINSERT INTO exam_results (student_id, course_id, score) VALUES (103, 2, 75);\nINSERT INTO exam_results (student_id, course_id, score) VALUES (104, 2, 85);\nINSERT INTO exam_results (student_id, course_id, score) VALUES (105, 3, 70);\nINSERT INTO exam_results (student_id, course_id, score) VALUES (106, 3, 80);