Write SQL statements using MySQL to create tables with specified constraints. Task 01 - table 01 - course Refer to the file: courses.csv containing seven columns as specified CourseNo A unique number given to a course offered by a department Course Title Self explanatory L Number of lecture hours per week T Number of tutorial hours per week C Number of practical hours per week Type of Course Describes which set of students can register for this course Create a table named course having seven columns one corresponding to each explained above. The columns must satisfies the following constraints: CourseNo Should be the primary key Course Title Should not take null values L Should not take null values T Should not take null values P Should not take null values C Should not take null values Type of course should not take null values Task 02 - load data 01 Load the data from the file courses.csv into the created table course. Task 03 - table 02 - course offered to Refer to the file: courses-offered-to.csv containing three columns as specified CourseNo A unique number given to a course offered by a department Type of Course Describes which set of students can register for this course Offered to Which group of students the course is offered Create a table named course_offered to having three columns one corresponding to each explained above. The columns must satisfies the following constraints: CourseNo Should be the primary key Type of course should not take null values Offered to Should not be null (use varchar datatype to this field) E2 fic B . D E D E F G 1 CourseNo.#Course Title#L#T#P#C#Type of Course 2 BT202M#Molecular Biotechnology#3#O#O#6#Minor 3 BT206#Microbiology#3#O#O#6#Compulsory 4. BT207#Genetic Engineering#3#O#O#6#Compulsory 5 BT208#Transport Phenomenon in Bioprocesses#3#1#O#8#Compulsory 6 BT209#Bioreaction Engineering#3#O#O#6#Compulsory 7 BT211#Basic Biotechnology Lab#O#O#6#6#Compulsory 8 BT305#Computational Biology#2#O#2#6#Compulsory 9 BT306#Bioseparation Engineering#3#O#2#8#Compulsory 10 BT307#Biological Data Analysis#2#O#2#6#Compulsory E G A B D 1 Course No.#Type of Course#Offered to 2 BT202 M#Minor#B. Tech 4th semester 3 BT206#Compulsory#B. Tech 4th semester 4 BT207#Compulsory#B. Tech 4th semester 5 BT208#Compulsory#B. Tech 4th semester 6 BT209#Compulsory#B. Tech 4th semester 7 BT211#Compulsory#B. Tech 4th semester 8 BT305#Compulsory#B. Tech 6th semester 9 BT306#Compulsory#B. Tech 6th semester 10 BT307#Compulsory#B. Tech 6th semester