Southern Polytechnic State University

 

Business Administration Department

School of Engineering Technology & Business Administration

http://www.spsu.edu/mba

 

FALL 2010

MGNT 6038 ADVANCE DATABASE ANALYSIS, DESIGN, AND IMPLEMENTATION

 [Fully online via GaVIEW/Vista]

 

Dr. Max M. North

 

 

Instructor:

Dr. Max M. North, Professor of MIS

 

Office:

J337

Email Addresses:

Max@spsu.edu  or Max@acm.org

Office Phone:

678-915-7755

Cell Phone:

678-862-2691

Fax Number:

678-915-4967

Website:

www.spsu.edu/business/max

 

 

Course Description:

This course covers physical design, programming, testing and implementation of the system.  Implementations of object-oriented, client-server designs using a programming environment. Specifically, the main areas of concentrations are The Client/Server Database Environment, The Internet Database Environment, and Data Warehousing/Data Mining.

 

Textbook and Resources:

The required main text for the course is the following.

·         Modern Database Management, 9/E 
Jeffrey A. Hoffer, 
Mary Prescott
Heikki Topi

ISBN-10: 0136003915
ISBN-13: 9780136003915

Publisher: Prentice Hall
Copyright: 2009

 

http://vig-fp.prenhall.com/coverimage/0136003915.jpg

 

Other Textbooks:

 

Selected Major Resources:

 

ACM               http://www.acm.org/

            IEEE               http://www.ieee.org/

 

Related Web Sites:

http://www.eas.asu.edu/~advdb/

http://www.eas.asu.edu/~cse494db/

http://www.eas.asu.edu/~winrdbi/

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-objects.html#construct

http://www.oracle.com/oramag/oracle/00-jul/index.html?o40O8i.html

 

 

Note: Additional resources will be posted on the class web site.

 

Learning Objectives:

The content objectives for this course are to:

1.                  Understand the context of database management.

2.                  Gain a good knowledge of database environments and development processes.

3.                  Understand database analysis, design, and implementation.

4.         Understand issues and principles of managing organizational data.

5.         Understand the client/server database environment.      

6.         Understand the Internet database environment

7.                  Understand the data warehousing and data mining

 

The process skills objectives for the course are to:

1.         Improve written and oral communications.

2.         Improve and foster critical thinking.

3.         Understand cultural diversity.

4.         Improve quantitative reasoning skills.

5.         Understand the role of science and technology in life.

6.         Improve project management skills such as planning, organization, and coordination.

7.         Improve interpersonal relationship management.

8.         Develop performance appraisal skills.

 

Table of Contents:      

 

Part    I    The Context of Database Management

1    The Database Environment 
2    The Database Development Process 

Part    II    Database Analysis

3    Modeling Data in the Organization 
4    The Enhanced E-R Model and Business Rules 

Part    III    Database Design

5    Logical Database Design and the Relational Model 
6    Physical Database Design and Performance

Part    IV    Implementation

7     Introduction to SQL 
8     Advanced SQL
9     The Client/Server Database Environment
10   The Internet Database Environment
11   Data Warehousing
 


Part    V    Advanced Database Topics

12    Data Quality and Integration
13    Data and Database Administration

14    Overview: Distributed Database
15    Overview: Object-Oriented Data Modeling
16    Overview: Using Relational Databases to Provide Object Persistence


Appendices
A    E-R Modeling Tools and Notation
B    Advanced Normal Forms 
C    Data Structures 
Glossary of Acronyms 
Glossary of Terms

Testing Policy:

Quiz management (pop quizzes vs. scheduled, etc.) is at the discretion of the instructor.  Major exams are scheduled to be given in the weeks indicated on the Timetable in this syllabus.  An unexcused absence from an exam will result in a grade of zero for that exam. Excused absences require documentation in the form of doctor's notes, etc.  Exams will cover material up to the exam date.  Exams cover the textbook material, handouts, assigned articles, in-class lectures, in-class exercises, and homework/programming assignments. 

 

Technical Issues with Tests on the WebCT

If you encounter any technical issues with WebCT during the time you are taking any test, you are required to contact me immediately either via e-mail or phone.  If you fail to do so, I will not be able to assess the situation and assist you.

 

Make-up Work and Test Policy:

Late work is not accepted. No make-up tests are given. If an emergency arises, and an absence is excused, then the weight of the last test may be increased to replace a missed test. Documentation for an emergency absence is REQUIRED. The lowest assignment grade may be dropped, in order to allow for emergencies.  

 
Attendance Policy:

Please note that this course is fully online via GaVIEW/Vista.

 

Withdrawal Policy:

Ceasing to attend class or oral notice thereof DOES NOT constitute official withdrawal and will result in the rendering of a grade of “F” for the class.  Students wishing to withdraw after the scheduled change period (add/drop) must contact the Registrar’s Office.

 

Enrollment Policy:

Only those students who are enrolled in the class may attend lectures, receive assignments, take quizzes and tests, and receive a grade in the class.  If a student is administratively withdrawn from this course, they will not be permitted to attend class nor will they receive any grade for the class.

 

 

Tentative Course Schedule by Learning Modules:  

 

Learning Module

Ending Date & Time

Topic and Test

1

Ends on Sept 12, 2010

at 11:30pm

- Overview of the course

Part  I  - The Context of Database Management (in-depth review)

2

Ends on Sept 26, 2010

at 11:30pm

Part  II -  Database Analysis (in-depth review)

- First Test (Covers chapters 1, 2, and 3), Check the TEST folder

3

Ends on Oct 10, 2010 

at 11:30pm

Part  III - Database Design (in-depth review)

4

Ends on Oct 24, 2010

at 11:30pm

Part  IV - Implementation (in-depth review)

- Second Test (Covers chapters 5 and 7), Check the TEST folder

5

Ends on Nov 7, 2010  

at 11:30pm

Chapter 9 - The Client/Server Database Environment

Chapter 10 – The Internet Database Environment

6

Ends on Nov 21, 2010  

at 11:30pm

Chapter 11 - Data Warehousing and Data Mining

- Third Test (Covers chapters 9, 10, and 11), Check the TEST folder

7

Ends on Dec 5, 2010    

at 11:30pm

Part  V - Advanced Database Topics (brief version)

Chapter 12 – Data Quality and Integration

Chapter 13 - Data and Database Administration

8

Ends on Dec 12, 2010     

at 11:30pm

- Fourth Test (Covers chapters 1, 2, 3, 5, 7, 9, 10, 11, 12, and 13), Check the TEST folder

To some extent, the main text is intended as both a tutorial guide and a reference. Certainly, most of the course material is presented in the order and manner of the main text, and selected examples and exercises from the main text are used in the course. However, some of the course material is presented in a manner somewhat independent of the main text. In any case, the student is expected to supplement the content materials with self-directed readings from the main text, as necessary on an individual basis.

It should be emphasized that the TOPIC OUTLINE IS TENTATIVE, and is given only to provide an idea of the nature of the course. Of course, if time problems develop, then some of the topics might not be covered in detail.

Requirements:

The course requires responsible study habits that include approximately ten (10) hours per week study time outside of class for the average student. Moreover, due to the accumulative nature of the material, the course requires a uniform effort throughout the semester.

 

Online Guidelines

All the online activities for online sessions will be posted on the GaVIEW-Vista8/Vista main page. You are also required to check announcements often and follow the instructions to obtain full credit for your online course.

 

All submitted assignments must be on time. Please do not submit older assignments (ones past the deadline) using the current assignment tool. In another words, all responses must match up with the questions (and instructions) of a particular assignment. If you submit older assignment via the current assignment tool, you will receive a grade of "0 - Zero".

 

Please do not send any assignments via the attachment option using GaVIEW-Vista8/Vista E-Mail.  You will receive no grade for these assignments. Please use the Assignment Tool to submit your assignments. If you have any problems with the assignment tool, please contact the Online Support Center at: http://help.view.usg.edu/

 

Assignments:

All assignments must be submitted on time. Late assignments, except for extreme circumstances and explicit approval by the instructor, will not be accepted.  Please plan your time to account for course assignments well in advance of their due date. Assignments are listed on each learning module with the appropriate instructions and due dates. 

Important Note: All submitted assignments must be originally written by individual student. All the assignments may be submitted for originality to Turnitin.com and may be graded based on the similarity percentage report. Additional information will be provided via Announcement tool. Please carefully read sections on Dishonesty/Cheating and Plagiarism and Collaboration on Assignments and other activities.  

DB Research Articles: 

The purpose of the research project is to familiarize the students on technology emerging since the publication of any written texts. The purpose of the research project is to provide an opportunity for students to conduct a search, understand, organize, and prepare a synopsis of a current topic in DB. Projects can address virtually any technical issue in the area of DB.  Your selected topic has to be approved by your instructor. Students will be expected to research and prepare a summary of three articles from the ACM (www.acm.org) related to MIS topics. Students will prepare and develop a research paper using APA style (see E-Research Book by Max North www.spsu.edu/business/max or other APA style books). The research paper will consist of a 10 to 15 APA style pages of the articles studied. The primary and official resource for the professional research articles is the ACM = www.acm.org    

Important Note: All submitted research reports must be originally written by individual student. All the research papers will be submitted via Turnitin.com and will be graded based on the similarity percentage report. Please carefully read sections on Dishonesty/Cheating and Plagiarism and Collaboration on Assignments and other activities.

 

Professional Activities / Extra Credit:

To remain current in management and related sciences, students must have an ongoing commitment to participate in professional activities. These activities offer opportunities to network with professionals and other students, participate in meetings, listen to exciting presentations, and learn about new trends in management and the related sciences. To provide incentives for professional activities, students will be able to earn up to four points of extra credit per semester. The earned points will be added to the student's final average. To obtain the extra credit, students must complete the following steps:

  1. Attend an approved professional activity.
  2. Type a one-page summary of the activity/presentation.

 

Assessment Details:

 

Categories

Comment

Due Date

Points

Quizzes via GaVIEW-Vista8

-         7 combined quizzes 

-        10 questions each,

-        20 minutes time,

-        Quizzes can be taken multiple times until the individual due dates.

TBA-Individual due dates

80

Assignments via GaVIEW-Vista8

 

-        7 combined assignments

-        No attached files please!

-         Just text is accepted.

-       Submissions may be subject to similarity report via Turnitin.com.  Additional instructions will be provided on GaVIEW-Vista8.

TBA

 

80

Discussions via GaVIEW-Vista8

-         Students are required to participate in all discussions during the semester.

 

20

DB Research Project (paper) via GaVIEW-Vista8

-        Research Project Paper, research articles must be incorporated,

-         Students need to use three or more related professional articles (ACM = www.acm.org ) with their analysis,

-       Paper limit:  10-15 APA style pages

-       Submission via Turnitin.com on due date. Additional instructions will be provided on GaVIEW-Vista8.

TBA

 

20

First TEST – Online via GaVIEW-Vista8

 

-        100 multiple-choice and true/false questions,

-        200 minutes,

-        Online test via GaVIEW-Vista8/Vista

 TBA

100

Second TEST – Online via GaVIEW-Vista8

-         50 multiple-choice and true/false questions,

-        100 minutes,

-        Online test via GaVIEW-Vista8/Vista

TBA

50

Third TEST – Online via GaVIEW-Vista8

-         50 multiple-choice and true/false questions,

-        100 minutes,

-        Online test via GaVIEW-Vista8/Vista

TBA

50

Fourth TEST – Online via GaVIEW-Vista8

Comprehensive

-        100 multiple-choice and true/false questions,

-        200 minutes,

-         Online test via GaVIEW-Vista8/Vista

TBA

100

TOTAL POINTS

 

 

500

 

 

 

Grade Evaluation:

 

Grade

Percentage

Point System

A

90% - 100%

450 - 500

B

80% - 89%

400 - 449

C

70% - 79%

350 - 399

D

60% - 69%

300 - 349

F

59% or below

299 - 0

 

Dishonesty/Cheating:

Students should be familiar with Southern Polytechnic's policies on academic dishonesty, disciplinary procedures, and appeals process. Any student who is found, or reported, cheating or exercising any form of dishonesty will receive an automatic F grade in the course. Such student(s) will also be subject to summarily disciplinary action in accordance with the University and School of Engineering Technologies & Management policies.

Plagiarism and Collaboration on Assignments:

Students are expected to complete all assignments and projects without assistance from others, except for those assignments and projects that are to be completed using a team approach. For the latter, the team members are expected to complete the assignment and projects without assistance from others.

However, it is unreasonable to expect that students will complete the assignments and/or projects in complete isolation from instructors and other students. The purpose of the remainder of this note is to give some guidance about the areas in which it is appropriate for students to discuss assignments and/or projects with instructors or other students. Violating these guidelines may be interpreted as a violation of the KSU policies and regulations on academic honesty.

The term plagiarism describes an attempt by a person to claim work as one's own which has been copied from another person, whether that other person knows about it or not. In addition, copying responses directly from the textbook or other resources is considered plagiarism. Plagiarism is simply not allowed.  

The term collaboration describes an attempt by a person to work together with others, especially in an intellectual endeavor. Working together does not mean that one person does the work and another person just copies it! Collaboration is allowed on the assignments and/or projects by instructor’s permission only.  

If students collaborate with others, then the students are expected to include documentation of the nature and source(s) of the collaboration with the submission of the assignments.

Procedure for turning in assignments and other required tasks.  All the assignments and required tasks in this course may be subject to originality check via Turnitin.com. Additional information will be provided via Announcements. Please carefully read the following statement.

“Students agree that by taking this course all required assignments and tasks may be subject to submission for textual similarity review to Turnitin.com for the detection of plagiarism.  All submitted assignments and tasks will be included as source documents in the Turnitin.com reference database solely for the purpose of detecting plagiarism of such papers. Use of the Turnitin.com service is subject to the Terms and Conditions of Use posted on the Turnitin.com site.”

If you suspect that your work is being misused by another student (e.g., one of your assignments disappeared), then report this immediately to the instructor to protect yourself against a charge of allowing plagiarism. Any student needing clarification as to whether or not they may have violated these guidelines should seek the advice of the instructor.

Academic Integrity and Honesty Statement:

In any academic community, certain standards and ethical behavior are required to ensure the unhindered pursuit of knowledge and the free exchange of ideas.  Academic honesty means that you respect the right of other individuals to express their views and opinions, and that you, as a student, do not engage in plagiarism, cheating, illegal access, misuse or destruction of college property, or falsification of college records or academic work.

 

Frequently students will be provided with “take-home” assignments and exercises.  It is the student’s responsibility to ensure they fully understand to what extent they may collaborate or discuss content with other students.  No exam work may be performed with the assistance of others or outside material unless specifically instructed as permissible.  If an exam or assignment is designated “no outside assistance” this includes, but is not limited to, peers, books, publications, the Internet and the WWW.  If a student is instructed to provide citations for sources, proper use of citation support is expected.  Additional information can be found at the following locations. 

 

http://www.apa.org/journals/webref.html

http://www.lib.duke.edu/libguide/citing.htm

http://bailiwick.lib.uiowa.edu/journalism/cite.html

http://www.cas.usf.edu/english/walker/papers/copyright/ipdummie.html

 

 

APA Documenting Examples:

The APA (American Psychological Association) Publishing Manual format is used for this course. When any portion of another author's work is used, whether it be from a course textbook or outside work, including the World Wide Web, in whole, in part, or paraphrased, that work must be cited. Proper citation formats are provided on the reverse of this document. Failure to do so can result in Academic Misconduct Proceedings.

 

There are two components to a proper citation: the text citation and the reference or endnote. The text citation will usually consist of the author's or authors' last name(s) and the year of the publication. The endnote citation will read as follows:

 

 

Books

 (Author. Date. Book Title. Publication Data.)

 

A reference for a single-author book:

 

North, M. M. (1996). Virtual reality technology. New York: Best Press.

 

A reference for a multi-author book:

 

North, M. M. & Blade, R. A. (1998). How to build skills for research. Colorado Springs: IPI Press.

 

 

Journals and Conference Proceedings
 

(Author. Date. Article Title. Journal Title. Publication Data.)

 

 

Journal Reference:

 

Kelly, F. G. (1997). Networking made efficient. Journal of Computer Networking. 45(3), 54-61.

 

(Here is an article in Volume 45, Issue 3, spanning pages 54-61)

 

 

Conference Proceeding:

 

Vanner, F. D. (1996). A survey of medical issues using virtual reality. Proceedings of the Virtual Reality Medical Technology. 119-132. Nice, France.

 

 

World Wide Web (from http://www.apa.org/books/pubmant.html)

 

(Author. Date. Page Title. Publishing Information. Retrieval Date. WWW URL)

 

Entire site no specific page

 

Kidspsych is a wonderful interactive Web site for children (http://www.kidspsych.org).

 

No reference entry is needed.

 

 

Citing Specific Documents on a Web Site:

 

American Psychological Association. (1995, September 15). APA public policy action alert: Legislation would affect grant recipients [Announcement]. Washington, DC: Author. Retrieved January 25, 1996, from the World Wide Web: http://www.apa.org/ppo/istook.html

 

An independent document (no author identified): 1

 

Electronic reference formats recommended by the American Psychological Association. (2000, August 22). Washington, DC: American Psychological Association. Retrieved August 29, 2000, from the World Wide Web: http://www.apa.org/journals/webref.html

 

If the primary author is not available for the body citation, the first key word is to be used (Electronic, 2000).

 

 

Student Evaluation of Course:

A standard questionnaire will be administered during the last two weeks of the semester in all classes. Additional questions developed by the college or instructor(s) may be included as well. It is important that each student provide meaningful feedback to the instructor(s) so that changes can be made in the course to continually improve its effectiveness. We value student feedback about the course, our teaching styles, and course materials, so as to improve our teaching and your learning. At a minimum, the following two questions will be asked: 1) Identify the aspects of the course that most contributed to your learning (include examples of specific materials, exercises and/or the faculty member's approach to teaching and mentoring), and 2) Identify the aspects of the course, if any, that might be improved (include examples of specific materials, exercises and/or the faculty member's approach to teaching and mentoring).

 

Brief Biography of Dr. Max North:

Dr. Max North is a Professor of Management Information Systems in the Business Administration Department.  Dr. North has been teaching, conducting research and providing community service for Computer Science and Information Systems departments at higher education institutions for more than twenty years. Dr. North holds an associate degree in Accounting, a bachelor’s degree in Economic Management, a master’s degree in Computer Science with a concentration in Management Information Systems and a doctorate degree in Psychology with concentration in Cognitive and Behavior sciences. Dr. North has been successfully involved in the research of human-computer interaction and has pioneered several applications in virtual reality technology. Additionally, Dr. North has two published books and several book chapters; and a number of technical referred scholarly articles. Dr. North has served as principal/co-principal investigator on a number of research grants sponsored by the Boeing Company, the U.S. Army Research Laboratory, and the National Science Foundation. Dr. North's major contribution to the scientific community is his discovery and continuous research activities in the innovative area of virtual reality technology, which has received international attention and coverage in the scientific community and the popular media.