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 :  /Users/Administrator/AppData/Local/Google/Chrome/User Data/Default/Cache/Cache_Data/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /Users/Administrator/AppData/Local/Google/Chrome/User Data/Default/Cache/Cache_Data/f_000203
<!DOCTYPE html>

<html lang="en">

<head>
  <title>Computer Systems Technology - CST1600 Relational Databases - Schedule - Michael Malz - 2025 Fall Semester (20263)</title>
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  <link href="/css/CST.css" rel="stylesheet" type="text/css">
  <link href="/css/debug.css" rel="stylesheet" type="text/css">
  <link href="/css/tooltip.css" rel="stylesheet" type="text/css">
  <link href="/css/schedule.css" rel="stylesheet" type="text/css">
  <link href="/css/colorCode.css" rel="stylesheet" type="text/css">
  <link href="/css/html5test.css" rel="stylesheet" type="text/css">
  <script src="/js/CST.js"></script>
  <script src="/js/div.js"></script>
  <script src="/js/CollapsibleLists.js"></script>
  <script src="/js/debug.js"></script>
  <script src="/js/tooltip.js"></script>
  <script src="/js/schedule.js"></script>
</head>

<body>

<!-- Begin section 1 -->
<br>
<table id="tbl_1" class="sectionTable nopad center"  style="width:1000px;" >
  <tr>
    <td class="blackBorderLeft"></td>
    <td id="td_1" class="sectionTd blackHeading" style="width:978px;">
			<div style="position:relative;">
			<div style="padding-top:3px;">Computer Systems Technology - Ridgewater College</div><div style="position:absolute; right:0; top:0; text-align:right; width:100%;"><div style="padding-top:2px;"><a href="/admin/">admin</a>  <a href="?Logout">Logout</a></div></div>			</div>
		</td>
    <td class="urcA"><div class="urcA"></div></td>
    <td class="urcB"><div class="urcB"></div></td>
  </tr>
  <tr>
    <td class="whiteBorder"></td>
    <td id="td2_1" class="contentTd white" colspan="2" style="width:996px;">
		<table class="nopad">
			<tr>
				<td class="pageImage" rowspan="2"><a href="/"><img src="/images/CSTlogoBlue115.gif" alt="Blue CST logo"></a></td>
				<td class="pageTitle" colspan="3">2025 Fall Semester (20263)<br>CST1600 Relational Databases<br>Schedule</td>
				<td class="pageImage" rowspan="2"><a href="/"><img src="/images/CSTlogoGreen115.gif" alt="Green CST logo"></a></td>
			</tr>
			<tr style="height:25px;">
				<td style="width:70px;"></td>
				<td class="center" style="width:688px;">
					<a href="/">Home</a> | <a href="?Logout">Logout</a><br>
	<table class="center">
	<tr>
		<td>
			<a href="/MichaelMalz/CST1600/" title="CST1600 class homepage.">CST1600 Home</a>			 | <a href="/MichaelMalz/CST1600/?Assignments">Assignments</a>			 | <a href="/MichaelMalz/CST1600/Resources/" title="CST1600 Resources.">Resources</a>		 | <span class="menuCurrent" title="CST1600 Schedule.">Schedule</span>		 | <a href="/MichaelMalz/CST1600/Syllabus.php" title="CST1600 Syllabus.">Syllabus</a>		</td>
	</tr>
	</table>
	<table class="center"><tr><td>
			<a href="/MichaelMalz/CST1600/?ClassRoster" title="CST1600 Class Roster.">Class Roster</a>
			 | <a href="/MichaelMalz/CST1600/?Gradebook" title="CST1600 Gradebook.">Gradebook</a>
	
	</td></tr></table>

</td>
				<td class="right" style="width:70px;"></td>
			</tr>
		</table>
    </td>
    <td class="blackBorderRight"></td>
  </tr>
</table>
<!-- End section 1 -->

<!-- Begin section 2 -->
<br>
<table id="tbl_2" class="sectionTable nopad center"  style="width:1000px;" >
  <tr>
    <td class="blackBorderLeft"></td>
    <td id="td_2" class="sectionTd blackHeading" style="width:978px;">
			<div style="position:relative;">
			<div style="padding-top:3px; margin:0 250px; white-space:nowrap;">Schedule</div><div style="position:absolute; left:2px; top:0px;">
	<form name="form_SelectSession" class="inline" action="/MichaelMalz/CST1600/Schedule/" method="post">
		<input type="hidden" name="f_form" value="form_SelectSession">
		<input type="hidden" name="f_uuid" value="06cb78dcd5153bb6a851d5393e26f88b">
		<input type="hidden" name="f_task" value="Change session">
		<select name="f_sessionId" id="f_sessionId" onchange="this.form.submit();">
	
			<option value="308" selected>2025 Fall Semester (20263) (current)</option>
			<option value="307">2025 Spring Semester (20255)</option>
			<option value="306">2024 Fall Semester (20253)</option>
			<option value="305">2024 Spring Semester (20245)</option>
			<option value="304">2023 Fall Semester (20243)</option>
		</select>
	</form>
</div>			</div>
		</td>
    <td class="urcA"><div class="urcA"></div></td>
    <td class="urcB"><div class="urcB"></div></td>
  </tr>
  <tr>
    <td class="whiteBorder"></td>
    <td id="td2_2" class="contentTd white" colspan="2" style="width:996px;">
<fieldset><legend>Schedule</legend>
<a href="https://minnstate.zoom.us/my/mike.malz/" target="_blank">Join Michael's Zoom web meeting</a>. ( https://minnstate.zoom.us/my/mike.malz/ )<br>
<ol start="1">
<!-- Week 1: Tuesday 1/11 (Hutchinson) -->
<li> <span class="classDate">Monday, August 25th, 2025</span> <input type="button" id="weekControl_1" class="small" onclick="weekHide(this);" value="Hide week 1">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/OTMgIi28q8qSaheiKDMtbDhlp7QSntjCA-igEduIQKP8pz9SDL5b_XsWTshkRKn4.Rryt25H59f7aCsWQ?startTime=1724958074000" target="_blank">View lecture</a>.	<ul id="week_1" class="normal">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<ol type="i">
			<ol type="i">
	<li>Introductions.</li>
	<li>Discuss the <a href="https://cst.ridgewater.edu/">cst.ridgewater.edu</a> home page.</li>
	<li>Discuss the <a href="/MichaelMalz/CST1600/Syllabus.php" title="CST1600 Syllabus.">Syllabus</a>.</li>
	<!--<li>Discuss the .</li>-->
	<li><span>Discuss how the class works:</span>
		<ul class="collapsed" id="0">
			<li><span>Zoom</span>
				<ul class="collapsed" id="1">
					<li>What is Zoom?</li>
					<li>Some Zoom links:
						<ul>
							<li>Minnesota State Zoom site and Sign in: <a href="https://minnstate.zoom.us/">https://minnstate.zoom.us/</a>.</li>
							<li>Main Zoom site: <a href="https://zoom.us/">https://zoom.us/</a>.</li>
							<li>CST Zoom resources: <a href="https://cst.ridgewater.edu/Zoom/">https://cst.ridgewater.edu/Zoom/</a>.</li>
							<li>Connecting to the class web meeting: <a href="https://minnstate.zoom.us/my/mike.malz/">https://minnstate.zoom.us/my/mike.malz/</a>.</li>
						</ul>
					<li>The headset.</li>
					<li>Recording links.</li>
				</ul>
			</li>
			<li><span>Attendance</span>
				<ul class="collapsed" id="2">
					<li>Do I need to attend?</li>
					<li>In the classroom. (There are none)</li>
					<li>Via the web meeting.</li>
					<li>Recordings.</li>
				</ul>
			</li>
			<li><span>Assignments and Lessons</span>
				<ul class="collapsed" id="3">
					<li><span>What is an assignment?</span>
						<ul id="4">
							<li>Assignments can be work to be performed (labs) or tests. They are graded and become part of you overall class grade.</li>
							<li>When are assignments due?</li>
							<li>How are assignments turned in?</li>
							<li>What if my assignment is late?</li>
							<li>Discuss the <a href="/MichaelMalz/CST1600/?Assignments">Assignments</a>.</li>
						</ul>
					</li>
					<li><span>What is a lesson?</span>
						<ul class="collapsed" id="5">
							<li>Lessons are usually reading assignments or activiteies to perform. They are not graded.</li>
							<li>Read: I expect you to read the primary document or the section of the document assigned.</li>
							<li>Browse: I expect you to browse the document to become familiar with it. This includes following page links and generally taking a look around. Feel free to read as in-depth as you want.</li>
						</ul>
					</li>
					<li>How am I going to perform my assignmens and lessons?</li>
				</ul>
			</li>
		</ul>
	</li>
	<li><span>Discuss how to get help:</span>
		<ul class="collapsed" id="6">
			<li>Ask a question during the web meeting.</li>
			<li>Ask a fellow student.</li>
			<li>Internet search. Good sites to view are <a href="https://www.stackoverflow.com/">stack<b>overflow</b></a> and  <a href="https://www.w3schools.com/">w3schools<span style="color:rgb(76, 175, 80);">.com</span></a>.</li>
			<li>Fresh eyes.</li>
			<li>Call me <a href="#ContactInformation">(See the contact info below)</a>.</li>
			<li>Email me <a href="#ContactInformation">(See the contact info below)</a>.</li>
			<li><a href="https://www.ridgewater.edu/student-services-activities/technology-services/">Student Technology Services</a>.</li>
		</ul>
	</li>
	<li>Discuss <a href="https://cst.ridgewater.edu/MichaelMalz/CST1600/Resources">Resources</a>.</li>
	<!--<li>Discuss the upgrade and cutover to a new cst.ridgewater.edu site.</li>-->
	 
	<li>Discuss class tasks.</li>
</ol>
			</ol>
		</li>
		<li>
					Complete the following before 	2:00pm on Tuesday, August 26th, 2025:
			<ol type="i">
				<li><span>Ensure you can login to <a href="https://cst.ridgewater.edu">cst.ridgewater.edu</a> using your StarID and password:</span>
					<ol class="collapsed" id="10" type="a">
						<li>Open the <a href="http://cst.ridgewater.edu/MichaelMalz/CST1600/Schedule/">class schedule</a> at <a href="http://cst.ridgewater.edu/MichaelMalz/CST1600/Schedule/">http://cst.ridgewater.edu/MichaelMalz/CST1600/Schedule/</a>.
							<br>This will bring up the login.
						</li>
						<li>Login using your StarID and Password.
							<br>If you have not logged into the CST site before it will bring up a page to enter your 8 digit Tech ID (Student ID).
							<img src="../../StudentID.png" width="534" height="302" alt="Srudent ID submit">
						</li>
					</ol>
					<div style="clear: both;">If the login does not work then let me know via phone call or email.
						<br><b>If you do not login or notify me that it did not work you will be recorded as not attending class this week.</b></div>
				</li>
							</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, September 1st, 2025:
			<ol type="i">
				<li>Complete and Submit your <a href="../?StudentProfile">Student Profile</a>.</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>
					</ol>
		</li>
	</ul>
</li><!-- END Week 1 -->
<!-- Week 2: Tuesday 1/18 (Willmar) -->
<li> <span class="classDate">Monday, September 1st, 2025</span> <input type="button" id="weekControl_2" class="small" onclick="weekShow(this);" value="Show week 2">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/2zn7NCjO9HG9X8l-APCag1QqR3z14x2vkW0B6QmJdWm7Eaq_M-peIDEKj2obyEZ4.jJQ6jMVATYTBazUt?startTime=1725562954000" target="_blank">View lecture part 1</a>. <a href="https://minnstate.zoom.us/rec/share/2zn7NCjO9HG9X8l-APCag1QqR3z14x2vkW0B6QmJdWm7Eaq_M-peIDEKj2obyEZ4.jJQ6jMVATYTBazUt?startTime=1725567075000" target="_blank">View lecture part 2</a>.	<ul id="week_2" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 before 	2:00pm on Monday, September 8th, 2025:
			<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 4: Tuesday 2/01 (Willmar) -->
<li> <span class="classDate">Monday, September 8th, 2025</span> <input type="button" id="weekControl_3" class="small" onclick="weekShow(this);" value="Show week 3">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/faiJzf2zVdwEMQZ_9DJXE9dIhdd4XqYkrImO0gAUqccoXieZ8iEAnXdWXaSUvNaZ.ilVtLWqZ_mJLrgdk?startTime=1726167629000" target="_blank">View lecture part 1</a>. <a href="https://minnstate.zoom.us/rec/share/faiJzf2zVdwEMQZ_9DJXE9dIhdd4XqYkrImO0gAUqccoXieZ8iEAnXdWXaSUvNaZ.ilVtLWqZ_mJLrgdk?startTime=1726171271000" target="_blank">View lecture part 2</a>.	<ul id="week_3" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 <a href="/MichaelMalz/CST1600/Labs/Lab01">Lab 1 - Install MySQL server and tools</a>.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, September 15th, 2025:
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab01">Lab 1 - Install MySQL server and tools</a>.</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 4 -->
<!-- Week 5: Tuesday 2/08 (Hutchinson) -->
<li> <span class="classDate">Monday, September 15th, 2025</span> <input type="button" id="weekControl_4" class="small" onclick="weekShow(this);" value="Show week 4">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/0ojydSvzs0UEJWXq764U1kJGu9lAtrFeAYdB-0EEPfVs7nGqo8TuQ5NFz3kMfgZk.5dRSxWxBepp6WGEb?startTime=1726772508000" target="_blank">View lecture part 1</a>. <a href="https://minnstate.zoom.us/rec/share/0ojydSvzs0UEJWXq764U1kJGu9lAtrFeAYdB-0EEPfVs7nGqo8TuQ5NFz3kMfgZk.5dRSxWxBepp6WGEb?startTime=1726776919000" target="_blank">View lecture part 2</a>.	<ul id="week_4" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 <a href="/MichaelMalz/CST1600/Labs/Lab02">Lab 2 - Create classicmodels database</a>.</li>
				<li>Discuss the classicmodels database.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, September 22nd, 2025:
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab02">Lab 2 - Create classicmodels database</a>.</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 5 -->
<!-- Week 6: Tuesday 2/15 (Willmar) -->
<li> <span class="classDate">Monday, September 22nd, 2025</span> <input type="button" id="weekControl_5" class="small" onclick="weekShow(this);" value="Show week 5">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/cnxhFero-NbcS1zRcJ6pvX0L7uvWOqmgT0AX9uW3n0T7NC89sy21l04OEBByzKOz.EQHHsBjHLXlPnbxM?startTime=1727377355000" target="_blank">View lecture part 1</a>. <a href="https://minnstate.zoom.us/rec/share/cnxhFero-NbcS1zRcJ6pvX0L7uvWOqmgT0AX9uW3n0T7NC89sy21l04OEBByzKOz.EQHHsBjHLXlPnbxM?startTime=1727381411000" target="_blank">View lecture part 2</a>.	<ul id="week_5" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 before 	2:00pm on Monday, September 29th, 2025:
			<ol type="i">
				<li>Optional <a href="/MichaelMalz/CST1600/Labs/Lab02.5">Lab. 2.5 - Create bookinfo database</a> <span class="evalEC">(for extra credit)</span>.</li>
				<li><a href="/MichaelMalz/CST1600/Labs/Lab03">Lab 3 - Create database model</a>.</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>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>
			</ol>
		</li>
	</ul>
</li><!-- END Week 6 -->
<!-- Week 7: Tuesday 2/22 (Hutchinson) -->
<li> <span class="classDate">Monday, September 29th, 2025</span> <input type="button" id="weekControl_6" class="small" onclick="weekShow(this);" value="Show week 6">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/02Nwtx89xVx4oX-9kGZt0sq5Ot_maFPcGkUgJaWLuiK6UVeSo5ndIhd8A7lNl3jP.szgj0gbV15jutqbG?startTime=1727982036000" target="_blank">View lecture part 1</a>. <a href="https://minnstate.zoom.us/rec/share/02Nwtx89xVx4oX-9kGZt0sq5Ot_maFPcGkUgJaWLuiK6UVeSo5ndIhd8A7lNl3jP.szgj0gbV15jutqbG?startTime=1727986829000" target="_blank">View lecture part 2</a>.	<ul id="week_6" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 <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 before 	2:00pm on Monday, October 6th, 2025:
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab04">Lab 4 - Perform simple query</a>.</li>
				<li><a href="/MichaelMalz/CST1600/Labs/Lab04.5">Lab. 4.5 - Another simple query</a>.</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-alias/">MySQL Alias</a>.</li>
						<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 7 -->
<!-- Week 8: Tuesday 3/01 (Willmar) -->
<li> <span class="classDate">Monday, October 6th, 2025</span> <input type="button" id="weekControl_7" class="small" onclick="weekShow(this);" value="Show week 7">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/3paWepfu0-9WNpxYC7fWIo72q9O6MaMleyFNwlzou_gMd6GR2LNgHXBh_3s2duNW.OY1_N4Wf95Uj0uuj?startTime=1728586916000" target="_blank">View lecture part 1</a>. <a href="https://minnstate.zoom.us/rec/share/3paWepfu0-9WNpxYC7fWIo72q9O6MaMleyFNwlzou_gMd6GR2LNgHXBh_3s2duNW.OY1_N4Wf95Uj0uuj?startTime=1728590779000" target="_blank">View lecture part 2</a>.	<ul id="week_7" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<ol type="i">
				<li>Discuss SQL code formatting.</li>
				<li class="ins">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 <i>Basic MySQL Tutorial</i> Section 5 <i>Joining tables</i>:
					<ol type="a">
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-alias/">MySQL Alias</a>.</li>
						<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>Discuss <a href="http://www.mysqltutorial.org/mysql-cte/">An Introduction to MySQL CTE</a>.></li>
						<li>Discuss <a href="http://www.mysqltutorial.org/mysql-recursive-cte/">A Definitive Guide To MySQL Recursive CTE</a>.</li>
					</ol>
				</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 before 	2:00pm on Monday, October 20th, 2025 (2 weeks):
			<ol type="i">
				<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>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>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 8 -->
<!-- Week 9: Tuesday 3/08 (Teacher Conventions) -->
<li> <span class="classDate">Monday, October 13th, 2025</span> <input type="button" id="weekControl_8" class="small" onclick="weekShow(this);" value="Show week 8">	<span class="attention nowrap">No class meetings this week. (Teacher Conventions)</span>
		<ul id="week_8" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="bold">No class meeting.</span>
		</li>
	</ul>
</li><!-- END Week 9 -->
<!-- Week 10: Tuesday 3/15 (Willmar) -->
<li> <span class="classDate">Monday, October 20th, 2025</span> <input type="button" id="weekControl_9" class="small" onclick="weekShow(this);" value="Show week 9">	<span class="attention nowrap">No live meeting this week. View recorded lecture.</span>
	&nbsp; <a href="https://minnstate.zoom.us/rec/share/zatRkkjBCSF5ZYkQn0Qx4ZH6x3yyYVCPRLs3s33pmHEmwlYUqivQLfeD11f_1fDn.WSZFOxoR-f4PZGDu?startTime=1729621573000" target="_blank">View lecture</a>.	<ul id="week_9" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 <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 <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 before 	2:00pm on Monday, November 3rd, 2025 (2 weeks):
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab05">Lab 5 - Perform subquery</a>.</li>
				<li><a href="/MichaelMalz/CST1600/Labs/Lab05.5">Lab. 5.5 - Another subquery</a>.</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 10 -->
<!-- Week 11: Tuesday 3/22 (Hutchinson) -->
<li> <span class="classDate">Monday, October 27th, 2025</span> <input type="button" id="weekControl_10" class="small" onclick="weekShow(this);" value="Show week 10">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/deroUgU6asr0Gf-64-79OzLqctY5wFbyp5cO_Db_E_a56pV-Zyksc7zMacBxVcdM.H20iMFjzJ-ZnxTaF?startTime=1730401280000" target="_blank">View lecture</a>.	<ul id="week_10" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm -->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 before 	2:00pm on Monday, November 3rd, 2025:
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab06">Lab 6 - Perform multi-table query</a>.</li>
				<li><a href="/MichaelMalz/CST1600/Labs/Lab06.5">Lab. 6.5 - Another multi-table query</a>.</li>
				<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 11 -->
<!-- Week 12: Tuesday 3/29 (Willmar) -->
<li> <span class="classDate">Monday, November 3rd, 2025</span> <input type="button" id="weekControl_11" class="small" onclick="weekShow(this);" value="Show week 11">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/3bWITnXnozCltwmoxcYGUf5RAFeOSOiWAwTwdLtkYNO1huI2vw0fa8tOKJFPJx0L.VzyAcS2sN58bTyAN?startTime=1731009728000" target="_blank">View lecture</a>.	<ul id="week_11" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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 <a href="http://www.studytonight.com/dbms/database-normalization.php">Normalization of Database</a> http://www.studytonight.com. <span class="note">Moved to next week.</span></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. <span class="note">Moved to next week.</span></li>
				<li>Discuss <a href="http://holowczak.com/database-normalization/">Database Normalization</a> http://holowczak.com. <span class="note">Moved to next week.</span></li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, November 10th, 2025:
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab07">Lab 7 - 1st Normalization</a>.</li>
				<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>
				<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>
			</ol>
		</li>
	</ul>
</li><!-- END Week 12 -->
<!-- Week 13: Tuesday 4/05 (Hutchinson) -->
<li> <span class="classDate">Monday, November 10th, 2025</span> <input type="button" id="weekControl_12" class="small" onclick="weekShow(this);" value="Show week 12">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/CVUc1fN43SIFaYo5Mz80np16HovEFUIhpGd93zVkhVoDl9FZcfCNeMyycQBXS9ww.4r0Sc0OvFpoDnig2?startTime=1731614466000" target="_blank">View lecture</a>.	<ul id="week_12" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<ol type="i">
				<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 <a href="http://www.thatsoftwaredude.com/content/1030/database-normalization-is-good-and-bad">Database normalization is good and bad</a>.</li>
				<li>Discuss <a href="https://www.w3schools.in/dbms/database-normalization/">Database Normalization</a>.</li>
				<li>Discuss <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>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, November 24th, 2025 (2 weeks):
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab08">Lab 8 - 2nd Normalization</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>
			</ol>
		</li>
	</ul>
</li><!-- END Week 13 -->
<!-- Week 15: Tuesday 4/19 (Hutchinson) -->
<li> <span class="classDate">Monday, November 17th, 2025</span> <input type="button" id="weekControl_13" class="small" onclick="weekShow(this);" value="Show week 13">	&nbsp; <a href="https://minnstate.zoom.us/rec/share/urBTnMDXvIIuv8HXJgSYNSAQwQejxrKdNRLOXEjVjDulnuf5eD73R71XSXbCwH27.wvkK2vH-iMf6HxXv?startTime=1732219291000" target="_blank">View lecture</a>.	<ul id="week_13" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="classDate">Monday</span>, 	2:00pm-4:30pm.<br>It is a good idea to login to <a href="https://minnstate.zoom.us/">Zoom</a> before joining the meeting.			<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>
				<li>Discuss <a href="http://www.complexsql.com/database-normalization/">Database Normalization Examples</a>.</li>
				<li>Discuss <a href="https://ws.ridgewater.edu/ClassLists/20243-Hutchinson-ClassList.html">Ridgewater College, Hutchinson Campus 
Fall Semester 2023 Class Schedule</a> and <a href="https://ws.ridgewater.edu/ClassLists/20243-Willmar-ClassList.html">Ridgewater College, Willmar Campus 
Fall Semester 2023 Class Schedule</a> with an eye towards normilization.</li>
				<li>Discuss class tasks.</li>
			</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, November 24th, 2025:
			<ol type="i">
				<li><a href="/MichaelMalz/CST1600/Labs/Lab09">Lab 9 - 3rd Normalization</a>.</li>
			</ol>
		</li>
		<li>
			Complete the following before 	2:00pm on Monday, November 24th, 2025:
			<ol type="i">
				<li>Optional <a href="/MichaelMalz/CST1600/Labs/Lab10">Lab 10 - Create a database</a> <span class="evalEC">(for extra credit)</span>.</li>
				<li>Please complete the <a href="../?Questionnaire">class questionnaire</a>.</li>
			</ol>
		</li>
	</ul>
</li><!-- END Week 15 -->
<!-- Week 14: Tuesday 4/12 (Willmar) School closed: Thanksgiving Break -->
<li> <span class="classDate">Monday, November 24th, 2025</span> <input type="button" id="weekControl_14" class="small" onclick="weekShow(this);" value="Show week 14">	<span class="attention nowrap">No class meetings this week. (Thanksgiving Break)</span>
		<ul id="week_14" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="bold">No class meeting.</span>
		</li>
	</ul>
</li><!-- END Week 14 -->
<!-- Week 16: Tuesday 4/26 (Willmar) -->
<li> <span class="classDate">Monday, December 1st, 2025</span> <input type="button" id="weekControl_15" class="small" onclick="weekShow(this);" value="Show week 15">	<span class="attention nowrap">No class meetings this week.</span>
		<ul id="week_15" class="hidden">
		<li><!-- Wednesday 1:00pm-3:30pm	-->
			<span class="bold">No class meeting.</span>
		</li>
		<li>If you need help with labs, please call me to setup a day/time for a Zoom meeting.</li>
		<li>All assignments were due by Thursday, November 28<sup>th</sup> 2022.</li>
	</ul>
</li><!-- END Week 16 -->
<!-- Week 17: Tuesday 5/03 (Hutchinson) -->
<li> <span class="classDate">Monday, December 8th, 2025</span> <input type="button" id="weekControl_16" class="small" onclick="weekShow(this);" value="Show week 16">		<span class="attention">Finals week. No class meeting.</span>
	<ul id="week_16" class="hidden">
		<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 were due by Thursday, November 28<sup>th</sup> 2022.</li>
	</ul>
</li><!-- END Week 17 -->
</ol>
</fieldset>
    </td>
    <td class="blackBorderRight"></td>
  </tr>
</table>
<!-- End section 2 -->

<!-- Begin section 3 -->
<br>
<table id="tbl_3" class="sectionTable nopad center"  style="width:1000px;" >
  <tr>
    <td class="blackBorderLeft"></td>
    <td id="td_3" class="sectionTd blackHeading" style="width:978px;">
			<div style="position:relative;">
			<div style="padding-top:3px;">References and Resources</div>			</div>
		</td>
    <td class="urcA"><div class="urcA"></div></td>
    <td class="urcB"><div class="urcB"></div></td>
  </tr>
  <tr>
    <td class="whiteBorder"></td>
    <td id="td2_3" class="contentTd white" colspan="2" style="width:996px;">
<fieldset><legend>References and Resources</legend>
<ol>
	<li>Laptop computer with Windows 10. (Student supplied)</li>
	<li><a href="/MichaelMalz/CST1600/?Assignments">Assignments</a>.</li>		<li><span class="menuCurrent" title="CST1600 Schedule.">Schedule</span>.</li>	<li><a href="/MichaelMalz/CST1600/Syllabus.php" title="CST1600 Syllabus.">Syllabus</a>.</li>		<li><a href=".././Resources">Resources</a>. Browse class resources.</li>
		<li><a href=".././Examples">Example Files</a>. Browse class example files.</li>
	</ol>
</fieldset>
    </td>
    <td class="blackBorderRight"></td>
  </tr>
</table>
<!-- End section 3 -->

<!-- Begin section 4 -->
<br>
<table id="tbl_4" class="sectionTable nopad center"  style="width:1000px;" >
  <tr>
    <td class="blackBorderLeft"></td>
    <td id="td_4" class="sectionTd blackHeading" style="width:978px;">
			<div style="position:relative;">
			<div style="padding-top:3px;">Instructor Information</div>			</div>
		</td>
    <td class="urcA"><div class="urcA"></div></td>
    <td class="urcB"><div class="urcB"></div></td>
  </tr>
  <tr>
    <td class="whiteBorder"></td>
    <td id="td2_4" class="contentTd white" colspan="2" style="width:996px;">
	<fieldset id="ContactInformation"><legend>Contact Information</legend>
	<table>
		
			<tr><td class="nowrap right">Instructor:</td><td>Michael Malz</td></tr>
		
			<tr><td class="nowrap right"></td><td><img src="/images/MichaelMalz100.jpg" width="100" height="144" alt="Michael Malz" /></td></tr>
		
			<tr><td class="nowrap right">Email address:</td><td>Michael.Malz@ridgewater.edu (<a href="mailto:Michael.Malz@ridgewater.edu">Send email</a>)</td></tr>
		
			<tr><td class="nowrap right">Work number:</td><td>320-234-8546 <span class="note">You can call or text this number.</span></td></tr>
		</table>
	</fieldset>
	    </td>
    <td class="blackBorderRight"></td>
  </tr>
</table>
<!-- End section 4 -->
	<div id="div_copyright" class="copyright">
		IP=134.29.175.74  userId=1688 <br>
  	&copy;1998-2025	</div>
	<div id="tooltipContainer"><div id="tooltipDiv"><!-- Needed for tooltip --></div></div>
	<script>
		// pageFooter.phpinc:37.
		function capitalizeMe(obj) {
			var val = obj; 
			var newVal = ''; 
			var val = val.split(' '); 
			for(var c=0; c < val.length; c++) { 
				newVal += val[c].substring(0,1).toUpperCase() + val[c].substring(1,val[c].length) + ' ';
			}
			return newVal.replace(new RegExp("[" + "\\s" + "]+$", "g"), ""); 
		}
		var server = 'ridgewater'; 
		var domain = 'edu'; 
		var first = 'jim'; 
		var last = 'martinson'; 
		var ea = '<a href="' + 'mail' + 'to:' + first + '.' + last + '@' + server + '.' + domain + '" style="color:darkgray;">' + capitalizeMe(first+' '+last) + '</a>';
		//document.write(ea);
		document.getElementById('div_copyright').innerHTML = document.getElementById('div_copyright').innerHTML+ea;
		var LOCK_BELOW = 16;
		var trueuserId = 1688;
		var userId = 1688;
		var userPermissions = ['USER', 'ADMIN'];
		CollapsibleLists.apply();
	// onload:
	_Initialize(); ScheduleCollapse();
	
	</script>
</body>
</html>

Anon7 - 2022
AnonSec Team