Database Management Systems
CS 370 - IT 376

FALL 2013 SYLLABUS

Fall 2004 Syllabus | Fall 2005 | Fall 2007 | Fall 2008 | Fall 2009| Fall 2010 | Fall 2011 | Fall 2012


Objectives 

Grading and Assignments 

Course policies 

Reading/
Homework
 

PostgreSQL Quick Ref. Teams Interactive Tutoring Vote Page

This page last changed 4-nov-13


Instructor:

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

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:

  • PostgreSQL Reference Documentation (use on-line --please don't print)
  • Any elementary Java or C++ programming text will serve as a language reference.
  • A Student's Guide to Unix, Hahn, 2nd Edition, or
    Just Enough Unix, Anderson, 4th or 5th Edition, or any other simple reference to Unix systems.
  • PHP reference http://www.php.net/manual/en/

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

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 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 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
 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 2013 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  Topics/
Lecture Links
Homework/
Programs/Exercises 

1-8/23

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

2-8/26

Ch 1 Exploring Access  Lab exercises 1.1
Due 8/28/13 8:00 a.m. to Moodle

3-8/28

Ch 2.1-2.5 Database Planning
Design Document
Develop Specification Document for group project Due Fri. 9/6/13 8 am

4-8/30

Ch 2.6 Database Architecture Review: 2.1-2.28

5-9/2

Ch 2.7, 3.1-3.4 Entity-Relationship Model: Entities, Attributes, Keys Diagramming Lab ex 2.1
Due Wed. 9/4/13 8 am

6-9/4

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

7-9/6

Ch 3 Additional E-R Modeling Issues Draft ER diagram for group project--Due Monday, September 16 8:00 a.m.

8-9/9

Ch 4.1-4.4 Intro to the Relational Model

Review: 4.1-4.3

9-9/11

Ch 4.5 Relational Algebra Homework: Chapter 4 (due 9/18)
Presidential DB (relational algebra subset of queries due 9/23)

10-9/13

11-9/16

Ch 4.6-4.7 Views and Mapping the ER model to Relational DB  

12-9/18

Ch 6.1-6.4 Functional Dependencies  

13-9/20

Ch 6.5 Normal Forms  

14-9/23

Ch 6.6-6.8 Normalization Process Homework: 6.1, 6.2, 6.3 Due 10/2/13

15-9/25

Review and catch up    

16-9/27

EXAM 1 Chapters 1-4, 6

17-9/30

Ch 5.1-5.3 Decomposition Examples Revised ER diagram due Friday 10/4

18-10/2

SQL Data Definition

Relational schema project deliverables Due 10/16/13 8 a.m.

19-10/4

Ch 5.4.1-5.4.3 SQL Query sublanguage

Presidents DB SQL 1-27 odds
Due 10/18/13 9 am

20-10/7

Ch 5.4.4 Modifying Relations in SQL  

21-10/9

Ch 5.4.5 Views Homework: 5.2-5.20
Due 10/23/13 8 am

22-10/14

Ch 5.5-5.7 Triggers Overview Homework: 5.21

23-10/16

Ch 13.5 JDBC
Embedded SQL

JDBC Assignment
Due 10/30/13 8 am

24-10/18

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

25-10/21

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

26-10/23

Introduction to PHP

PHP Notes

 

27-10/25

File storage

Disk Organization
 

28-10/28

File organizations B-trees 
Hash Files
Revised relational schema due 10/31 4:00 p.m.

29-10/30

  Review and more on file organizations  

30-11/1

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

31-11/4

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

32-11/6

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

33-11/8

Ch 10.4-10.6 Review: 10.6, 10.7, 10.9, 10.10, 10.13

34-11/11

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

35-11/13

Ch 11 Query Optimization Overview
Sorting, Projection, Union, Difference
Selection and Join Computation
Homework: 11.1, 11.2, 11.5, 11.6, 11.7 (due Wed. 12/4)

36-11/15

Ch 12.1-12.3 Distributed DB Overview  

37-11/18

Ch 12.4-12.6 Homework: 12.1, 12.3

38-11/20

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

39-11/22

Ch 14 Social and Ethical Issues Review: 14.1

40-11/25

Ch 15 OLAP and Data Mining Review: 15.1
Homework 15.2,15.3

41-12/2

Miscellaneous

NoSQL slide presentation
Hadoop

 

42-12/4

Project presentations 12-15 minutes per group  

43-12/6

Project presentations 12-15 minutes per group Final project submission 12/6/13 8 am

Per finals schedule

FINAL  Database Technologies Summary