Database Management Systems
CS 370

SPRING 2017 SYLLABUS

Past syllabi: Fall 2010 | Fall 2011 | Fall 2012 | Fall 2013 | Fall 2014 |Fall 2015

MOODLE SITE for Fall 2015


Objectives 

Grading and Assignments 

Course policies 

Reading/
Homework
 

PostgreSQL Quick Ref. Teams Interactive Tutoring Vote Page

This page last changed 17-dec-15


Instructor:

Loren Rhodes
E-mail: rhodes@juniata.edu 
Office location and phone: C-208 BAC, (814) 641-3620 
Cell: 814-644-3309

Office Hours are kept current on my home page. See the home page or my office door for recent changes; other office hours may be arranged by appointment.

Class meeting times:

M W F 8:00-8:55 in C102 BAC

Required text:

  • Databases Illuminated 3nd Ed., Catherine Ricardo and Susan Urban, Jones and Bartlett, 2017 (ISBN 978-1-284-05694-5)

Recommended resources:


Objectives:

The student should develop skills and understanding in:

This course's prerequisite is CS 110 or some experience in programming.  You should bring understand and/or skills in, or willingness to learn, the following areas:

Unix basics highly suggested

If you have not taken CS 255U. Please do so this semester! It meets on Tuesdays at 8:00 (during the 4th hour of the MWF 8 time slot).

Instructor's expectations of students:

Students' expectations of the instructor:


Grading: 2017 dates TBD

Previous year's exams are available for study. Links to study guides may be updated a few days before each exam.

Study Guides Fall 2015 Exams & Keys Fall 2014 Exams & Keys Fall 2013 Exams & Keys Fall 2012 Exams & Keys Fall 2011 Exams & Keys Fall 2010 Exams & Keys Fall 2009 Exams & Keys Fall 2008 Exams & Keys Fall 2007 Exams & Keys  
Exam 1 Study Guide Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
Exam 1
Exam 1 key
 
Exam 2 Study Guide    Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
Exam 2
Exam 2 key
 
 Final Study Guide
Final sample not available

Exams are a reflection of classroom and book theory, general concepts and personal understanding of the material; they will not necessarily cover programming project details. End of chapter exercises are excellent review questions for exams.

Assignments and programs:

Assignments (exercises listed below and those given in class) should be prepared for the following class meeting. Some may be collected for grading, others may just be reviewed in class. 

Programming projects, which are based on those in the text, will have their due dates announced in class or on the assignments. Some projects may be done in pairs only when clearly designated on the assignment. 

Major Project Descriptions:

The following projects are described in narrative form for each team to develop a functioning relational database for one of these by the end of the semester. Teams of 3 students will be assigned by the instructor based on your choice by ranking of these projects. Some teams may develop a database solution for the same project if there are more than 4 teams, but may not work together.

 


Course policies

My standard policies on attendance, late assignments, academic integrity, etc., are described on this web page. Please read them carefully.

Disabilities Policy

In accordance with the Americans with Disabilities Act and Section 504 of the Rehabilitation Act, students with a documented disability are eligible to request reasonable accommodations. To make such a request or for more information, please contact Beth Bleil, Director of Disability Services, in the Office of Academic Support by visiting her office in Founders Hall, emailing her at bleilb@juniata.edu, or calling 814-641-5840. It is best to submit accommodation requests within the drop/add period, however, requests can be made at any time in the semester. Please keep in mind that accommodations are not retroactive.


DATABASE MANAGEMENT SYSTEMS
SPRING 2017 TENTATIVE LECTURE/LAB OUTLINE

This schedule is a work in progress.  Assignments, case studies, and lecture notes will be under constant revision throughout the semester and may still contain references to notes from previous texts and editions. 

READINGS ARE EXPECTED TO BE DONE PRIOR TO THE CLASS DATE.

Exercises noted as "Review" are suggested as excellent chapter reviews and exam preparation. Exercises noted as "Homework" are expected to be written out for either credit and review during classtime, or as submitted to Moodle for closer grading and credit. In either case they shall be neatly prepared for reading by others.

HOMEWORKS AND PROJECTS WILL HAVE A DESIGNATED DUE DATE IN THE ASSIGNMENT; THEY ARE ON THE SYLLABUS AT THE POINT OF ASSIGNMENT.

Notes and outlines as linked below are based on materials from the text by Ricardo, and the 2003 text by Lewis et al, which are copyrighted. Use of this material beyond the context of this course may infringe on the copyright of these texts.

This syllabus and readings are revised for the new edition of the text used in Spring 2017. Semester dates TBD

Class-
Date

Reading 
(ADbC tutorials)
Topics/
Lecture Links
Homework/
Programs/Exercises 

1-8/28

Ch 1 Intro concepts
Introduction and Overview
Review: all chapter 1 exercises

2-8/31

Ch 1 Exploring Access  Lab exercises 1.1
Due 9/2/15 8:00 a.m. to Moodle

3-9/2

Ch 2.1-2.5 Database Planning
Design Document (skim this)
Develop Specification Document for group project Due Fri. 9/11/15 8 am in hardcopy binder

4-9/4

Ch 2.6-2.7
Moodle QUIZ 1
Database Architecture Review: all chapter 2 exercises

5-9/7

Ch 2.7, 3.1-3.4
(ADbC ER notations)
Entity-Relationship Model: Entities, Attributes, Keys
Dia Diagramming Lab
Due Wed. 9/9/15 5:00 p.m.

6-9/9

Ch 3.5-3.8
(ADbC ER Scenarios)
Entity-Relationship Model: Relationships, Roles and Dependencies Review: 3.1
ER exercises 3.2, 3.3, 3.4
Due 9/18/15 8 am (book pages)

7-9/11

Moodle QUIZ 2
Ch 3.9-3.12

Additional E-R Modeling Issues

Extended Entity Relationship Model

Draft ER diagram for group project--Due Monday, 9/21/15 5:00 p.m.

8-9/14

Ch 4.1-4.4 Intro to the Relational Model

Review: 4.1-4.3

9-9/16

Ch 4.5
Moodle QUIZ 3 9/18
Relational Algebra Homework: Chapter 4 (due 9/25/15)

10-9/18

11-9/21

Ch 4.6-4.8
(ADbC ER to Tables)
Mapping the ER model to Relational DB Presidential DB relational algebra subset of queries due 9/30/15, even queries only (odds discussed in class)

12-9/23

Ch 6.1-6.4 (ch 5 later)
(ADbC Func. Dep)
Functional Dependencies  

13-9/25

Moodle QUIZ 4
Ch 6.5
Normal Forms  

14-9/28

Ch 6.6-6.9
(ADbC Normalization Denorm. and Anomalies)
Normalization Process
Decomposition Examples
Homework: 6.1, 6.2, 6.3 (follow link for notes) Due 10/8/15

15-9/30

Review and catch up    

16-10/2

EXAM 1 Chapters 1-4, 6

17-10/5

Ch 5.1-5.3
(ADbC SQL)
(ADbC Ref. Integrity)
SQL Data Definition
Revised ER diagram due Friday, 10/9/15

18-10/7

Relational schema project deliverables Due 10/27/15 5 pm

19-10/9

Ch 5.4.1-5.4.3
Moodle QUIZ 5
SQL Query sublanguage

 

20-10/12

(ADbC SQL)
Presidents DB SQL 2-28 evens
Due 10/29/15 5pm

21-10/14

Moodle QUIZ 6
Ch 5.4.4
(ADbC SQL)
Modifying Relations in SQL  

22-10/19

Ch 5.4.5
(ADbC SQL)
Views Homework: 5.2 (refer to examples on pp 175-179), 5.3-5.20
Due 11/2/15 5 pm

23-10/21

Ch 5.5-5.8
(ADbC Stored Proc/Trig)
Triggers Overview Homework: 5.21 (add this to the SQL homework above)

24-10/23

Moodle QUIZ 7
Ch 5.9
(ADbC Embedded SQL)
JDBC as Embedded SQL

JDBC Assignment
Due 11/4/15 8 am

Challenge with a query (group by) that would be tempting to do some calc in Java.

25-10/26

Ch 7.1-7.5 Object Data Model
Universal Modeling Language
Review: 7.3b,e

26-10/28

Ch 8.1-8.11
(ADbC Security)

DB Security

Homework: 8.1 a-d, 8.2 a-c

27-10/30

Ch 9.1-9.3
(ADbC Transactions)

Moodle QUIZ 8

ACID properties
Isolation in Transactions

 

28-11/2

File organizations and storage
Ch 9.4-9.6
  Revised relational schema due 11/10 4:00 p.m.

29-11/4

Ch 9.7-9.9 Recovery Atomicity and Durability
Review and more on file organizations
Homework: 9.1, 9.2, 9.5, 9.6, 9.7 (due Fri. 11/20)

30-11/6

  review and catch up  

31-11/9

EXAM 2 Chapters 5.6 - 8, A.1-A.2

 

 

32-11/11

Moodle QUIZ 9
Introduction to PHP
PHP Notes Write a PHP report against the project db and a simple table insert/update/delete as a kick start to the implementation

33-11/13

  Disk Organization
B-trees 
Hash Files
 

34-11/16

Ch 13 (early!) Query Optimization Overview
Sorting, Projection, Union, Difference
Selection and Join Computation
Homework: 13.1, 13.2, 13.4, 13.6a and 6b (for Faculty and Enroll relations only), 13.7d (due Tues. 12/1)

35-11/18

36-11/20

Ch 10.1-10.3 Distributed DB Overview  

37-11/23

Moodle QUIZ 10
Ch 10.4-10.7
Homework: 10.1, 10.3 (due 12/4)

38-11/30

Ch 14 early and sections omitted:
Ch 14.1-14.3, 14.6-14.7

Databases and the Internet
Overview of XML
Review: 14.1-14.12

39-12/2

Ch 11

OLAP and Data Mining

Homework 11.2,11.3 (due 12/9)

40-12/4

Moodle QUIZ 11
Ch 12
Hadoop and NoSQL Check out 12.1 as a resource

41-12/7

Ch 15

Social and Ethical Issues

 

42-12/9

Project presentations 10-12 minutes per group and/or review/catchup  

43-12/11

Project presentations 10-12 minutes per group Final project submission guidelines
12/11/15 8 am

12/14

FINAL 6:00-9:00 pm  Database Technologies Summary