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 Spring 2017


Objectives 

Grading and Assignments 

Course policies 

Reading/
Homework
 

PostgreSQL Quick Ref. Teams Interactive Tutoring Vote Page

This page last changed 1-nov-16


Instructor:

Loren Rhodes
E-mail: rhodes@juniata.edu 
(preferred method of communication)
Office location and phone: C-208 BAC, (814) 641-3620 
Cell: 814-644-3309
(texts are ok regarding class attendance or emergencies)

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:

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).


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:

Previous year's exams are available for study. Links to study guides may be updated a few days before each exam. Bear in mind Spring 2017 is using a new edition and topic sequences are adjusted. You may need to look at both exams.

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-1/16

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

2-1/18

Ch 1 Exploring Access -- immersion into a simple PC-based database  Lab exercises 1.1
Due Friday, 1/20/17 8:00 a.m. to Moodle

3-1/20

Ch 2.1-2.5 Database Planning
Design Document (skim this)
Project Part I: Develop Specification Document for group project Due Friday, 1/27/17 8 am in hardcopy binder

4-1/23

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

5-1/25

Ch 2.7, 3.1-3.4
(ADbC->Database-> ER notations)
Entity-Relationship Model: Entities, Attributes, Keys
Dia Diagramming Lab
Due Mon. 1/30/17 5:00 p.m.

6-1/27

Ch 3.5-3.8
(ADbC->Database -> ER Scenarios)
Entity-Relationship Model: Relationships, Roles and Dependencies Review: 3.1
ER exercises 3.2, 3.3, 3.4
Due 2/1/17 8 am

7-1/30

Moodle QUIZ 2
Ch 3.9-3.12

Additional E-R Modeling Issues

Extended Entity Relationship Model

Project Part II: Draft ER diagram for group project--Due Monday, 2/6/17 5:00 p.m. For each entity in your ER, create a table of example data in CSV format. This will be used to initially populate your database.

8-2/1

Ch 4.1-4.4 Intro to the Relational Model

Review: 4.1-4.3

9-2/3

Ch 4.5
Moodle QUIZ 3 9/18
Relational Algebra Homework: Chapter 4 (due 2/10/17)

10-2/6

11-2/8

Ch 4.6-4.8
(ADbC->Database ->ER to Tables)
Mapping the ER model to Relational DB Presidential DB relational algebra subset of queries due 2/13/17
#3,6,9,11,14,16

12-2/10

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

13-2/13

Moodle QUIZ 4
Ch 6.5
(ADbC ->DB
->Normalization
Normal Forms Homework: 6.1, 6.2, 6.3 (follow link for notes) Due 2/17/17

14-2/15

Ch 6.6-6.9
(ADbC ->DB
->
Denormization. and
-> Anomalies)
Normalization Process
Decomposition Examples
 

15-2/17

Review and catch up    

16-2/20

EXAM 1 Chapters 1-4, 6

17-2/22

Ch 5.1-5.3
(ADbC ->SQL->
Interactive SQL

->Ref. Integrity)
SQL Data Definition
Revised ER diagram due Friday, 10/9/15
And updated Entity CSV files.

18-2/24

Project Part III: Relational schema project deliverables Due 3/2/17 3 pm
Adjust CSV files for actual relations; include relationship tables now.

19-2/27

Ch 5.4.1-5.4.3
Moodle QUIZ 5
SQL Query sublanguage

 

20-3/1

(ADbC ->SQL->
Interactive SQL

Presidents DB SQL
Due 3/3/17 8 am

#3,6,9,11,14,16,23,26,27

21-3/3

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

22-3/13

Ch 5.4.5
(ADbC ->SQL->
Interactive SQL)
Views Homework: 5.2 (refer to examples on pp 175-179), 5.4,6,8,9,10,12,15,18
Due 3/17/17 5 pm

23-3/15

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

24-3/17

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

JDBC Assignment
Due 3/24/17 8 am

25-3/20

Ch 7.1-7.5 Object Data Model
Universal Modeling Language
Project Part III: Revised relational schema due 3/20/17 4:00 p.m.
Review: 7.3b,e

26-3/22

Ch 8.1-8.11
(ADbC Security)

DB Security

Homework: 8.1 a-d, 8.2 a-c

27-3/24

Ch 9.1-9.3
(ADbC Transactions)

Moodle QUIZ 8

ACID properties
Isolation in Transactions

 

28-3/27

Ch 9.4-9.6  

29-3/29

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. 4/7/17)

30-3/31

Moodle QUIZ 9 review and catch up  

31-4/3

EXAM 2 Chapters 5, 7, 8, 9

 

 

32-4/5

Introduction to PHP PHP Notes Write an interactive PHP report against the project db and a simple table insert/update/delete as a kick start to the implementation. Due 4/12/17 8 am

33-4/7

Overview of internal data structures (class notes only) Disk Organization
B-trees 
Hash Files
 

34-4/10

Ch 13 (early!)
Moodle QUIZ 10
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. 4/18/17)

35-4/12

36-4/14

no class Distributed DB Overview  

37-4/17

Ch 10.1-10.3
Ch 10.4-10.7
Homework: 10.1, 10.3 (due 4/21/17)

38-4/19

Ch 11

Data Warehousing and Data Mining

 

39-4/21

Moodle QUIZ 11
Homework 11.2,11.3 (due 4/26/17)

40-4/24

Ch 12 Big Data and NoSQL Review: 12.1,3,5,7,9

41-4/26

Ch 14-15

Databases and the Internet
Overview of XML

Social and Ethical Issues

Review: 14.1-14.12

42-4/28

Moodle QUIZ 12
Review and Catch up
 Database Technologies Summary
 

43-5/1
7:30 - 8:50

Project presentations 8-10 minutes per group Final Project Functional Proof of Concept Completion submission guidelines
5/1/17 7:30 am

TBA

FINAL