CSC210SylS2022 < CenterForComputing

Tags: view all tags
%INCLUDE{CSC210ForSyllabus}%

---++ Details
   * Professor: Dr. Cathy Bareiss
   * Office SB 031
   * Class Time: MW 9:00-9:50
   * Class Location: S 025 or zoom
   * Textbook:
      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
   * [[AcceptableWork][Integrity]]
   * [[LatePolicy][Late Work]]

---+++ Assignments
---++++ Homework Assignments
   1 [[CSC210S2022SyllabusHome1][ Simple SQL]]
   1 [[CSC210S2022SyllabusHome2][ Aggregation and joins]]
   1 [[CSC210S2022SyllabusHome3][ Nested and advanced SQL]]
   1 [[%ATTACHURLPATH%/SQLGuidelinesWorksheet.rtf][SQLGuidelinesWorksheet.rtf]]: Form the the SQL reference sheet.  See canvas for the due dates!
   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.

---++++ Lab Assignments
   1 [[CSC210S2022SyllabusLab1][ Simple SQL]]
   1 [[CSC210S2022SyllabusLab2][ Aggregation and joins]]
   1 [[CSC210S2022SyllabusLab3][ Nested and advanced SQL]]
   1 [[CSC210S2022SyllabusLab4][ER Lab 1]]
   1 [[CSC210S2022SyllabusLab5][ER Lab 2]]

---+++ Grades
   * Homework, etc. is worth 20% of the final grade
   * Programs are worth 40% of the final grade
   * Exams are worth 40% of the final grade with the cumulative final being worth twice a normal exam
   * 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

| *Monday*  | *Wednesday*  | *Friday*  |
| Jan 10:  | Jan 12:  | Jan. 14: Introduction to Database  |
| Jan 17: Introduction to SQL  | Jan 19: Introduction to SQL  | Jan. 21: Database and in class work  |
| Jan 24: Joins<br />Homework 1 due  | Jan 26: Joins  | Jan. 28: Joins<br />Lab 1 due  |
| Jan 31: in class work  | Feb 2: Snow Day  | Feb. 4: Review and nested queries  |
| Feb 7: Exam 1<br />Homework 2 due  | Feb 9: nested queries  | Feb. 11: nested queries and sets  |
| Feb 14: SQL reports<br />Lab 2 due  | Feb 16: Security  | Feb. 18: Privacy<br />Homework 3 due  |
| Feb 21: SQL  | Feb 23: Current topic  | Feb. 25: <br />Lab 3 due  |
| Feb 28:  | Mar 2: Exam 2  | Mar. 4: Class cancelled<br />SIGCSE  |
| Mar 7: <br />Spring Break  | Mar 9:<br />Spring Break  | Mar. 11:<br />Spring Break  |
| Mar 14: ER Diagrams  | Mar 16: ER Diagrams  | Mar. 18: ER Diagrams  |
| Mar 21: ER Diagrams<br />Homework 4 due  | Mar 23: Constraints  | Mar. 25: Views, etc.  |
| Mar 28: In class work  | Mar 30: Normalization<br />Lab 4 (ER lab) Due  | Apr. 1: Normalization  |
| Apr 4: Exam 3  | Apr. 6: Normalization  | Apr. 8: Transaction processing  |
| Apr 11: Transaction processing  | Apr. 13: Transaction processing  | Apr. 15:<br />Easter Break  |
| Apr 18: Indexes  | Apr. 20: NoSQL  | Apr. 22: review for exam  |
| Apr 25:   | Apr. 27: Exam 4  | Apr. 29: review for final |
| May 2: Final Exam at 8:00am | May 4: finals week  | May 6:  |
%INCLUDE{CampusPolicies2021}%

   * [[%ATTACHURLPATH%/SQLGuidelinesWorksheet.rtf][SQLGuidelinesWorksheet.rtf]]: Form the the SQL reference sheet
Attachments
Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
rtf	SQLGuidelinesWorksheet.rtf	r1	manage	58.9 K	2022-01-04 - 10:52	UnknownUser	For the the SQL reference sheet
Topic revision: r9 - 2022-04-20 - cathybareiss