CSC 330: Database Programming: Spring 2020

Details

• Professor: Dr. Cathy Bareiss
• Office SB 027
• Class Time: 9:30-10:45 TR
• Class Location: SB 025
• Textbook: Student membership of ACM. Primary text (available for free with ACM membership): Fundamentals of Database Management Systems, 2nd ed. by Mark Gillenson. ISBN: 9780470624708
  Secondary texts (also free with ACM membership) include: Concepts of Database Management System by Shefali Naik. ISBN 9789332537422

Additional Resources

There are a LOT of online "courses" available including a bunch associated with your ACM membership.

• For SQL (under skillsoft section)
  • Oracle Database 12c: Introduction to SQL: Relational Database and SQL developer
  • Oracle Database 12c: Introduction to SQL: SQL*Plus and Select Statement
  • Oracle Database 12c: Introduction to SQL: Data Manipulation Language
  • Oracle Database 12c: Introduction to SQL: Data Conversion and Aggregation Data
  • Oracle Database 12c: Introduction to SQL: Working with Joins and Subqueries
  • Oracle Database 12C: Introduction to SQL: Working with Set Operators and DDL
  • Introduction to SQL
  • Introduction to SQL: Multiple Tables and Advanced Queries
• For transaction processing
  • Chapter 11 of the Fundamentals textbook
  • Chapter 8 of the Concepts textbook

Description

Course Goals

Course Objectives

Course Outcomes

Program Outcomes

Course Content

Policies

• Integrity
• LatePolicy

Assignments

1. third ER diagram assignment
2. Semester Project
3. Single Table SQL Homework
4. CSC330S2020SingleSQLLab
5. Multiple Table SQL Homework
6. CSC330S2020MultipleSQLLab

Grades

• Homework and quizzes (worth 20%). These will be assigned throughout the semester in class. Due dates will also be given then. Hard copy will be required unless otherwise stated. Homework is due at the start of the class unless otherwise stated. Quizzes will typically be on Canvas
• Lab work (worth 40%). Lab work will be assigned throughout the semester. Code will be turned in via Canvas
• Exams (worth 40%) There will be a comprehensive exam (worth twice the regular exams)

• Grade scale
  • 93% <= average <= 100% → A
  • 90% <= average < 93% → A-
  • 87% <= average < 90% → B+
  • 83% <= average < 87% → B
  • 80% <= average < 83% → B-
  • 77% <= average < 80% → C+
  • 73% <= average < 77% → C
  • 70% <= average < 73% → C-
  • 67% <= average < 70% → D+
  • 63% <= average < 67% → D
  • 60% <= average < 63% → D-
  • 0% <= average < 60% → F

Tentative Schedule

For SQL part,

• refer to chapter 4 of the Fundamentals textbook (don't need to worry about optimization)
• chapter 7 of the Concepts book (notes:
  1. this chapter has HORRIBLE spacing/align → use the Fundamentals or class lectures for guidance)
  2. don't use INNER JOIN, OUTER JOIN or CUBE ROLLUP in your sql statements

For Indexes:

• refer to chapter 8 of the Fundamentals textbook

For transaction processing

• Chapter 11 of the Fundamentals textbook
• Chapter 8 of the Concepts textbook

{| class="wikitable"

Tuesday	Thursday
Jan 7	Jan 9
Jan 14	Jan 16
Jan 21	Jan 23
Jan 28	Jan 30
Feb 4	Feb 6
Feb 11	Feb 13
Feb 18	Feb 20
Feb 25	Feb 27
Mar 3 Spring Break	Mar 5 Spring Break
Mar 10	Mar 12
Mar 17 canceled	Mar 19 continue with joins and nested queries
Mar 24 Nested queries, unions, etc.	Mar 26 exam → single table queries
Mar 31 more sql	Apr 2 more sql
Apr 7 exam → multiple table queries	Apr 9 Easter Break
Apr 14 indexes	Apr 16 views and constraints
Apr 21 advanced db	Apr 23 advanced db
Apr 28 exam (new stuff)	Apr 30 exam (review)

Services

ADA Statement for Syllabi: The Americans with Disabilities Act (ADA) is a law which provides civil rights protection for people with disabilities. Bethel University, in compliance with equal access laws, requests that students with disabilities seeking to acquire accommodations make an appointment with the Center for Academic Success—Disability Services. It is located in the Miller-Moore Academic Center, 033. You may also phone 574-807-7460 or email rachel.kennedy@betheluniversity.com.edu for an appointment.