SELLINGER SCHOOL OF BUSINESS AND MANAGEMENT
Spring 2003

Course: GB 756.61 Database Design & Implementation
Tuesdays 6:30 PM - 9:00 PM
Loyola Graduate Center Timonium - Room 37
Instructor: Lawrence E. Burgee, M.B.A., M.S.
Visiting Professor
eMail: LBurgee@loyola.edu
Tel: 410-617-2980, Fax: 410-617-1518
Office: Sellinger Hall Room 308
Instructor Website: www.burgee.com/loyola
Course Website: www.loyola.edu/blackboard (GB756.61-03-SP)
Office Hours: Tuesdays & Thursdays 2:00 PM - 3:00 PM; and by appointment.
Required Text: Modern Database Management, Sixth Edition,
J.A. Hoffer, and M.B. Prescott, F.R. McFadden, Prentice Hall, 2002, ISBN# 0-13-039375-4 (bundled with Oracle9i Software)
Other Materials: Additional reading materials may be provided periodically by the instructor to supplement the text and to illustrate real-world applications of the concepts discussed in class. Students may also be required to visit Internet websites and the Loyola library for additional information. Students must also have access and be familiar with using Blackboard.

You must have access to Microsoft Access XP/2002 (in Loyola labs and classrooms). We will also use the Personal Oracle 9i that comes bundled with the textbook.

Course Description (from Loyola Catalogue):

Provides an analysis of database systems within the broader scope of information systems. An intensive, introductory course in database design concepts that includes the building and using of systems. The roles of the database as a corporate resource and the role of the database administrator as the steward of that resource are examined. Management issues such as security, efficiency, and effectiveness are included. The relational model is used as the paradigm for theory and practice. Both Oracle's SQL and Access' QBE provide a great deal of hands-on activity.

Course Objectives:

Upon completion of this course you will be able to:

  1. Describe and identify the elements of a database system;
  2. Discuss the advantages of the database approach over traditional file structures;
  3. Effectively use Structured Query Language (SQL);
  4. Effectively use a Query by Example (QBE) system;
  5. Translate user information needs into database constructs;
  6. Normalize database design structures;
  7. Understand the technical aspects of database administration including data security, data integrity, and data backup;
  8. Be proficient at an introductory level with Microsoft Access, Oracle, and other database and data management tools; and
  9. Understand the basic concepts of data warehousing.

Course Requirements:

Exams

There will be two examinations as part of the course requirements. Exam I will be held in the middle of the semester, in-class, and will consist of short answer questions, essays, case analyses, and design exercises. Exam II is take-home, open book, and will be due at the beginning of the last class meeting. See the Class Schedule for actual dates.

Unexcused absence from an examination will result in a zero (0) grade for that exam. Make-up exams will be given only if the student’s absence has been excused by the instructor in advance. In cases of illness, a written excuse from the physician will be required.

Homework Assignments & Project

There will be 4-8 homework assignments to be completed throughout the semester. They will be weighted according to my assessment of their difficulty and importance. Instructions for assignments will be given 1-3 weeks before the due date. In some cases, students will be asked to present their solutions to homework problems in class. Such a presentation, however, is not evaluated as part of the homework grade, but as part of the class participation grade (see below). Homework will be collected at the beginning of class on the due date.

The final assignment will be in the form of a project. All students will present their project to the class at the final class meeting. Project guidelines will be distributed well in advance of the due date.

Current Topic Report

Once during the semester, each student will prepare a current topic report on the database management topic of his/her choice. The assignment will consist of a written report and a brief oral presentation. The purpose of these presentations is to expose the class to a variety of relevant database management issues as reported in Web-based or traditional (magazines, newspapers, journals, etc.) sources. A presentation schedule will be developed early in the semester.

Class Participation

Class participation is comprised of multiple subjective and objective activities. These activities have been diversified to address student ability and interest. Subjective activity is your contribution to the class discussions based upon readings and various class exercises. This contribution can take the form of asking thought provoking questions or providing examples of concepts discussed in class. Objective activity is primarily based on your completion of in-class exercises and discussion of homework assignments. There will be approximately 10-12 of these activities worth 5-15 points each. Most of the participation activities will be graded on a pass/fail basis.

Attendance is expected and it is not possible to make up class work missed due to absence. The only exceptions to this rule will be for documented (doctor's note, etc.) cases of severe illness or other arrangements made with the instructor in advance of the absence. Please refrain from eating during class as this is highly disruptive. Drinks (particularly with caffeine) are fine. Kindly turn off cell phones and pagers. Repeated lateness to class will negatively affect your participation grade.

Grading:

The breakdown of points to determine your grades is as follows:

Exam I 175 points
Exam II 175 points
Homework Assignments & Project 400 points
Current Topic Report 100 points
Class Participation - Subjective 50 points
Class Participation - Objective 100 points
Total 1000 points

Grades will be given on the basis of the following final point totals:

A 930 points and above
A- 900-929 points
B+ 870-899 points
B 830-869 points
B- 800-829 points
C+ 770-799 points
C 730-769 points
C- 700-729 points
F Less than 700 points

Notes:

  1. Graded exams and assignments may be retained by the instructor for future reference.
  2. You are responsible for all material covered and any announcement made in any class session, whether you are present or not.
  3. It is possible that certain components of Class Participation will be substituted as opportunities present themselves.

Class Cancellation Policy:

If a class is cancelled for any reason, an alternate assignment will be posted on Blackboard in the Assignments area by 12:00 PM on the following day. The assignment will be due at the next class meeting. If bad weather is expected, please call the Loyola Inclement Weather Hotline on x2223.

Honor Code:

All students of the College are expected to understand the meaning of the Loyola College Honor Code. Ignorance of the Code is not a valid reason for committing an act of academic dishonesty. The following will constitute violations of the Code and are defined in the Community Standards Handbook: cheating, stealing, lying, forgery, plagiarism, and the failure to report a violation.

 
   

CLASS SCHEDULE

 
Week Date Topics Text
1 Jan. 14 The Database Environment
Course Introduction
Chapter 1
2 Jan. 21 Database Development Process Chapter 2
3 Jan. 28 Modeling Data in the Organization Chapter 3
4 Feb. 4 The Enhanced E-R Model and Business Rules Chapter 4
5 Feb. 11 Logical Database Design and the Relational Model Chapter 5
6 Feb. 18 Physical Database Design and Performance Chapter 6
7 Feb. 25 Exam I  
  Mar. 4 No Class - Spring Break!  
8 Mar. 11 SQL Chapter 7
9 Mar. 18 Advanced SQL Chapter 8
10 Mar. 25 The Client/Server Database Environment Chapter 9
11 Apr. 1 The Internet Database Environment Chapter 10
12 Apr. 8 Data Warehousing Chapter 11
13 Apr. 15 Data and Database Administration Chapter 12
14 Apr. 22 Project Presentations
Project Due
Exam II Distribution
 
15 Apr. 29 Exam II Due 6:30 PM