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 data related. This needs to be completed by midterm.
   a. Write a reaction to one article in XRDS. It must be data 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:
   * Homework is worth 15% of the final grade
   * Labs are worth 35% of the final grade
   * Exams are worth 50% of the final grade with the final exam being double the normal weight.  It is expected that to pass the course, one must have a passing average on the exams.

   * 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 2 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: ER Diagrams		| 3/11: ER Diagrams<br>ER Homework 1 due	| 3/13: SQL Exam 3	|
| 3/16: ER Diagrams	| 3/18: ER Diagrams<br>ER Lab 1 due	| 3/20: Views and Constraints		|
| 3/23: Indexes<br>ER Homework 2 due	| 3/25: work day	| 3/27: Indexes	|
| 3/30: Work Day<br>ER Lab 2 due	| 4/1: Exam			| 4/3<br> Easter		|
| 4/6: Normalization		| 4/8: Normalization		| 4/10: Normalization	|
| 4/13: Transaction Processing	| 4/15: Transaction Processing	| 4/17: Transaction Processing	|
| 4/20: Advanced Databases	| 4/22: Advanced Databases		| 4/24: Exam	|
| 4/27: Finals week		| 4/29: Finals<br>10:30-12:30	| 4/31: Finals week	|
%INCLUDE{CampusPolicies2024}%
Topic revision: r9 - 2026-03-02 - CathyBareiss