| 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 6 - Function
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.
Your files were not contained in a Lab06 folder as required. They were in the root of your zip file.
-1 Work submitted incorrectly.
You misnamed your `Lab06` folder as `LAB06`.
-10 Your function does not work.
You are using reportsTo as if it is a variable.
Instead you need to use the employeeNumber variable to SELECT firstName, lastName, and reportsTo from the employees table.
Then check that result to return a value.
-10 Your function does not work.
reportsTo VARCHAR(40) is your parameter.
But this should be an INT as the value passed to the function is an employeeNumber.
You do not use this employeeNumber to determine who the employee reportsTo and get their full name.
Since boss (employee full name) is never set it is always NULL and your function always returns Self.
-10 Your function does not work.
You have configured it to only work with 5 employeeNumber values. It should work for any employeeNumber.
You also do not look up/calculate the supervisor's full name from the database. You are using constants.
-10 Your function does not work.
It never uses the value passed to lookup their boss and only returns `not self`.
-10 Your function does not work.
You cannot use IF..ELSEIF. What if the boss of an employee changes? It would now return an incorrect value.
You need to select for the boss (reportsTo) of the employeeNumber and return their name.
=e
-1 Your CST1602-StudentName-Lab06-b.png screenshot shows the query for eId 1056 again instead of eId 1002.
-1 This function should be DETERMINISTIC.
Given a particular eID value it always returns the same value.
-0 You return "Self" instead of "self" for employeeNumber 1002.