CSC210SylS2024 < CenterForComputing

%INCLUDE{CSC210ForSyllabus}%

---++ Details
   * Professor: Dr. Cathy Bareiss
   * Office SB 31
   * Class Time: 2:00-3:20 TR
   * 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>Oracle SQL: A Beginner's Tutorial, Second Edition</u> by Djoni Darmawikarta. ISBN: 9781771970303
      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</u> by Anthony !DeBarros. ISBN: 9781593278274
      1 <u>SQL: A Beginner's Guide, Fourth Edition</u> by Andrew Oppel
      1 <u>Introduction to SQL and PL/SQL</u> by Sharad Maheshwari. ISBN: 9780071842594
   * Resources: All the <u>Oracle Database 12c - Introduction to SQL</u> courses found on !SkillSoft of the learning center of ACM
      1 First one: Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT statement

---++ Course Content
---+++ Policies
   * [[OnLineHelp][Use of Internet Resources]]
   * [[AcceptableWork][Integrity]]
   * [[LatePolicy ]]
   * [[SoftwareStandards ]]
   * [[SoftwareDevelopmentReport ]]: A sample software development report: [[%PUBURL%/CenterForComputing/WebHome/SDRSample.pdf][A sample Software Development Report]]

---+++ 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   [[%ATTACHURL%/SQLGuidelinesWorksheet.rtf][SQL Worksheet]]
   1. [[CSC210S2024Home1][Single Table SQL]]
   1. [[CSC210S2024Home2][Aggregation and Joins SQL]]
   1. [[CSC210S2024Home3][Nested and Advanced SQL]]
   1 [[CSC210S2022SyllabusHome4][ER Homework 1]]
   1 [[CSC210S2022SyllabusHome5][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. [[CSC210S2024Lab1][Single Table SQL]]
   1. [[CSC210S2024Lab2][Aggregation and Joins SQL]]
   1. [[CSC210S2024Lab3][Nested and Advanced SQL]]
   1 [[CSC210S2022SyllabusLab4][ER Lab 1]]
   1 [[CSC210S2022SyllabusLab5][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)
| *Tuesday Lab*  									| *Thursday* 									| 
| 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{CampusPolicies2023}%
Attachments
Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
rtf	SQLGuidelinesWorksheet.rtf	r1	manage	58.9 K	2024-01-08 - 20:09	CathyBareiss	SQL Worksheet
This topic: CenterForComputing > WebHome > Syllabi > SyllabiSpring2024 > CSC210SylS2024
Topic revision: r4 - 2024-03-06 - CathyBareiss