| 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/MichaelMalz/CST1602/Labs/Lab10/ |
Upload File : |
<?
// JimMartinson/CST1602/Labs/Lab07/index.php
$TRACK = "<b>".basename(__FILE__).'</b> <span class="pv_fl">('.__FILE__.")</span>\n<ol>\n";
ini_set('include_path',ini_get('include_path').PATH_SEPARATOR.$_SERVER['DOCUMENT_ROOT']."/"); // Add the DOCUMENT_ROOT to the include_path.
require('application.phpinc');
require('Gradebook/EvaluationSubmission_BEGIN.phpinc'); // Replaced.
$disabled = '';
$disabled = ' disabled'; // Comment this line to enable lab.
?>
<fieldset><legend>Description</legend>
The purpose of this lab is to demonstrate your ability to create a view.
<?=$gradeNote?>
<? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><? } ?>
</fieldset>
<fieldset><legend><?=$evaluationType?> <?=$evaluationNumber?> Assignment</legend>
Create a folder for this <?=strtolower($evaluationType)?> named <b class="copyText"><?=$evaluationName?></b> and keep all documents used for <?=$evaluationType?> <?=$evaluationNumber?> in that folder.
<ol class="count">
<li>
Write a script that does the following:
<ol>
<li>Uses the <b>classicmodels</b> database.</li>
<li>Create a view named <b>supervisors_of</b> that displays supervisors and the employees that report to them.
<ol>
<li>Show the supervisor <b>employeeNumber</b> as <b class="copyText">SupNo</b>.</li>
<li>Show the supervisor <b>firstName</b> and <b>lastName</b> as one column named <b class="copyText">Supervisor</b>.</li>
<li>Show the supervised employee <b>employeeNumber</b> as <b class="copyText">EmpNo</b>.</li>
<li>Show the supervised employee <b>firstName</b> and <b>lastName</b> as one column named <b class="copyText">Employee</b>.</li>
<li>Order it by the supervisor last name then supervisor first name.</li>
<li>If an employee is not a supervisor they should not be listed under <b>SupNo</b> or <b>Supervisor</b>.</li>
</ol>
</li>
<li>Save the script as <b class="copyText">supervisors_of.sql</b> in your <b><?=$evaluationName?></b> folder.</li>
<li>Run the <b>supervisors_of.sql</b> to create the view.</li>
</ol>
</li>
<li>Show that the <b>supervisor</b> view works.
<ol>
<li>Run the sql <code class="copyText">SELECT * from supervisors_of;</code>.</li>
<li>Expand the Result Grid as much as you can.</li>
<li>
Take a screenshot and save it as <b class="copyText"><?=$saveFilename?>_Super.png</b> in your <b><?=$evaluationName?></b> folder.
<? showBegin('See example screenshot','Hide example screenshot'); ?><br><img src="CST1602-JimMartinson-Lab07-a.png" width="1000" alt="Example screenshot"/><br><? showEnd(); ?>
</li>
</ol>
</li>
<li>
Write a script that does the following:
<ol>
<li>Uses the <b>classicmodels</b> database.</li>
<li>Create a view named <b class="copyText">reports_to</b> that displays employees and their supervisors. <span class="note">This view should also show employees that do not report to anyone.</span>
<ol>
<li>Show the supervised employee <b>employeeNumber</b> as <b class="copyText">EmpNo</b>.</li>
<li>Show the supervised employee <b>firstName</b> and <b>lastName</b> as one column named <b class="copyText">Employee</b>.</li>
<li>Show the supervisor <b>employeeNumber</b> as <b class="copyText">SupNo</b>.</li>
<li>Show the supervisor <b>firstName</b> and <b>lastName</b> as one column named <b class="copyText">Supervisor</b>.</li>
<li>Order it by the employee last name then <del>supervisor</del> employee first name.</li>
</ol>
</li>
<li>Save the script as <b class="copyText">reports_to.sql</b> in your <b><?=$evaluationName?></b> folder.</li>
<li>Run the <b>reports_to.sql</b> to create the view.</li>
</ol>
</li>
<li>Show that the <b>reports_to</b> view works.
<ol>
<li>Run the sql <code class="copyText">SELECT * from reports_to;</code>.</li>
<li>Expand the Result Grid as much as you can.</li>
<li>
Take a screenshot and save it as <b class="copyText"><?=$saveFilename?>_Report.png</b> in your <b><?=$evaluationName?></b> folder.
<? showBegin('See example screenshot','Hide example screenshot'); ?><br><img src="CST1602-JimMartinson-Lab07-b.png" width="1000" alt="Example screenshot"/><br><? showEnd(); ?>
</li>
</ol>
</li>
<li>Turn in your assignment:
<ol type="a">
<li>Make sure the following files are in your <b><?=$evaluationName?></b> folder:
<?
$fileList = array(
$saveFilename.'_Super.png',
$saveFilename.'_Report.png',
'supervisors_of.sql',
'reports_to.sql',
);
natcasesort($fileList);
foreach ($fileList as $fileName) {
?>
<br><?=$fileName?>
<?
}
?>
</li>
<li>Zip up your <b><?=$evaluationName?></b> folder into a file named <b class="copyText"><?=$uploadFilename?></b>.</li>
<li>Browse and select your <b><?=$uploadFilename?></b> file: <input type="file" name="fileUpload"<?=$disabled?>></li>
<li>Then <input type="submit" name="f_subtask" value="Submit"<?=$disabled?>> for grading.li>
</ol>
</li>
</ol><? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><br><? } ?>
</fieldset>
<?
require('Gradebook/EvaluationSubmission_END.phpinc'); // Replaced.
#require('../../ReferencesResources.phpinc');
#require('JimMartinson/ContactInformation.phpinc');
require('common/pageFooter.phpinc');
if ($TRACK != '') $_SESSION['TRACK'] .= "<li>End ".basename(__FILE__)."</ol>\n";
?>