(r5) CSC210SylS2026 < CenterForComputing

Tags: view all tags
%INCLUDE{CSC210ForSyllabus}%

---++ Details
   * Professor: Dr. Cathy Bareiss
   * Office SB 31
   * Class Time: 11:00-11:500 MWF
   * Class Location: S 025
   * Textbook: Student membership in ACM. Resources from ACM Learning Center that will be used include:
      1. <u>Relational Database Design and Implementation, Fourth Edition</u> by  Jan L. Harrington.  ISBN: 9780128043998
      1. <u>Fundamentals of Database Management Systems, Second Edition</u> by Gilleson.  ISBN: 9780470624708
      1 <u>SQL for !MySQL: A Beginner’s Tutorial</u> by Djoni Darmawikarta. ISBN: 978-0-9808396-7-8
      1 <u>SQL Primer: An Accelerated Introduction to SQL Basics</u> by Rahul Batra. ISBN: 9781484235751
      1 <u>Practical SQL: A Beginner's Guide to Storytelling with Data, 2nd Edition</u> by Anthony !DeBarros. ISBN: 978-1-7185-0106-5
      1 <u>SQL: A Beginner's Guide, Fourth Edition</u> by Andrew Oppel
   * Resources Channels: Be sure to start with ones that work on the basics of the SELECT statement!
      1. !MySQL
      1. Introduction to SQL with !MySQL and Workbench


---++ Course Content
---+++ Policies
   * [[OnLineHelp][Use of Internet Resources]]
   * [[AcceptableWork][Integrity]]
   * [[LatePolicy ]]
   * [[SoftwareStandards ]]

---++ Environment
This semester all work is to be done on a virtual machine with !MySQL and !MySQL workbench.  You need to create the environment before the first Monday of class.  Instructions for creating and using the environment can be found at [[CSC210S2026vm][VM systems for database]]

---+++ Assignments
There are three types of assignments for this course:  Homeworks, Labs, and Others.
---++++Homeworks
   1. SQL worksheet to be turned in twice -> see canvas  for dates : [[%ATTACHURL%/SQLGuidelinesWorksheet.rtf][SQL Worksheet]]
   1. [[CSC210S2026Home1][Single Table SQL]]
   1. [[CSC210S2026Home2][Aggregation and Joins SQL]]
   1. [[CSC210S2026Home3][Nested and Advanced SQL]]
   1. [[CSC210S2026SyllabusHome4][ER Homework 1]]
   1. [[CSC210S2026SyllabusHome5][ER Homework 2]] 
   1. Normalization homework.  From Chapter 7 of the "Fundamentals" textbook: Questions  5 (a-c), 7, 8, 9, 12, 15. Exercise 2, and Minicase 2 -> just create the tables using our functional dependency rules
   1. Concurrency, etc. homework.  From Chapter 11 of the "Fundamentals" textbook: Questions 11, 16, 18, 19, and 20.  Exercise 3a and b.

---++++Labs
   1. [[CSC210S2026Lab1][Single Table SQL]]
   1. [[CSC210S2026Lab2][Aggregation and Joins SQL]]
   1. [[CSC210S2026Lab3][Nested and Advanced SQL]]
   1. [[CSC210S2026SyllabusLab4][ER Lab 1]]
   1. [[CSC210S2026SyllabusLab5][ER Lab 2]]

---++++Other Assignments
There are two additional assignments involving reactions to current events. Announcements will *not* be made in class.  You are responsible to track these yourself.  Standard late policy will apply to these assignments.<br>You are to react to current events/publications.  A reaction to an article includes enough to convince me that you have read the entire article and not just the headline or first paragraph.  It should include a summary of what was said and your reaction.  Be sure to give a complete reference to the item.  These should be turned in as a hard copy in class within one week of the item being published.  You may pick when.  Each one does have a deadline.  The ones you pick must be unique to this course
   a. Write a reaction to one article in the ACM !TechNews. It must be programming related. This needs to be completed by midterm.
   a. Write a reaction to one article in XRDS. It must be programming related. This needs to be completed before the final.
---+++ Extra credit
   * Extra credit will only be made available based on the entire class needs.  Such as an exam that most people did poorly on despite a good effort.
---+++ Grades

Your grades are made up of:

   * Grade scale
      * 93% &lt;= average &lt;= 100% -&gt; A
      * 90% &lt;= average &lt; 93% -&gt; A-
      * 87% &lt;= average &lt; 90% -&gt; B+
      * 83% &lt;= average &lt; 87% -&gt; B
      * 80% &lt;= average &lt; 83% -&gt; B-
      * 77% &lt;= average &lt; 80% -&gt; C+
      * 73% &lt;= average &lt; 77% -&gt; C
      * 70% &lt;= average &lt; 73% -&gt; C-
      * 67% &lt;= average &lt; 70% -&gt; D+
      * 63% &lt;= average &lt; 67% -&gt; D
      * 60% &lt;= average &lt; 63% -&gt; D-
      * 0% &lt;= average &lt; 60% -&gt; F

---+++ Tentative Schedule (needs fixing)
| *Monday*  			| *Wednesday* 		| *Friday* 		| 
| 1/5					| 1/7					| 1/9: First day: Introduction to Database and SQL	|
| 1/12: Single Table SQL	| 1/14: Work Day		| 1/16: Single Table aggregations, etc.			|
| 1/19<br>No classes	| 1/21: Work day<br>Homework 1 due		| 1/23: Joins			|
| 1/26: Joins<br>Lab 1 due	| 1/28: Exam 1	| 1/30: Work day			|
| 2/2: Joins and sets	| 2/4: Nested queries	| 2/6: work day			|
| 2/9: Nested queries<br>Homework 1 due	| 2/11: work day	| 2/13: Security<br>Lab 2 due			|
| 2/16: workday			| 2/18: *SIGCSE*		| 2/20: *SIGCSE*<br>Homework 3 due			|
| 2/23: privacy				| 2/25: workday		| 2/27: Exam 2<br>Lab 3 due			|
| 3/2<br>Spring break	| 3/4<br>Spring Break	| 3/6<br>Spring Break 	|
| 3/9					| 3/11				| 3/13				|
| 3/16				| 3/18				| 3/20				|
| 3/23				| 3/25				| 3/27				|
| 3/30				| 4/1					| 4/3<br> Easter		|
| 4/6					| 4/8					| 4/10				|
| 4/13				| 4/15				| 4/17				|
| 4/20				| 4/22				| 4/24				|
| 4/27: Finals week		| 4/29: Finals<br>10:30-12:30	| 4/31: Finals week	|
---++++Last time's schedule
| 1/9 											| 1/11:  Introduction to Database and SQL		 	|
| 1/16: Single Table SQL 							| 1/18:  Work day								|
| 1/23: Single Table Aggregations and Joins			 	| 1/25: Joins<br>Homework 1 due		  			|
| 1/30: Joins										| 2/1: Joins and review <br>Lab 1 due 				|
| 2/6: Nested queries 					 			| 2/8:  Exam 1<br>Homework 2 due (on Friday)		|
| 2/13:  Nested queries and sets						| 2/15: Security<br>Lab 2 due		  				|
| 2/20:  SQL Reports and class work<br>Homework 3 due	| 2/22: Privacy<br>Lab 3 due (on Friday) 		 	|
| 2/27:  SQL and current topic							| 2/29: Exam 2									|
| 3/5: Spring Break									| 3/7: Spring Break								|
| 3/12: ER Diagrams								| 3/14: ER Diagrams<br>Homework 4 due (on Wed.)	|
| 3/19: ER Diagrams and Constraints<br>Lab 4 due (on Mon.)   	| 3/21:SIGCSE 					 		|
| 3/26: Views<br>Homework 4 due (on Mon.)			. 	| 3/28:Easter Break 							|
| 4/2: Normalization<br>Lab 5 due (on Mon.)				| 4/4: Exam 3   								|
| 4/9:  Normalization<br>Homework 6 due				| 4/11: Transaction processing					|
| 4/16: Transaction processing						| 4/18: Indexes and !NoSQL<br>Homework 7 due		|
| 4/23: Exam 4										| 4/25: Review for final							|
| 4/30: Finals Week									| 5/2: Finals week<br>Final Exam 1:00-3:00	 		|
%INCLUDE{CampusPolicies2024}%
Topic revision: r5 - 2026-01-14 - CathyBareiss