Database Management Systems                  

IT 645 U

Summer 2008

Session I

 

 

INSTRUCTOR: Dr. Robert A. Donnelly

 

PHONE: (302) 225-6337 (Work)

 

E-Mail: bob@gbc.edu

 

HOMEPAGE: http://www.gbc.edu/~bob

 

OFFICE: G6, Graduate Office Suite, Lower Level of Fulmer Center

 

OFFICE HOURS:

5:00-5:30 PM

MW

Or by appointment

                       

 

TEXT: Database Systems: Design, Implementation, & Management, Rob and Coronel, 8th Edition, 2009

 

 

GRADING:

2 Exams

60%

Homework

15%

Access Projects

15%

Attendance

10%

 

Final grades will be posted on Blackboard when they are completed. It is the strict policy of Goldey-Beacom College not to release individual grades over the phone or by e-mail.

 

                       

COURSE DESCRIPTION

 

This course focuses on the managerial perspective of database information systems. The objective of this course is to introduce the key principles and activities associated with the design, use and administration of business databases. Topics such as data modeling and normalization will be examined in detail. Microsoft Access will be utilized to demonstrate the applications discussed in class.

 

 

 

HOMEWORK POLICIES

 

All assignments are due at the beginning of class as scheduled on the syllabus. The instructor reserves the right to reduce the grade or not accept late assignments out of fairness for the remainder of the class. Once the solution to a homework set has been reviewed in class, no late assignments will be accepted.  

 

All homework is to be done individually. Copying of computer files or hand-written assignments from one student to another is strictly prohibited.

 

Your homework assignments will be graded not only on their content, but also their appearance. I feel it’s important that you take pride in the work that you submit. It’s a reflection on the effort you have made to complete the assignment.

 

 

EXAM POLICIES

 

Exams will be closed book and closed notes.

 

I have a “zero tolerance policy” for cheating during exams. Any student caught cheating during an exam will receive an “F” grade for the course.

 

The use of cell phones or PDAs during the exam is strictly prohibited and will result in a zero grade.

 

I ask that you not wear a hat with a brim during the exam.

 

I ask that you do not leave the classroom while taking an exam. Leaving the classroom during an exam will result in the collection of your paper.

 

All exams must be taken during the scheduled times. No make-ups will be given except under unusual conditions, as judged by the instructor, and with prior notice. You must contact the instructor either in person, by e–mail or voice-mail before the scheduled exam. If a make-up exam has been arranged with the instructor, please note the following policies:

  • Since the student has more time to prepare for the make-up exam, it will be more challenging than the in-class exam.
  • The student will schedule a time to take the make-up with the ARC within one week of the scheduled exam.
  • The student will send the instructor an e-mail confirming this time.
  • Failure to take the exam at this time will result in a zero grade.

 

 

 

 

 

 

COMPUTER LAB POLICIES

 

On certain evenings, we will be spending time in Room 012, a computer lab across the hall from the main lab. Please do not bring any food or drink into the lab. Before leaving the lab, please be sure to shut down the computer you are using and place the chair under the desk.

 

 

 

RESPECTFUL LEARNING ENVIRONMENT

 

In order to promote and maintain a respectful and effective learning environment, I expect students to adhere to the following policies while in the classroom:

  1. Respect for each and every student is to be demonstrated in all interactions and communications at all times. 
  2. Personal, extraneous conversations should not take place during class time.
  3. Students are expected to make every reasonable effort to avoid arriving late for class. If students do arrive late, they are expected to quietly enter the classroom without disturbing the faculty or their fellow students.   
  4. No cell phones, headsets, or noise-making beepers or pagers are permitted in operation in the classroom setting.  Exceptions may be granted by individual faculty members.

Failure to adhere to these policies will result in the submission of a violation report form to the college administration.

 

 

 

 

 

ACADEMIC HONOR CODE

 

The Academic Honor Code System at Goldey-Beacom College is designed to promote academic honesty throughout the institution. This Honor Code document describes:

  1. How the College defines academic dishonesty.
  2. The procedures to be followed when a student has been cited for violations for the Academic Honor Code which includes the Respectful Learning Environment and the possible consequences of that action,
  3. The appeal process available to the student,
  4. Sanctions for repeat violations.

 

It is the responsibility of each and every student to fully understand the Academic Honor Code policy. Copies of this policy can be found on the college web site, the Academic Affairs Office, the Business Office, and the Student Affairs Office. As the Chair of the Academic Honor Code Committee, I take this policy very seriously and will fully enforce any penalties in regard to cheating. For instance, any student observed looking at another student’s work during an exam will receive a zero grade for that exam without exception.

 

 

GENERAL POLICIES

 

My expectations in the classroom are that you will be willing and able to ask questions about any course material that is not clear to you.  I look forward to questions during class time.  It indicates to me that the student is paying attention, has a desire to learn, and is helping his/her fellow students by having the courage to ask a question that others may also have. 

 

I also strongly encourage questions from students outside of class.  Please do not hesitate to take advantage of the office hours that I have scheduled. If these times are not convenient for you, we can schedule an appointment for some other time. I will do my best to make myself available for you outside of the classroom.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

                                                             IT 645 SCHEDULE

 

 

DATE

 

TEXT

 

DUE

 

May 14

 

 

Chap 1

Chap 2

 

Introduction to Course

Database Systems

Data Models

 

May 21

 

Chap 3

Chap 4

 

The Relational Database Model

Entity Relationship (ER) Modeling

Chapter 2 Homework Due

 

May 28

 

No Class

 

 

 

June 4

 

Exam 1

Chap 7

 

Chapters 1, 2, 3 and 4

Introduction to Structured Query Language (SQL)

Chapter 3 Homework Due

Chapter 4 Homework Due

 

June 11

 

Chap 5

Chap 9

 

Normalization of Database Tables

Database Design

Chapter 7 Homework Due

 

June 18

 

Chap 13

Chap 14

 

The Data Warehouse

Database Connectivity and Web Development

Chapter 5 Homework Due

Project 1 Due

 

June 25

 

Exam 2

 

Chapters 5, 7, 9, 13 and 14

Project 2 Due