GBIS 741 – BUSINESS DATABASE SYSTEMS

Fall 2008

COURSE OUTLINE

 

Instructor

 

            Runa Bhaumik

 

Phone

             

             Cell: 708-567-2467

 

E-MAIL

            rbhaumik@dom.edu

 

 

COURSE DESCRIPTION

 

This course introduces the basic knowledge needed to analyze, evaluate, design, administer, implement and maintain database systems in business.  Emphasis is placed on database and information resource management in an organization.  Topics include fundamental concepts of business database systems, different data models, database schemas, data integrity the role of databases as a means for managing data resources, database reporting, data normalization, and the role of databases in decision making in business.

 

Expected Learning Outcomes: Student should be able to

·          Understand user views and requirements

·          Evaluate existing and future data needs

·          Create an enterprise data model that accurately reflects the organization’s fundamental business rules

·          Develop and modify the conceptual data model, including all entities, relationships, attributes, and rules

·          Merge database views into the conceptual model

·          Apply normalization techniques

·          Structured Query Language (SQL)

·          Identify and act on data integrity and security requirements

 

 

 

PREREQUISITES

            GBIS 703 or GBIS 710 or equivalent. 

 

TEXTBOOK(Recommended)

            Modern Database Management

Edition: 8th Edition

            Author(s): Hoffer, Prescott & McFadden

            ISBN: 0-13-221211-0

            Publisher: Prentice-Hall

 

SOFTWARE:  SQL Server 2005, MSAccess

 

GRADING

Assignments	40%
Exam	20%
Final Project	30%
Attendance & Class Participation	10%

 

The final letter grade assigned will be based on the scale:

A:	93-100%
A-:	90-92.9%
B+:	87-89.9%
B:	80-86.9%
C+:	77-79.9%
C:	72-76.9%
C-:	70-71.9%
D:	60-69.9%
F:	0-59.9%

 

 

 

 

 

 

 

 

 

 

Late assignments will be penalized by 10% each day beyond the due date/time up until one week after the due date. No points will be awarded to assignments submitted later than one week after the due date.  Sorry, NO EXCEPTIONS!

 

  Students who miss a class are responsible for obtaining notes from a classmate on what exactly was covered in the class.  The instructor does not use lecture notes for all of her topics and so it is not available for students.  It is also the responsibility of the student to find out what assignments were distributed.  The course website at http:blackboard.dom.edu can aid in this process.  Absence from class is NOT a valid reason for late assignments.  Assignments received after the due date and time are considered late, regardless of absence, in fairness to the other students in the class.

 

All assignments are to be completed by one person individually.  There is no group work in this course.  Group work on assignments results in zero points being awarded to all members of the group.  Unauthorized group work is also considered cheating and will be reported to the Dean of the School of Business.

 

ATTENDANCE & CLASS PARTICIPATION

Attendance is required.  While there may be times when absences cannot be avoided, attendance is required to fully grasp class content. Class participation is critical to enhance the learning experience of all students.  Therefore, attendance & participation earn 4% of the total grade. 

 

 

This is a tentative schedule that is subject to change.