Database Design and Applications for Business

Fall 2010

Professor:  Dr. Margaret R. Garnsey

Office:  Siena Hall 433

Phone:  783-2397


Office Hours:  Office Hours:  Mon., Wed., and Fri. 8:15AM – 9:15AM and 10:30PM – 11:25PM or by appointment

Text:    Database Processing, 11th edition  by, David Kroenke & David Auer,  Prentice Hall, 2010. 


Note:  The course is up on Blackboard (  The syllabus and tentative schedule are on the site at this time, and you are expected to check Blackboard and your email frequently for announcements, etc.




The concept of academic integrity lies at the very heart of any college. This is particularly true of Siena with its strong Franciscan tradition and its dedication to fostering sound moral growth. In such an environment, academic dishonesty cannot be tolerated. Students who commit such acts expose themselves to punishment as severe as dishonorable dismissal from the college.

Academic dishonesty can take several forms, including, but not limited to, cheating [dishonesty in a test situation], plagiarism [dishonesty in the presentation of materials in a paper or report], and computer abuse. All work you submit for this course must be entirely your own. Although students are encouraged to study together, you are required to produce your own solutions to all work you submit (including, obviously, exams). In any situation in which a student is unsure what constitutes academic dishonesty, it is the student’s responsibility to raise the question with his or her instructor. It is also the student’s responsibility to be familiar with the student guidelines on academic dishonesty, “Academic Integrity and the Siena Student” and to read the Computer Science department’s Academic Integrity web page,


The student is expected to be comfortable with working on a PC and to be generally familiar with the Windows office suite of products.


The student should be able to:

  1. Communicate comfortably and intelligently with systems professionals.
    1. To understand and be able to use an Entity – Relationship diagram to conceptually describe a database.
    2. To be able to effectively translate an E-R diagram into a relational schema
  2. Develop specifications for business systems using structured systems analysis and design.
  3. Analyze a relational schema and normalize it if necessary.
  4. Use query languages to produce desired results.
  5. Understand some of the common applications of database systems, including various ways of making the data available to users.
  6. Understand enough of how a DBMS works to make informed decisions regarding the various tradeoffs available in database design

Teaching Methodology:

  1. Lectures on each topic incorporating illustrations and examples to enhance understanding.
  2. Class exercises and participation.
  3. Discussion of assignments and projects.

Course Requirements:

  1. If I need to get a message to you or make any announcements outside of class I will use e-mail and/or Blackboard, so you are expected to monitor these frequently.
  2. Students are expected to attend all classes. The teacher reserves the option that any student missing more than 2 classes will have their final grade dropped by a full letter grade and any student missing more than 3 classes will fail the course.
  3. Students are expected to read the assigned chapters prior to class. Students must complete a chapter exercise prior to the first class to be taught on a chapter. This class format requires you to be prepared for each class. This is very important, and your classmates and I will be counting on you to have read the assignments!
  4. Power point slides used in the class are available on Blackboard. Students are strongly encouraged to print out the slides prior to the classes they pertain to.
  5. Homework: There will be 6 homework assignments, roughly one every two weeks. The lowest of your homework grades will be ignored. Some of the assignments will be written and some will also involve using the computer. Nothing late will be accepted for grading unless there is an illness or situation that can be documented. Written excuses (e.g., a note from a doctor) are required
  6. Projects: These are longer-term database design and implementation activities in which you will have the opportunity to use a wide range of skills to take a database through its various phases (conceptual design, relational implementation, queries, etc.). Nothing late will be accepted for grading unless there is an illness or situation that can be documented. Written excuses (e.g., a note from a doctor) are required.
  7. Exams: All exams will be closed-book and cumulative. The first two will be held during a scheduled class period.
  8. Course Accounts: These will be given to you later in the semester for the use of the Access relational DBMS and possibly other uses.
  9. Grading:

The course grade will be a weighted average based upon the following percentage weighting factors:

Exam 1 14%
Exam 2 14%
Final Examination 17%
Homeworks 25%
Beg of Chap Exercises 5%
Projects 20%
Class participation 5%

Final Grades:

A 90% or above
B -/+ 80 to 89
C -/+ 70 to 79
D 60 to 69
E below 60


There are no curves or extra credit in this course. Plus and minus grades will be given to those students who either just missed the next grade or who were very close to dropping down to the next letter grade.


Week of



9/6 (Wed, Fri only)

Introduction, Introduction to SQL

1, 2


Introduction to SQL



Intro. to SQL, Data Modeling with the E-R model

2, 5


Data Modeling with the E-R model



Transforming Data Models into DB Designs


10/11 (Mon, Wed only)

Review for Exam 1,  EXAM 1



 The Relational Model and Normalization



Database Design using Normalization

3, 4


SQL for Database Construction and Application Processing (Additional SQL statements UNION, EXISTS)



DB Processing for Business Intelligence Systems



DB Processing for Business Intelligence Systems


11/22 (Mon only)




Multiuser Database Processing



Multiuser Database Processing, Database Processing with XML (if time permits)

9, 12

12/13 (Mon, only)




Comprehensive Common Final




Links to learning goals

            Siena Mission and Learning Goals (Siena Mission and Learning Goals)

            Schools’ Mission and Learning Goals (Mission Statements/Learning Goals)



Links to College Policies

*Academic integrity policy (Academic Integrity)
*Accommodations policy (
Policies and Forms)

*Emergency preparedness (Emergency Info)

*Attendance policy (Attendance Policy)

*Cell phone use (Cell Phone Policy)

This is an unofficial Siena College Webpage - The ideas and content expressed on this page are not necessarily those of the college.