CSC330S2020Syllabus

From BU Computer Science
Jump to navigation Jump to search

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
  * Late work 

Assignments

  1. third ER diagram assignment
  2. Semester project
  3. Single Table SQL Homework
  4. Single Table SQL Lab
  5. Multiple Table SQL Homework
  6. Multiple Table SQL Lab

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
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.edu for an appointment.