This question uses SQL

CREATE TABLE `Student`( `s_id` VARCHAR(20), `s_name` VARCHAR(20) NOT NULL DEFAULT '', `s_birth` VARCHAR(20) NOT NULL DEFAULT '', `s_sex` VARCHAR(10) NOT NULL DEFAULT '', PRIMARY KEY(`s_id`) );

insert into Student values('01' , ' Cobb' , '1990-01-01' , ' Male'); insert into Student values('02' , ' Arthur', '1990-12-21' , ' Male'); insert into Student values('03' , 'Ariadne' , '1990-05-20' , 'Female'); insert into Student values('04' , 'Eames' , '1990-08-06' , 'Male'); insert into Student values('05' , 'Mal' , '1991-12-01' , 'Female'); insert into Student values('06' , 'Blonde' , '1992-03-01' , 'Female'); insert into Student values('07' , 'Saito' , '1989-07-01' , 'Male'); insert into Student values('08' , 'Miranda' , '1990-01-20' , 'Female');

CREATE TABLE `Course`( `c_id` VARCHAR(20), `c_name` VARCHAR(20) NOT NULL DEFAULT '', `t_id` VARCHAR(20) NOT NULL, PRIMARY KEY(`c_id`) ); insert into Course values('01' , 'Math' , '02'); insert into Course values('02', 'French', '01'); insert into Course values('03' , 'Art', '03');

CREATE TABLE `Teacher`( `t_id` VARCHAR(20), `t_name` VARCHAR(20) NOT NULL DEFAULT '', PRIMARY KEY(`t_id`) ); insert into Teacher values('01', 'Frank'); insert into Teacher values('02', 'Einstein'); insert into Teacher values('03', 'Newton');

CREATE TABLE `Score`( `s_id` VARCHAR(20), `c_id` VARCHAR(20), `s_score` INT(3), PRIMARY KEY(`s_id`,`c_id`) ); insert into Score values('01' , '01' , 80); insert into Score values('01' , '02' , 90); insert into Score values('01' , '03' , 99); insert into Score values('02' , '01' , 70); insert into Score values('02' , '02' , 60); insert into Score values('02' , '03' , 80); insert into Score values('03' , '01' , 80); insert into Score values('03' , '02' , 80); insert into Score values('03' , '03' , 80); insert into Score values('04' , '01' , 50); insert into Score values('04' , '02' , 30); insert into Score values('04' , '03' , 20); insert into Score values('05' , '01' , 76); insert into Score values('05' , '02' , 87); insert into Score values('06' , '01' , 31); insert into Score values('06' , '03' , 34); insert into Score values('07' , '02' , 89); insert into Score values('07' , '03' , 98);

Show command to produce below table

List all the students names, their scores and the course ids (show the student name even the student did not take any exam, Hint: LEFT OUTER JOIN) Your result table should look like this: StuName StuScore CourselD Cobb Cobb Arthur Arthur Arthur Ariadne Ariadne Ariadne Eames Eames Eames Mal Mal Blonde Blonde Saito Saito Miranda 80 01 90 02 99 03 70 01 60 02 80 03 80 01 80 02 80 03 50 01 30 02 20 03 76 01 87 02 31 01 34 03 89 02 98 03 NULL NULL (explanation: Miranda did not take any exam)