Computer Information Systems

Department

Home
Contact CIS
Robinson
Georgia State

 
 

About CIS

Academic Programs

       BBA CIS
       MBA IS
       MISAC
       MS IS
       MS IS MIT (1 year)
       PHD CIS
       EXECUTIVE Education

Certificates

Business Corner

Faculty & Research

Faculty

Research

News

Student Info

CIS Alumni

CIS Internship

 

Driving Directions

 
 
 

CIS 3730 - Database Management Systems

Prerequisites:

CIS 2010. CSP: I, IV (Refer to GSU Catalog) Prerequisites are STRICTLY ENFORCED!

Texts & Courseware

Hoffer, Jeffrey A., Prescott, Mary B. & McFadden R. Fred, "Modern Database Management", Sixth Edition, Prentice Hall, 2002, ISBN 0-13-033969-5

Course Objectives:

Upon completion of the course, each student will be able to:

--         Understand terms related to database design and management
--          Understand the objectives of data and information management
--          Understand the database development process
--        Understand the relational model and relational database management system
--          Assess data and information requirements
--         Construct conceptual data models
--          Develop logical data models
--          Evaluate the normality of a logical data model, and correct any anomalies
--          Develop physical data models for relational database management systems
--          Implement relational databases using a RDBMS
--          Retrieve data using SQL
--          Understand database performance issues
--          Understand the basics of data management and administration
--          Understand the basics of data warehousing
--          Work as a valuable member of a database design and implementation team.

Course Philosophies & Policies

Assignments

Instructions on submitting assignments will be given with the assignment. 

All work completed outside of class must be typed (word processed) or prepared using diagramming software. You will be able to prepare all required diagrams using Visio, Word or Powerpoint. 

The professionalism of your work will count towards your grade.  This includes spelling and grammar. 

All work is due at the date and time specified. There is a 10% penalty per day or portion of a day that the work is late.  Work that is more than 48 hours late will not be accepted without prior approval. 

Hardware failure or inaccessibility is not a valid excuse for late work. This means that if you lose your assignment or if the labs are full or if you do not have internet access you will not be excused from handing in an assignment on time.

Attendance

Class attendance is expected, anticipated and rewarded. The instructor is not a policeman and will not “excuse” anyone from class. All classes are important; therefore one cannot “make up” the experience of a class (see Participation).

Bonus Points

There will be NO bonus points beyond the 150 course points identified in this syllabus. (See Grading)

Canceled Classes

If classes are “canceled by the University,” be prepared to cover both the missed and current reading assignments at the next scheduled class meeting.

Class Disruption

Do not disrupt, distract or prevent others from learning by arriving late, leaving early or failing to turn off all electronic devices during the scheduled class. (Laptop computers used for taking notes being the exception to this rule.)

Communication

All messages will be broadcast to the class electronically through the WebCT bulletin board. Students may respond to messages/questions on the class bulletin board or chat room. Anyone may send the instructor WebCT e-mail messages and the instructor will reply electronically to the student’s WebCT account, in class, or both. It is important that everyone check their WebCT account regularly for questions, replies, corrections, and news.

Curve

There will be NO curving of grades in this class section. Cut off points are strictly adhered to.

Database Project

For the course project, students, working in groups of three or four, will prepare a fully functioning database system, of significant complexity, including both a logical and conceptual model of the organization.  The complete specifications for the projects will be covered in a separate handout.

Exams

Two (2) exams will be given based on course materials from lectures, overheads, and assigned readings. Failure to turn in either the exam and/or answer sheet will result in a zero (0) for the exam grade. 

Extra Credit

There will be NO extra credit beyond the 150 points identified in this syllabus. The instructor feels giving extra credit is not fair to the rest of the class, especially those who do their work and turn it in on time. (See Grading) 

Grading

 Weighting is tentative. Please note that cut off points are strictly adhered to.

Activity

Percent

Percent

Grade

Midterm

30

=>90

A

Final

30

=>80

B

Homework Assignments

 

=>70

C

ER modeling assignment

15

=>60

D

SQL assignment #1

15

  <60

F

Team Project

30

 

 

Surveys (5)

15

 

 

Participation

 

 

 

     ER Modeling In Class Assignment

5

 

 

     Normalization In Class Assignment

5

 

 

     SQL In Class Lab

5

 

 

TOTAL

150

 

 

 

 

 

 

 

 

 

 

 Incomplete

A student who, due to exceptional circumstances (e.g., death in immediate family or hospitalization), has a passing grade (C or better) and cannot complete the course (all but ONE assignment) may qualify to receive a grade of “I” (see General Catalogue p. 48).

Learning Disabilities

Students with special needs that have been certified by the Disability Services office must notify the instructor immediately in order for accommodation to be made in WebCT and instruction.

Make-Ups

NO make-ups will be given. It is impossible to create an equivalent experience without placing the student at either an advantaged or disadvantaged status.

Oracle Software

Oracle 8i will be the database management system used for instruction and assignments.  Oracle 8i is available in the computer labs. Students may also install Oracle 8i personal edition for use on their own computers. 

Oracle 81 personal edition is available for download free of cost from Oracle’s website at http://otn.oracle.com/software/content.html.  You must first create a user account before downloading. 

To create a user account go to: https://profile.oracle.com/jsp/reg/RegisterUser.jsp?act=5&src=1180585&language=en&tid=480&owner=1.  Instructions for installing Oracle after downloading are available on the WebCT bulletin board.

Participation

The instructor encourages everyone to participate in class activities, discussions, and respond to questions from other students. This type of class interaction will guarantee maximum points for participation. Participation points are based on:

1.

Attending the entire class and completing in-class assignments,

2.

Being prepared to participate, and

3.

Asking and responding to questions.

Reading Assignments

Reading assignments relate directly to the material to be covered in class and should be completed prior to the class for which they are assigned.

Reassessment

If a request is made for any scored material to be reassessed, please recognize that it will be possible to retain, gain, or lose points in the reassessment process. Make any reassessment requests by WebCT e-mail within one (1) week of grading. Please make a follow-up appointment (preferably by WebCT email) to meet the instructor during office hours for review of the results of any reassessment.

Research Days

The instructor will not be available to assist or support students on the weekends (Saturday & Sunday) or the days set aside for research. (See page 1)

Religious Observation

If anyone will miss any class(es) because of religious observations, consult with the instructor before the end of the second week of class by WebCT e-mail.

Review of Materials

All materials will be retained for one (1) month after the start of the following term for review or grade appeal. Contact the instructor for an appointment to review.

Sample Class

Class sessions will be divided between: (1) lecture on database theory /discussion of certain database software concepts and features, (2) instructor demonstrations of these same software concepts and features, and (3) student laboratory sessions working with these same software concepts and features.

The purpose of this pedagogical approach is to introduce and reinforce ideas and skill sets so that students can master these on their own after class hours. To bring this knowledge to a highly proficient, professional level, students will have to spend time and effort outside of class working in the GSU computer labs or on their own micros.

To ensure that you have the basic knowledge that will allow you to function on your own after class, be sure to ask the instructor questions during class, either during the lecture/discussion, demo, or lab.  

Solutions

Solutions to exams, and projects are available for review during office hours or by appointment. Solutions will be shared with the class during a class review, but will not be posted as these represent a student’s intellectual property.

Surveys

Five surveys will be taken throughout the semester to review preparedness and to give feedback on course instruction. The survey is not anonymous, but necessary to improve course delivery in a timely manner. The surveys will count one (3) points each when all questions are answered.  

Surveys are due the following Sunday at 11:55pm after they have been released. 

Syllabus

Read and study this syllabus carefully. This is a contract between the instructor and student, which lays out the responsibilities of both parties. If there are questions, consult with the instructor before the end of the second week of class by WebCT e-mail.

Teaching Philosophy

An educated person is one that can think critically. This person can explain complex ideas simply and accurately. Therefore, do not memorize material but look for patterns in the material. Critical thinking should lead to simple and elegant solutions. 

Technology

GSU requires all students to have an e-mail account and to have access to a computer. GSU user IDs can be obtained from room 106, Library South. However, if a student has his/her own ISP, this account may be used.

Oracle 8i is available in the Lab for use by students to complete assignments. Oracle 8i Personal Edition may also be installed for use on personal computers.  Instructions for doing so are available on the bulletin board. (See Oracle)

Virus

It is the student’s responsibility to ensure that all submitted assignments are virus free. Infected files will NOT be opened or graded.  

Visio

Microsoft Visio can be used to draw ERD diagrams.  Microsoft is available for download free of charge for all CIS Majors only, from the MSDNAA.  The website is http://msdn.e-academy.com/gsu_cis/.

WebCT

This course will be taught in conjunction with WebCT. Registered students will receive assignments, instruction, feedback, and credit (points) through the WebCT interface. This will be the principal medium for all course communication.

WebCT Abuse

The use of WebCT is a privilege. Correspond with colleagues as one would in a business letter by typing out all messages using proper grammar and spelling. Misuse of the media such as cursing, insults, profanity, swearing, sarcastic, racist, or negative comments will result in loss of WebCT privileges and can lead to dismissal from class.

WebCT Attachments

After completing word-processed assignments, save all files in Rich Text Format (RTF). To save a file as RTF while in a word processor, click on “File”, select “Save As”, move to the box titled “Save as type.” and scroll down to save the file attachment as a “Rich Text Format” (CousinsK_ERD.rtf). This universal format can be read and saved on almost every machine.

This is important because it reduces the possibility of spreading computer viruses, since viruses attach themselves to documents as well as Executable (EXE) files.

WebCT Bulletin Board

This course will provide a common platform for students to communicate with each other through the WebCT Bulletin Board. This is the medium to post questions and responses related to course lectures, homework, programs, or exams. Students are encouraged to take an active role in one’s learning by asking and responding to questions from their peers. The instructor will also post messages.

WebCT E-Mail

This course will provide students with direct access to the instructor through WebCT e-mail. Use this medium for questions that CANNOT be answered by fellow students through the bulletin board and requires the instructor’s response. 

Withdrawal 

Students withdrawing after the official withdrawal date (October 17, 2003) will receive a grade of WF unless a hardship authorization is obtained from the Dean of Students. Students can only attend the classes for which they are registered.

Tentative Schedule of Classes

Week

Chapter

Topic

Major Events

1

1

 

2

The Database Environment

The Database Development Process

Read Effective Self Managed Teams Handout

Survey1

2

 

Labor Day – No Class

Project Milestone 1

 

 

3

3

Entity –Relationship Modeling

 

4

4

Enhanced ER Modeling

ER Modeling In Class Assignment

 

ER Modeling Take Home Assignment Released

 

Survey2

5

5

Logical Database Design

ER Modeling Take Home Assignment Due

6

 

Normalization

 

Project Milestone 2

 

Normalization In Class Assignment

 

Survey3

7

6

Physical Database Design

 

8

1,2,3,4,5,6

Exam 1

 

Fri

 

Last Day to Withdraw

 

9

7

SQL

 

 

SQL Assignment Released

10

8

 

 

SQL

 

Survey4

11

 

Oracle Lab

Project Milestone 3

 

 

 

12

9

The Client / Server Database Environment

SQL Assignment Due

13

11

Data Warehousing

 

14

12

Data and Database Administration

 

15

13

Distributed Databases

Survey5

16

 

Final Exam Review

Final Project Due

 

17

7,8,9,11,12,13

Final Exam

 

This Syllabus Provides a General Plan for the Course; Deviations May Be Necessary.


  Quick Links
  Syllabus List
  GoSolar Schedule
  Health Informatics

Apply Online:

Graduate

Undergraduate

Copyright © 2000 Computer Information Systems Department, Georgia State University. All rights reserved.