| 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/_MMDT2146/Labs/Lab04/ |
Upload File : |
<?
// JimMartinson/MMDT2146/Labs/Lab04.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.
include('application.phpinc');
include('Course/courseInfo.phpinc');
$assignmentNumber = 4;
$assignmentTitle = "Create class tables";
$assignmentPoints = 10;
$assignmentPointsDeductLate = 2;
$assignmentWeekDue = 1;
include('../../classInfo.phpinc');
$title = $assignmentType." ".$assignmentNumber.": ".$assignmentTitle;
$headTitle = '_CST_ - '.$courseNumber.' '.$courseTitle.' - '.$title;
$pageTitle = $courseNumber.' '.$courseTitle.'<br>'.$title;
$pageMenu = 'Course/courseMenu.phpinc';
$smallTitle = true;
include('common/pageHeader.phpinc');
$class['Lab']['StartDate'] = '2014-03-28';
$class['Lab']['EndDate'] = '2014-05-16';
if ( currentDate() < $class['Lab']['StartDate'] ) {
?>
<?=$title?> is not available at this time. <!-- It will become available on <?=$class['Lab']['StartDate']?>. -->
<?
include('common/pageFooter.phpinc');
} elseif ( currentDate() > $class['Lab']['EndDate'] ) {
?>
<?=$title?> is no longer available. <!-- If was due by <?=$class['Lab']['StartDate']?>. -->
<?
include('common/pageFooter.phpinc');
}
$sectionTitle = $courseNumber.' '.$courseTitle.' - '.$title;
include('common/sectionHeader.phpinc');
$f_uId = formValue('uId'); if ( $f_uId ) { $userId = $f_uId; $userFullName = str_replace(array("-"," "),"",username($userId)); } else { $userFullName = str_replace(array("-"," "),"",$_SESSION['userFullName']); $userId = $_SESSION['userId']; }
#printVar('$userFullName',$userFullName);
?>
<p>
<fieldset><legend><?=$assignmentType?> <?=$assignmentNumber?> assignment</legend>
Create tables and fields to store class data for a website.
<ol>
<li>Use MySQL Workbench to create a database named <b><?=strtolower($userFullName)?><?=$assignmentNumber?></b>.
<br><a href="MySQL_Workbench_CreateDatabase.wrf">See an example of how to use MySQL Workbench to create a database</a>. (40 sec)</li>
<li>Use MySQL Workbench and the following information to create the tables for the <b><?=strtolower($userFullName)?><?=$assignmentNumber?></b> database:
<pre>
building
buildingId
campusId
buildingCode (BLDG)
buildingName
campus
campusId
campusCode
campusName (Hutchinson, Willmar, East Campus)
class
classId
classQId (COU ID)
courseId
classSection (SECT)
classEnr (ENR) current enrollment
classMax (MAX)
classStart (COU START)
classEnd (COU END)
class_gradingmethod
classId
gradingmethodId (GRADE METH)
classmeeting
classmeetingId
classId
classmeetingStartDate (MTG START)
classmeetingEndDate (MTG END)
weekdayId (DAYS) Enter for each day/begin-end time/Instructor
classmeetingBeginTime (BEGIN)
classmeetingEndTime (END)
roomId (BLDG ROOM)
userId (INSTRUCTOR)
classnote
classnoteId
classId
classnoteText (NOTES)
course
courseId
departmentId (SUBJ)
courseNumber (NBR)
courseTitle (TITLE)
courseCredits (CRHR)
courseHours (CRHR)
courseinstrtypeId (INSTR TYPE)
courseMax (MAX) This is a suggestion. It can be determined by other factors like seats or equipment.
course_gradingmethod
courseId
gradingmethodId (GRADE METH) Suggested.
courseinstrtype The course instruction type (Lecture/Lab/etc...)
courseinstrtypeId
courseinstrtypeName (INSTR TYPE)
courseinstrtypeDescription
coursenote
coursenoteId
courseId
coursenoteText
department
departmentId
departmentCode (SUBJ)
departmentName
departmentNote
departmentInactive
gradingmethod
gradingmethodId
gradingmethodCode
gradingmethodDescription
gradingmethodNote
room
roomId
buildingId
roomNumber (ROOM)
user
userId Stub used to merge with MMDT2146 DB
weekday
weekdayId
weekdayNumber (0-6)
weekdayD (MTWHFSU)
weekdayDay (Mon, Tue, etc)
weekdayWeekday (Monday, Tuesday, etc
</pre>
You will have to determin the column types and sizes.
<br>
<a href="MySQL_Workbench_CreateTable.wrf">See an example of how to use MySQL Workbench to create a table</a>. (1 min 56 sec)
<br><a href="MMDT2146_Lab03_CreateTablesShortcut.wrf">See how I used MySQL Workbench and a text editor to create the tables for Lab 3</a>. (20 min 15 sec)
This is a much quicker method than using the GUI for everything.
Note that this example may use different tables from the Lab 3 we did in this class.
</li>
<li>Use MySQL Workbench to export the tables to the file: <b><?=$assignmentName?>.sql</b>.
<br><a href="MySQL_Workbench_ExportTables.wrf">See an example of how to use MySQL Workbench to export tables</a>. (2 min 33 sec)</li>
<li>Send an email to <a href="mailto:jim.martinson@ridgewater.edu?subject=<?=$courseNumber?> - <?=$assignmentName?> Submission">jim.martinson@ridgewater.edu</a> with a subject of <b class="nowrap"><?=$courseNumber?> - <?=$assignmentName?> Submission</b> and attach your <b><?=$assignmentName?>.sql</b> file.</li>
</ol>
</fieldset>
<?
if ( $assignmentPoints ) include('JimMartinson/GradingCriteria.phpinc');
include('../../ReferencesResources.phpinc');
include('common/sectionFooter.phpinc');
include('common/pageFooter.phpinc');
?>