STEP 1:
source students.sql
describe students;

STEP 2:
select * from students where first_Name="Ahmed";
update students set email="alabba200@cs.uregina.ca" where first_Name="Ahmed";

select * from students where first_Name="Yupeng";
update students set last_Name="Xu" where first_Name="Yupeng";
update students set middle_Name="" where first_Name="Yupeng";

select * from students where course_Name="CS215"; 
update students set course_Description="Web and Database Programming" where course_Name="CS215";

select * from students where first_Name="Ke";
delete from students where course_Name="CS000";

STEP 3:
create table Student_Info (
    -> student_ID varchar(30) not null,
    -> first_Name varchar(30) not null,
    -> middle_Name varchar(30),
    -> last_Name varchar(30) not null,
    -> email varchar(100) not null 
    -> );
    
create table Courses (
    -> course_Name varchar(30) not null,
    -> course_Description varchar(255) not null
    -> );

create table Marks (
    -> student_ID varchar(30) not null,
    -> course_Name varchar(30) not null,
    -> marks double not null
    -> );

STEP 4:
insert into Student_Info(student_ID, first_Name, middle_Name, last_Name, email) select distinct student_ID, first_Name, middle_Name, last_Name, email from students;

insert into Courses(course_Name, course_Description) select distinct course_Name, course_Description from students;

insert into Marks(student_ID, course_Name, marks) select distinct student_ID, course_Name, marks from students;