Mount Saint Mary's University

Professor 

Bruce E Yelovich


IFSY/CS 355

 Database

Course Syllabus, Spring 2007
 


Syllabus, Schedule, Deadlines, Grading, Policies
 

Mount Home Page

 

Email Link

Campus Phone:
301-447-5820
 ext. 4242

Home Phone: 717-642-6395

Course Description

IFSY/CS 355 presents a study of the design, organization and implementation of database systems. Topics include file organization and processing; data modeling; CASE tools;  relational and object oriented databases; SQL; and, dynamic web design.

 
Resources:
  • Required Textbooks
    • Hoffer, J., Prescott, M., and McFadden, F. (2005). Modern Database Management, 7th ed. Upper Saddle River, NJ: Prentice-Hall.
      ISBN: 0-13-145642-3
    • Schmidt, K. and Weiss, N. (2003). Macromedia ColdFusion MX. Berkeley, CA: Macromedia Press.
      ISBN: 0-321-16224-2.
    • Visio Professional 2003: Basic. Course ILT. (2004) Boston: Thomson.
      ISBN: 1-418-84472-1.
  • Recommended Textbooks (On Reserve at the Library)
    • Whitlock, W., Nelson, K., and Papp, R. (2003).  Modern Database Management Casebook. Upper Saddle River, NJ: Prentice-Hall.
      ISBN: 0-13-061191-3
  • Internet Resources

 

Course Schedule and Deadlines at a Glance: Spring Semester, 2007
 
Week Week  Begins Content
Uploads Due
 		  
Week Ends
 
1 Monday,  January 15
1 AM
Introduction: Course Requirements, Methods and Policies

MS Visio Units 1 and 2
 		 MS Visio 1 and 2 Sunday,  January 21
12 Midnight
2 Monday,  January  22
1 AM
Hoffer/Prescott/McFadden.
Chapter 1: The Database Environment

MS Visio Units  3 and 4

Schmidt/Weiss
Chapter 1: Installing ColdFusion MX
 		 Hoffer/Prescott/McFadden
Chapter 1 Homework

MS Visio 3 and 4

Schmidt/Weiss
Chapter 1 Homework
 		 Sunday,  January  28
12 Midnight
3 Monday,  January  29
1 AM
Hoffer/Prescott/McFadden.
Chapter 2: The Database Development Process

MS Visio Units 5 and 6

Schmidt/Weiss
Chapter 2: Introducing Dreamweaver MX
 		 Hoffer/Prescott/McFadden
Chapter 2 Homework

MS Visio 5 and 6

Schmidt/Weiss
Chapter 2 Homework
 		 Sunday,  February  4
12 Midnight
4 Monday,  February  5
1 AM
Hoffer/Prescott/McFadden.
Chapter 3: Modeling Data in the Organization

MS Visio Unit  7

Schmidt/Weiss
Chapter 3: Variables and Functions
 		 MS Visio 7

Schmidt/Weiss
Chapter 3 Homework

 		 Sunday,  February  11
12 Midnight
5 Monday,  February  12
1 AM
Hoffer/Prescott/McFadden.
Chapter 3: Modeling Data in the Organization, con't.

Schmidt/Weiss
Chapter 4: Retrieving Data From Databases

 		 Hoffer/Prescott/McFadden
Chapter 3 Homework

Schmidt/Weiss
Chapter 4 Homework
 		 Sunday,  February  18
12 Midnight
6 Monday,  February  19
1 AM
Hoffer/Prescott/McFadden.
Chapter 4: The Enhanced E-R Model and Business Rules

Schmidt/Weiss
Chapter 5: Creating Search Forms

Whitlock/Nelson/Papp
Begin Project 1
 		 Hoffer/Prescott/McFadden
Chapter 4 Homework

Schmidt/Weiss
Chapter 5 Homework
 		 Sunday,  February  25
12 Midnight
7 Monday,  February  26
1 AM
No Lecture on Tuesday, February 27:
Work on Project 1 in Teams
Exam 1 (Weeks 1 - 6) : Thursday, March 1
 		 No work due Sunday,  March  4
12 Midnight
8 Monday,  March  5
1 AM
Spring Break
 		 No work due Sunday,  March  11
12 Midnight
9 Monday,  March  12
1 AM
Hoffer/Prescott/McFadden.
Chapter 5: Logical Database Design and the Relational Model

Schmidt/Weiss
Chapter 6: Building Data Entry Pages
 
Hoffer/Prescott/McFadden
Chapter 5 Homework

Schmidt/Weiss
Chapter 6 Homework
 		 Sunday,  March  18
12 Midnight
10 Monday,  March  19
1 AM
Hoffer/Prescott/McFadden.
Chapter 6: Physical Database Design and Performance
Schmidt/Weiss
Chapter 7: Creating Secured Pages
 
Hoffer/Prescott/McFadden
Chapter 6 Homework

Schmidt/Weiss
Chapter 7 Homework
 		 Sunday,  March  25
12 Midnight
11
Monday,  March  26
1 AM
 
Hoffer/Prescott/McFadden.
Chapter 7: Introduction to SQL
 		 Project  1: First Draft Sunday,  April  1
12 Midnight
12
Monday,  April  2
1 AM
 
Hoffer/Prescott/McFadden.
Chapter 7: Introduction to SQL, con't.

 Exam 2 (Weeks  7- 12) : Tuesday, April  3
 
Hoffer/Prescott/McFadden
Chapter 7 Homework

Schmidt/Weiss
Chapter 8 Homework
 		 Sunday,  April  8
12 Midnight
13
Monday,  April  9
1 AM
 
Hoffer/Prescott/McFadden.
Chapter 8: Advanced SQL

  Project 1:  Due Sunday, April 15
 		 Project  1: Final Draft Sunday,  April  15
12 Midnight
14
Monday,  April  16
1 AM
 
Hoffer/Prescott/McFadden.
Chapter 8: Advanced SQL, con't.


 
Hoffer/Prescott/McFadden
Chapter 8 Homework 		Sunday,  April  22
12 Midnight
15
Monday,  April  23
1 AM
 
Hoffer/Prescott/McFadden.
Chapter 9: The Client/Server Database Environment
 
Hoffer/Prescott/McFadden
Chapter 9 Homework 		Sunday,  April  29
12 Midnight
16
Monday,  April  30
1 AM
 
Hoffer/Prescott/McFadden.
Chapter 10: The Internet Database Environment

  Project  2:  Due Sunday, May 6

 
Hoffer/Prescott/McFadden
Chapter 10 Homework

Project 2		 Sunday,  May  6
12 Midnight
17
Monday,  May  7
1 AM
 
Final Exam  (Weeks 1- 16) :

 		 No Work Accepted Friday,  May  11
12 Midnight

Course Policies
  • All assignment are posted on the web portal in the Coursework section. Upload your files in one zipped archive each week when due by means of the Portal Coursework Complete Coursework button.
  • Assignments uploaded late:
    • Up to 1 week late: 75% of grade earned.
    • Up to 2 weeks late: 50 % of grade earned.
    • Over 2 weeks late: 0 % of graded earned (i.e., NO CREDIT).
  • Students should not hesitate to contact Professor Yelovich via telephone or email for help or tutoring.


Goals and Objectives
Grading

  • Distribution of Total Requirements 


    • Homework Assignments


      1740  points, (50       % of grade)
       


      Projects and Exams
       


      1740 points, (50       % of grade)

      Total
       
      3480        points, (100 % of grade)

 

  • Calculation of Letter Grade
     

    • A  = 93 – 100 %

      A- = 90 – 92 %

      B+ = 88 – 89 %

      B   = 83 – 87 %

      B- = 80 – 82 %

      C+ = 78 – 79 %

      C   = 73 – 77 %

      C- = 70 – 72 %

      D+ = 68 – 69 %

      D   = 63 – 68 %

      D- = 60 – 62 %

      F   =   0 – 59 %

 

© 2007 Bruce Yelovich