| 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/_Archive/CST1600/ |
Upload File : |
<?
// CST1600/Lesson1-1.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.
$thisFile=__FILE__; $thisLine=__LINE__; include('application.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/courseInfo.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('classInfo.phpinc');
$assignmentNumber = "2-2";
$assignmentType = "Lesson";
$assignmentTitle = "Designing and Building Relationships and Lookup Fields";
//$evaluationNumber = "";
$evaluationType = "Lab";
//$evaluationTitle = "";
if (!isset($evaluationTitle) || $evaluationTitle == "") { $evaluationTitle = $assignmentTitle; }
if (!isset($evaluationNumber) || $evaluationNumber == "") { $evaluationNumber = $assignmentNumber; }
if (strlen($assignmentNumber) == 1) { $assignmentName = $assignmentType."0".$assignmentNumber; } else { $assignmentName = $assignmentType.$assignmentNumber; }
if (strlen($evaluationNumber) == 1) { $evaluationName = $evaluationType."0".$evaluationNumber; } else { $evaluationName = $evaluationType.$evaluationNumber; }
if ($evaluationTitle != '') $evaluationTitle = ': '.$evaluationTitle;
$title = $assignmentType." ".$assignmentNumber.": ".$assignmentTitle;
$levelChapter = split('-',$assignmentNumber);
$title = $assignmentType." ".$assignmentNumber.": ".$assignmentTitle;
$headTitle = '_CST_ - '.$courseNumber.' '.$courseTitle.' - '.$title;
$pageTitle = $courseNumber.' '.$courseTitle.'<br>'.$title;
$pageMenu = 'Course/courseMenu.phpinc';
$smallTitle = true;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageHeader.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('Login/authenticate.phpinc');
$sectionTitle = $courseNumber.' '.$courseTitle.' - '.$title;
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionHeader.phpinc');
?>
<p>
<fieldset><legend>Description</legend><span class="normal">
</span></fieldset>
<fieldset class="pio"><legend>Personalized Instruction</legend><span class="normal">
<ol start="1" class="pio">
<li>Create a folder called <b><?=$evaluationName?></b> in your CST1600 folder and keep all files modified or created for this <?=$assignmentType?> there.
<br />If the chapter calls for you to use a database from the student files (from the CD) then you should copy it into your <b><?=$evaluationName?></b> folder.
Then work on the copy.
</li>
<li>Read Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?> <i><?=$assignmentTitle?></i> in <?=$textbook['Title1']?><?=$textbook['Edition1Edition']?>.</li>
<li>Perform all <b>Projects</b> in Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?>. I will not need the print-outs, the database(s) will be used for evaluation.</li>
<li>You should review the <b>CHAPTER summary</b>. This lists the concepts you should have learned from Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?></li>
<li>You should review the <b>COMMANDS review</b>. This lists the commands you should have learned from Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?></li>
<li>You can perform or skip the <b>CONCEPTS check</b> questions in Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?> (I do not need them turned in).</li>
<li>Perform all SKILLS check (All Assessments) in Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?>.</li>
<li>Perform the CASE study at the end of Level <?=$levelChapter[0]?>, Chapter <?=$levelChapter[1]?>, but <span class="error">do not do the Microsoft Word document at the end</span>.
Your database work will be enough documentation.
</li>
</ol>
</span></fieldset>
<fieldset class="pio"><legend>Objectives</legend><span class="normal">
<ol class="obj pio" start="67">
<!-- Chapter 2-2 67 -->
<li>Design relationships between tables including one-to-many, one-to-one, and many-to-many relationships.</li>
<li>Edit relationship options, including specifying the join type.</li>
<li>Define a table with multiple-field primary key.</li>
<li>Create a lookup field to populate records with data from another table.</li>
<li>Modify a lookup field's properties.</li>
<li>Create a field that allows multiple values.</li>
<li>Create single-field and multiple-field indexes.</li>
<li>Define what is meant by normalization.</li>
<li>Determine if a table is in first, second, and third normal form.</li>
</ol>
</span></fieldset>
<fieldset><legend>Evaluations</legend><span class="normal">
Submit the Project, SKILLS check, CASE study, and other files for evaluation.
<ol type="1">
<li>Zip up the <b><?=$evaluationName?></b> folder into a file called <b><?=$evaluationName?>.zip</b>.</li>
<li>Send an email to <b><a href="mailto:jim.martinson@ridgewater.edu?subject=<?=$courseNumber?> <?=$evaluationName?> Submission">jim.martinson@ridgewater.edu</a></b> with a subject of <span style="white-space:nowrap;"><b><?=$courseNumber?> <?=$evaluationName?> Submission</b></span> and attach your <b><?=$evaluationName?>.zip</b> file.</li>
<li>If you are not using Ridgewater's email system then enter your name as the first line of the message.</li>
</ol>
</span></fieldset>
<fieldset><legend>Grading Criteria</legend><span class="normal">
Demonstrated assignment effectively: 45 points.
<br />
There are some things I expect. If they are incorrect you will receive the following deductions:
<br />
Incorrect attachment file name: -5 pts.
<br />
Work submitted incorrectly: -5 pts.
<br />
Incorrect subject in email: -5 pts.
<br />
Second and subsequent submission of work for grading: -5 pts.
<br />
Work submitted late: -5 pts.
<br />
I reserve the right <b>not</b> to apply the deduction points at my absolute discretion.
</span></fieldset>
<?
$thisFile=__FILE__; $thisLine=__LINE__; include('Course/ExampleFlles.phpinc');
$thisFile=__FILE__; $thisLine=__LINE__; include('ReferencesResources.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/sectionFooter.phpinc');
$thisFile = __FILE__; $thisLine=__LINE__; include('common/pageFooter.phpinc');
?>