| 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/Lab02/ |
Upload File : |
<?
// JimMartinson/CST1602/Labs/Lab02/Lab02.phpinc
$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.
?>
<style type="text/css">b {white-space:nowrap;}</style>
<fieldset><legend>Description</legend>
The purpose of this lab is to setup the classicmodels database.
<? 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>
<ol>
<li>
Create a directory called <b class="copyText"><?=$evaluationName?></b>. We will use it for all work performed in this lab.
<ol type="a">
<li>Perform the following on MySQL Workbench.
<ol type="i">
<li>Add a new database called <?=strtolower($saveFilename)?>_workbench.</li>
<li>
Refresh the schema list<br>
Take a screenshot of the entire desktop showing the MySQL Workbench window and save it as <b><?=$saveFilename?>-WB-Database.png</b> in your <b><?=$evaluationName?></b> folder.<br>
<? showBegin('Show Example'); ?><br>
<img src="images/screenshot1.png" width="1000" height="507" alt="Show Example"/><br>
<? showEnd (); ?>
</li>
<li>
Create a table called table1 with a column name 'id', make it a primary key and auto_increment.<br>
Refresh the table list and expand tables, expand table1, expand columns.<br>
Take a screenshot of the entire desktop showing the MySQL Workbench window and save it as <b><?=$saveFilename?>-WB-Table.png</b> in your <b><?=$evaluationName?></b> folder.<br>
<? showBegin('Show Example'); ?><br>
<img src="images/screenshot2.png" width="1000" height="507" alt="Show Example"/><br>
<? showEnd (); ?>
</li>
</ol>
</li>
<li>Perform the following on MySQL CommandLine.
<ol type="i">
<li>Add a new database called <?=strtolower($saveFilename)?>_commandline.</li>
<li>
Show all the tables on the server.<br>
Take a screenshot of the entire desktop showing the MySQL Commandline window (screenshot must include the create and show commands) and save it as <b><?=$saveFilename?>-CL-Database.png</b> in your <b><?=$evaluationName?></b> folder.<br>
<? showBegin('Show Example'); ?><br>
<img src="images/screenshot3.png" width="1000" height="507" alt="Show Example"/><br>
<? showEnd (); ?>
</li>
<li>
Create a table called table1 with a column name 'id', make it a primary key and auto_increment.<br>
Refresh the table list and expand tables, expand table1, expand columns.<br>
Take a screenshot of the entire desktop showing the MySQL Commandline window (screenshot must include the create and show commands) and save it as <b><?=$saveFilename?>-CL-Table.png</b> in your <b><?=$evaluationName?></b> folder.<br>
<? showBegin('Show Example'); ?><br>
<img src="images/screenshot4.png" width="1000" height="507" alt="Show Example"/><br>
<? showEnd (); ?>
</li>
</ol>
</li>
</ol>
</li>
<li>Turn in your assignment:
<ol type="a">
<li>Ensure the following files are in your <b><?=$evaluationName?></b> folder:<br>
<ol id="ol_win_4">
<li><b><?=$saveFilename?>-WB-Database.png</b>.</li>
<li><b><?=$saveFilename?>-WB-Table.png</b></li>
<li><b><?=$saveFilename?>-CL-Database.png</b></li>
<li><b><?=$saveFilename?>-CL-Table.png</b></li>
</ol>
</li>
<li>Zip up your <b><?=$evaluationName?></b> folder into a file named <b><?=$uploadFilename?></b>.</li>
<li>Then attach this file to the assignment in D2L for grading.</li>
</li>
</ol>
</li>
</ol><? if ( $disabled ) { ?><span class="error bold">Notice: Do not perform this assignment unless this notice has been removed.</span><? } ?>
</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";
?>