Having the following table structure (see image). Write MYSQL for: (4) Which students (student first name, student last name) have taken the course “Database Systems”? (5) List all students (student first name, student last name) who have taken both “Database Systems” and “C++”. (6) List all students (student ID, student first Name, student last Name) and the courses (course name, course grade) that they have taken. If there are students who have not taken any course yet, the query result should reflect that (i.e. null for courseName, null for grade). (7) Find all students who have taken computer science courses (i.e. course codes CS***). For the result, list student first name, student last name, and the computer science course names that they have taken.
Having the following table structure (see image). Write MYSQL for:
(4) Which students (student first name, student last name) have taken the course “
Systems”?
(5) List all students (student first name, student last name) who have taken both “Database
Systems” and “C++”.
(6) List all students (student ID, student first Name, student last Name) and the courses (course
name, course grade) that they have taken. If there are students who have not taken any
course yet, the query result should reflect that (i.e. null for courseName, null for grade).
(7) Find all students who have taken computer science courses (i.e. course codes CS***). For the
result, list student first name, student last name, and the computer science course names
that they have taken.
![CREATE TABLE STUDENTS (
StudentId CHAR(11),
FirstName VARCHAR(20) NOT NULL,
LastName VARCHAR(20) NOT NULL,
Gender CHAR(1) NOT NULL,
DateOfBirth DATE NOT NULL,
PRIMARY KEY (StudentId)
);
CREATE TABLE COURSES (
CourseCode VARCHAR(6),
CourseName VARCHAR(70) NOT NULL,
Level CHAR(2),
Credits INT NOT NULL,
PRIMARY KEY (CourseCode)
);
CREATE TABLE Registration (
StudentId CHAR(11),
CourseCode VARCHAR(6),
Grade DECIMAL (2, 1) NOT NULL,
PRIMARY KEY (StudentId, CourseCode),
FOREIGN KEY (StudentId) REFERENCES STUDENTS (StudentId) ON UPDATE CASCADE,
FOREIGN KEY (CourseCode) REFERENCES COURSES (CourseCode) ON UPDATE CASCADE
);](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F416064f9-c57b-46ee-9b50-14b257515654%2F15d97a41-f61e-4eca-9bbe-9b6909ad7b53%2F4enckza_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)