Database Management Systems
CS 370

FALL 2014 SYLLABUS

Fall 2010 | Fall 2011 | Fall 2012 | Fall 2013


Objectives 

Grading and Assignments 

Course policies 

Reading/
Homework
 

PostgreSQL Quick Ref. Teams Interactive Tutoring Vote Page

This page last changed 3-dec-14


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 2nd Ed., Catherine Ricardo, Jones and Bartlett, 2012 (ISBN 978-1-4496-0600-8)

Recommended texts and 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:

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

Study Guides 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 Fall 2005 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 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. Multiple teams may do the same project and the instructor will designate which of the projects may be selected for the semester. Not all projects will be implemented by the class.

 


Course policies

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

Disabilities Policy

The Americans Disabilities Act mandates accessibility in all aspects of the learning environment.  If you have an identified disability and are in need of specific accommodations, please notify the Office of Academic Support Services in Founders Hall and discuss your needs with me at the beginning of the semester.


DATABASE MANAGEMENT SYSTEMS
FALL 2014 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 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.

Class-
Date

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

1-8/29

Ch 1 Intro concepts
Introduction and Overview
Review: 1.1-1.9

2-9/1

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

3-9/3

Ch 2.1-2.5 Database Planning
Design Document (skim this)
Develop Specification Document for group project Due Fri. 9/12/14 8 am

4-9/5

Ch 2.6
Moodle QUIZ 1
Database Architecture Review: 2.1-2.28

5-9/8

Ch 2.7, 3.1-3.4
(ADbC ER notations)
Entity-Relationship Model: Entities, Attributes, Keys
Diagramming Lab ex 2.1
Due Wed. 9/10/14 8 am

6-9/10

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/19/14 8 am (book pages)

7-9/12

Moodle QUIZ 2
Ch 3
Additional E-R Modeling Issues Draft ER diagram for group project--Due Monday, 9/22/14 5:00 p.m.

8-9/15

Ch 4.1-4.4 Intro to the Relational Model

Review: 4.1-4.3

9-9/17

Ch 4.5
Moodle QUIZ 3 9/19
Relational Algebra Homework: Chapter 4 (due 9/26/14)

10-9/19

11-9/22

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

12-9/24

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

13-9/26

Moodle QUIZ 4
Ch 6.5
Normal Forms  

14-9/29

Ch 6.6-6.8
(ADbC Normalization Denorm. and Anomalies)
Normalization Process Homework: 6.1, 6.2, 6.3 Due 10/8/14

15-10/1

Review and catch up    

16-10/3

EXAM 1 Chapters 1-4, 6

17-10/6

Ch 5.1-5.3
(ADbC SQL)
(ADbC Ref. Integrity)
Decomposition Examples Revised ER diagram due Friday, 10/10/14

18-10/8

SQL Data Definition

Relational schema project deliverables Due 10/25/14 5 pm

19-10/10

Ch 5.4.1-5.4.3
Moodle QUIZ 5
SQL Query sublanguage

 

20-10/13

(ADbC SQL)
Presidents DB SQL 2-28 evens
Due 10/30/14 5pm

21-10/15

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

22-10/17

Ch 5.4.5
(ADbC SQL)
Views Homework: 5.2-5.20
Due 11/3/14 8 am

23-10/20

Ch 5.5-5.7
(ADbC Stored Proc/Trig)
Triggers Overview Homework: 5.21

24-10/22

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

JDBC Assignment
Due 11/5/14 8 am

25-10/27

Ch 7.1-7.4 Object Data Model
Universal Modeling Language
Review: 7.3, 7.4

26-10/29

Ch 8.1-8.7 Extended Entity Relationship Model Review: 8.1-8.3
Review: 8.4, 8.5ab

27-10/31

Moodle QUIZ 8
Introduction to PHP
PHP Notes  

28-11/3

File organizations and storage Disk Organization
B-trees 
Hash Files
Revised relational schema due 11/5 4:00 p.m.

29-11/5

  Review and more on file organizations  

30-11/7

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

31-11/10

Ch 9
(ADbC Security)
DB Security Homework: 9.1 a-d, 9.2 a-c
(Friday 11/14/14)

32-11/12

Ch 10.1-10.3
(ADbC Transactions)
ACID properties
Isolation in Transactions
Review: 10.1, 10.2, 10.4, 10.5

33-11/14

Moodle QUIZ 9
Ch 10.4-10.6
Review: 10.6, 10.7, 10.9, 10.10, 10.13

34-11/17

Ch 10.7-10.9 Recovery Atomicity and Durability Homework: 10.1, 10.2, 10.5, 10.6, 10.7 (due Fri. 11/21)

35-11/19

Ch 11 Query Optimization Overview
Sorting, Projection, Union, Difference
Selection and Join Computation
Homework: 11.1, 11.2, 11.4, 11.6a and 6b (for Faculty and Enroll relations only), 11.7d (due Tues. 12/2)

36-11/21

Ch 12.1-12.3 Distributed DB Overview  

37-11/24

Moodle QUIZ 10
Ch 12.4-12.6
Homework: 12.1, 12.3 (due 12/5)

38-12/1

Ch 13.1-13.3, 13.6-13.7 Databases and the Internet
Overview of XML
Review: 13.1-13.12

39-12/3

Ch 14 Social and Ethical Issues Review: 14.1

40-12/5

Moodle QUIZ 11
Ch 15
OLAP and Data Mining Review: 15.1
Homework 15.2,15.3 (due 12/10)

41-12/8

Miscellaneous

Hadoop and NoSQL

 

42-12/10

Project presentations 12-15 minutes per group  

43-12/12

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

Per finals schedule

FINAL  Database Technologies Summary