MariaDB [(none)]> use toyu
Database changed
MariaDB [toyu]> SELECT * 
    -> FROM student;
+--------+-----------+----------+-------+-------+------+---------+
| stuId  | fname     | lname    | major | minor | ach  | advisor |
+--------+-----------+----------+-------+-------+------+---------+
| 100000 | Tony      | Hawk     | CSCI  | CINF  |   40 |    1011 |
| 100001 | Mary      | Hawk     | CSCI  | CINF  |   35 |    1011 |
| 100002 | David     | Hawk     | CSCI  | ITEC  |   66 |    1012 |
| 100003 | Catherine | Lim      | ITEC  | CINF  |   20 |    NULL |
| 100004 | Larry     | Johnson  | ITEC  | NULL  |   66 |    1017 |
| 100005 | Linda     | Johnson  | CINF  | ENGL  |   13 |    1015 |
| 100006 | Lillian   | Johnson  | CINF  | ITEC  |   18 |    1016 |
| 100007 | Ben       | Zico     | NULL  | NULL  |   16 |    NULL |
| 100008 | Bill      | Ching    | ARTS  | NULL  |   90 |    NULL |
| 100009 | Linda     | King     | ARTS  | CSCI  |  125 |    1018 |
| 100111 | Cathy     | Johanson | NULL  | NULL  |    0 |    1018 |
+--------+-----------+----------+-------+-------+------+---------+
11 rows in set (0.001 sec)

MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES
    ->     (100000,'Ben','Yue','CSCI','ITEC',55,1011);
ERROR 1062 (23000): Duplicate entry '100000' for key 'PRIMARY'
MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES
    ->     (200000,'Ben','Yue','CSCI','ITEC',55,1011);
Query OK, 1 row affected (0.008 sec)

MariaDB [toyu]> 
MariaDB [toyu]> SELECT * 
    -> FROM student;
+--------+-----------+----------+-------+-------+------+---------+
| stuId  | fname     | lname    | major | minor | ach  | advisor |
+--------+-----------+----------+-------+-------+------+---------+
| 100000 | Tony      | Hawk     | CSCI  | CINF  |   40 |    1011 |
| 100001 | Mary      | Hawk     | CSCI  | CINF  |   35 |    1011 |
| 100002 | David     | Hawk     | CSCI  | ITEC  |   66 |    1012 |
| 100003 | Catherine | Lim      | ITEC  | CINF  |   20 |    NULL |
| 100004 | Larry     | Johnson  | ITEC  | NULL  |   66 |    1017 |
| 100005 | Linda     | Johnson  | CINF  | ENGL  |   13 |    1015 |
| 100006 | Lillian   | Johnson  | CINF  | ITEC  |   18 |    1016 |
| 100007 | Ben       | Zico     | NULL  | NULL  |   16 |    NULL |
| 100008 | Bill      | Ching    | ARTS  | NULL  |   90 |    NULL |
| 100009 | Linda     | King     | ARTS  | CSCI  |  125 |    1018 |
| 100111 | Cathy     | Johanson | NULL  | NULL  |    0 |    1018 |
| 200000 | Ben       | Yue      | CSCI  | ITEC  |   55 |    1011 |
+--------+-----------+----------+-------+-------+------+---------+
12 rows in set (0.001 sec)

MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES
    ->     (200000,'Min','Yue','CINF','HIST',45,3011);
ERROR 1062 (23000): Duplicate entry '200000' for key 'PRIMARY'
MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES (200011,'Min','Yue','CINF','HIST',45,3011);  
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_minor_fk` FOREIGN KEY (`minor`) REFERENCES `department` (`deptCode`) ON DELETE CASCADE)
MariaDB [toyu]>    
MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES ('HIST','History','BHSH',2);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`department`, CONSTRAINT `Department_schoolCode_fk` FOREIGN KEY (`schoolCode`) REFERENCES `school` (`schoolCode`))
MariaDB [toyu]>    
MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES ('HIST','History','HSH',2);
Query OK, 1 row affected (0.005 sec)

MariaDB [toyu]> SELECT * FROM department;
+----------+------------------------------+------------+----------+
| deptCode | deptName                     | schoolCode | numStaff |
+----------+------------------------------+------------+----------+
| ACCT     | Accounting                   | BUS        |       10 |
| ARTS     | Arts                         | HSH        |        5 |
| CINF     | Computer Information Systems | CSE        |        5 |
| CSCI     | Computer Science             | CSE        |       12 |
| ENGL     | English                      | HSH        |       12 |
| HIST     | History                      | HSH        |        2 |
| ITEC     | Information Technology       | CSE        |        4 |
| MATH     | Mathematics                  | CSE        |        7 |
+----------+------------------------------+------------+----------+
8 rows in set (0.000 sec)

MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES (200011,'Min','Yue','CINF','HIST',45,3011);  
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_advisor_fk` FOREIGN KEY (`advisor`) REFERENCES `faculty` (`facId`))
MariaDB [toyu]> 
MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES (200011,'Min','Yue','CINF','HIST',45,1018);  
Query OK, 1 row affected (0.006 sec)

MariaDB [toyu]> SELECT DISTINCT * -- [1] output (* matches all columns
    -> FROM student -- [2] data sources
    -> WHERE major = 'CSCI'; -- [3] conditions
+--------+-------+-------+-------+-------+------+---------+
| stuId  | fname | lname | major | minor | ach  | advisor |
+--------+-------+-------+-------+-------+------+---------+
| 100000 | Tony  | Hawk  | CSCI  | CINF  |   40 |    1011 |
| 100001 | Mary  | Hawk  | CSCI  | CINF  |   35 |    1011 |
| 100002 | David | Hawk  | CSCI  | ITEC  |   66 |    1012 |
| 200000 | Ben   | Yue   | CSCI  | ITEC  |   55 |    1011 |
+--------+-------+-------+-------+-------+------+---------+
4 rows in set (0.004 sec)

MariaDB [toyu]> SELECT DISTINCT s.stuId,
    ->     CONCAT(s.fname,' ', s.lname) AS student,
    ->     d.deptName AS major
    ->     -- [1] output
    -> FROM student AS s,
    ->     department AS d
    ->     -- [2] data sources
    -> WHERE s.major = d.deptCode
    -> AND minor = 'ITEC' 
    -> AND advisor = 1016; -- [3] conditions
+--------+-----------------+------------------------------+
| stuId  | student         | major                        |
+--------+-----------------+------------------------------+
| 100006 | Lillian Johnson | Computer Information Systems |
+--------+-----------------+------------------------------+
1 row in set (0.005 sec)

MariaDB [toyu]> -- SELECT statement
MariaDB [toyu]> SELECT DISTINCT s.stuId, -- SELECT clause
    ->     CONCAT(s.fname,' ', s.lname) AS student,
    ->     d.deptName AS major
    ->     -- [1] output
    -> FROM student AS s INNER JOIN department AS d -- FROM clause
    ->         ON (s.major = d.deptCode)
    ->     -- [2] data sources
    -> WHERE minor = 'ITEC' -- WHERE clause 
    -> AND advisor = 1016; -- [3] conditions
+--------+-----------------+------------------------------+
| stuId  | student         | major                        |
+--------+-----------------+------------------------------+
| 100006 | Lillian Johnson | Computer Information Systems |
+--------+-----------------+------------------------------+
1 row in set (0.001 sec)

MariaDB [toyu]> njotee
    ->