GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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/CST1600/Schedule/ |
Upload File : |
<? // MichaelMalz/CST1600/CST1600_Schedule_Spring.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'] == 1688 ) require('MichaelMalz/ScheduleCode.phpinc'); $week = 0; ?> <fieldset><legend><?=$title?></legend> <? require('MichaelMalz/WebMeetingLink.phpinc'); ?> <br> <ol start="1"> <!-- Week 1: Tuesday 1/09 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/R1CDnZp5_BQ63sAiqoddIXXlPlAyH2wTL9FsIlJ21ziO1eCTfpXTlTrExlGkqlXQ.IxfEgsdLhH829U2C?startTime=1736885034000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4:30pm --> <?=classWeekDayCSS($class['startDate'][0],$week)?>, <?=$class['meetingTime'][0]?>.<?=classWeekDayLocation($class['startDate'][0],$week)?> <ol type="i"> <? $discuss_VMware = false; require('MichaelMalz/Schedule_week1.phpinc'); ?> </ol> </li> <li> <? $weekAdd = 1; require('MichaelMalz/Schedule_week1_Assignments_Begin.phpinc'); ?> <li>Complete the CST General Quiz in D2L.</li> <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('MichaelMalz/Schedule_week1_Assignments_End.phpinc'); ?> </li> </ul> </li><!-- END Week 1 --> <!-- Week 2: Tuesday 1/16 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/3vlU_J-2UfdzACsoW57WSjFoWBXJ31Pq1z46Qc-sH9JMSPEyNhF5WE3G2qyxzrh0.gOOdz4Af9IJRABTa?startTime=1737489811000','text'),array('https://minnstate.zoom.us/rec/share/3vlU_J-2UfdzACsoW57WSjFoWBXJ31Pq1z46Qc-sH9JMSPEyNhF5WE3G2qyxzrh0.gOOdz4Af9IJRABTa?startTime=1737493281000','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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> <li>Complete Week 1 Reading Quiz in D2L.</li> </ol> </li> </ul> </li><!-- END Week 2 --> <!-- Week 3: Tuesday 1/23 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <span class="attention nowrap">No live lecture this week.</span> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/llyG88a9k0d6E5SK62hbsFp2XlT_eQZJIFbFhv4mtCsBiwju0DhA2lshZjCcRdiE.u-5r9Kyo9Br2GFyd?startTime=1737988692000','text'),array('https://minnstate.zoom.us/rec/share/d7jsXVk8Fs7bRVpXK7vsXJ5lFNBHIbvwenJbBcuoPawQVJkA1p4oIfAlXr7D_QdN.jDnvYgxcF9B69Iqe?startTime=1737998514000','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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>Complete quiz in D2L</li> <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 1/30 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/Rly0orsjKb2E142pJaneLlgzu24a3XJ9EtbKp1GiOVYRgzj-H9K0VNLzT0QrsHth.cAhFeqNwJ7NIGgmu?startTime=1738699298000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/06 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/nRVrJDtxmY3x3KvriPzzfOkLoZvq0N7b007bEeFfDAYLxSKnrCrcFY45v0e36vsA.KDYzPjjxgd6EOXsk?startTime=1739304245000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/13 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/UuTBUgu1sxIk3QOTaEHLtXqow9tJV_EXi2gp1yEpNXNotXjSOI1pMfy4Jz_HBAM8.RxpBNagy8EpLXj7d?startTime=1739909074000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/20 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/16oUk148evEYJSuaKkQ7BkugMpL5KtuKCiKsgPsRyISTXXbrqm2MNirBJ9wvvwPE.UPBOg6O8_mWGt-BW?startTime=1740514560000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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="/MichaelMalz/CST1600/Resources/SQL-Join-925x1024.png">SQL JOINS</a> and <a href="/MichaelMalz/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 2/27 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/cfq_eDYOCrH_GEAtkJ3HJILH5s83tn-hoM5E7iZIsrXEpknF9waUnfsrfcImnqdp.AB4SN7xLkVF3ygf3?startTime=1741118763000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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="/MichaelMalz/CST1600/Resources/SQL-Join-925x1024.png">SQL JOINS</a> and <a href="/MichaelMalz/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 --> <? #$LOCK_BELOW = $week; ?> <!-- Week 9: Tuesday 3/05 (Spring Break) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?> <span class="attention nowrap">No class meetings this week - Spring Break</span> </li><!-- END Week 9 --> <!-- Week 10: Tuesday 3/12 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/0PVFpymQSLA9rDsEo8CuLESqqSX_-RubOiDhmsOtsy21QQtN8X9LjIsR5Rwl2AUy.J891nclQbXhMHd5v?startTime=1742324863000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/19 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/aqdoyPtagksheR4PlaANXq3K36TYwNNfUf6RV0TGaPNS2_2ot-GR-XnALa-aZRrR.V3r6SL_1wFcBP5eb?startTime=1742929418000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/MichaelMalz/CST1600/Resources/MotherCelkosHeuristics.php">Mother Celko's Heuristics</a>.</li> <li>View <a href="https://cst.ridgewater.edu/MichaelMalz/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/26 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/UIjYJEgODR6GdyvNt6CkYEgEkgEf82xYV3iMjCsF4fJtlh1oQw0Xa-NkKzNrfXkk.SxX_1yR17oKPIl-M?startTime=1743534177000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/MichaelMalz/CST1600/Resources/MotherCelkosHeuristics.php">Mother Celko's Heuristics</a>.</li> <li>Discuss <a href="https://cst.ridgewater.edu/MichaelMalz/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/MichaelMalz/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> <li><?=labLink(7)?></li> </ol> </li> </ul> </li><!-- END Week 12 --> <!-- Week 13: Tuesday 4/02 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/mnQXUIkaoaVCm6lbOxZNrTja9rWuIEZKmG5MAu3Sco4F-Xj4pOyzGceLlgn0Ujln.-cD3Ji-9swvvUHGX?startTime=1744139144000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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/MichaelMalz/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+1)?>: <ol type="i"> <li><?=labLink(8)?></li> </ol> </li> </ul> </li><!-- END Week 13 --> <!-- Week 14: Tuesday 4/09 (Off campus) --> <li><? $week++; ?> <?=classWeekDateCSS($class['startDate'],$week)?><?=classWeekShowHideUL($class['startDate'],$week)?> <? lectureLinks(array(array('https://minnstate.zoom.us/rec/share/2pgO46Ujlry9qMKadGmOPCyFFaMRmQGpCRZzhatfTVdWe3sOSNG4oWvZqzyBX-l3.H7UI0wgkJ5ic1o6w?startTime=1744743769000','text'),array('URL','text'),array('URL','text'))); ?> <ul<?=classWeekShowHideClass($class['startDate'],$week)?>> <li><!-- Tuesday 2:00pm-4: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+1)?>: <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 14<sup>th</sup> 2025.</li> </ul> </li><!-- END Week 14 --> <!-- Week 15: Tuesday 4/16 (Off campus) --> <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><!-- Tuesday 2:00pm-4: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 14<sup>th</sup> 2025.</li> </ul> </li><!-- END Week 15 --> <!-- Week 16: Tuesday 4/23 (Off campus) --> <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><!-- Tuesday 2:00pm-4: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 14<sup>th</sup> 2025.</li> </ul> </li><!-- END Week 16 --> <!-- Week 18: Tuesday 5/07 (Off campus) --> <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><!-- Tuesday 2:00pm-4: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 14<sup>th</sup> 2025.</li> </ul> </li><!-- END Week 18 --> <? /** / ?> <? /**/ ?> <? $LOCK_BELOW = $week; ?> </ol> </fieldset> <? /** / ?> <? /**/ ?> <? ?>