The Database Model

The databse and all the tables are created.

First, you could use SHOW tables; to check the existing tables, and then SELECT * FROM ... to see the data records.

The database shows college enrollments for a single semester. The gender field in the Students table contains “M” for males and “F” for females, and the grade field in the Enrolls table contains a numerical grade, such as 4.0 for an “A”, 3.0 for a “B”, etc. Departments in the Courses table are identified by their names, which are unique.

This platform will not save any information, once refresh, everything clears. Please copy your code into the answer book

Questions:

Q1.

Q2.

Q3.

Input your SQL code here:

Result of your query: