Course: Database Given the following schemas for a student record: STUDENTS (student_id, student_name, region) COURSES (course_id, course_name, subject_type, lecturer_name) RESULTS (student_id,...

Course: Database

Given the following schemas for a student record:

STUDENTS (student_id, student_name, region)
COURSES (course_id, course_name, subject_type, lecturer_name)
RESULTS (student_id, course_id, score, result_status)

STUDENTS relation shows the information of the students. The COURSE relation specifies the course details. The RESULTS relation lists the scores that students obtain for each course taken.

*Please execute this SQL codes for creating the table schemas mentioned above, Then execute the tasks in the table accordingly using proper SQL queries and Write your answer into the Answer Template

CREATE TABLE STUDENTS (student_id VARCHAR(10) PRIMARY KEY, student_name VARCHAR(150), region VARCHAR(50));

CREATE TABLE COURSES (course_id VARCHAR(10) PRIMARY KEY, course_name VARCHAR(150), subject_type VARCHAR(50), lecturer_name VARCHAR(150));

CREATE TABLE RESULTS (student_id VARCHAR(10), course_id VARCHAR(10), score NUMBER, result_status VARCHAR(20), CONSTRAINT pk_results PRIMARY KEY (student_id, course_id), CONSTRAINT fk_results_student FOREIGN KEY (student_id) references STUDENTS(student_id), CONSTRAINT fk_results_courses FOREIGN KEY (course_id) references COURSES(course_id));

Tasks:

++Insert the data into the three relations STUDENTS, COURSES, and RESULTSaccording to the data given below:

Table 1: STUDENTS relation

Table 2: COURSES relation

Table 3: RESULTS relation