| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/Classes/CST1602/Labs/ |
Upload File : |
Lab 9 - Views
Grading Criteria
Demonstrated assignment effectively: 10 points.
There are some things I expect. If they are incorrect you will lose the following:
Work submitted incorrectly: -1 pt. This covers errors such as incorrect files names, incorrect file formats, poor formatting, etc.
Second and subsequent submission of work for grading: -1 pt.
Work submitted late: -1 pt per week.
I reserve the right not to apply the deduction points at my absolute discretion.
-1 Work submitted incorrectly.
You misnamed your `Lab06` folder as `lab06`.
-1 Work submitted incorrectly.
Your files were not contained in a Lab07 folder as required. They were in the root of your zip file.
supervisors_of:
USE classicmodels;
DROP VIEW IF EXISTS supervisors;
CREATE VIEW supervisors AS
SELECT s.employeeNumber AS SupNo
, trim(concat(s.firstName,' ',s.lastName)) AS Supervisor
, e.employeeNumber AS EmpNo
, trim(concat(e.firstName,' ',e.lastName)) AS Employee
FROM employees AS s
JOIN employees AS e ON e.reportsTo = s.employeeNumber
ORDER BY s.lastName, s.firstName
supervisors_of:
OK.
-1 You did not order by the supervisor last name then supervisor first name.
-5 The CREATE view caused errors.
reports_to:
OK.
USE classicmodels;
DROP VIEW IF EXISTS reports_to;
CREATE VIEW reports_to AS
SELECT e.employeeNumber AS EmpNo
, trim(concat(e.firstName,' ',e.lastName)) AS Employee
, s.employeeNumber AS SupNo
, trim(concat(s.firstName,' ',s.lastName)) AS Supervisor
FROM employees AS e
LEFT JOIN employees AS s ON e.reportsTo = s.employeeNumber
ORDER BY e.lastName, e.firstName
reports_to:
OK.
reports_to:
-2 Your query does not show that Diane Murphy has no supervisor (NULL,NULL).
Are you using the right type of JOIN?
You are the first student to use the boss function in your views. Interesting idea.
Good work, though your code could be better formatted.
Nicely done! Very concise code, nothing wasted.