Southern Polytechnic State University

 

Business Administration Department

School of Engineering Technology & Business Administration

/mba

 

Summer 2010

MGNT 6034 DATABASE ANALYSIS, DESIGN, AND IMPLEMENTATION

Wednesday 8:00PM, J106

[Hybrid Course � Partially online via GaView/Vista]

 

Dr. Max M. North

 

 

Instructor:

Dr. Max M. North, Professor of MIS

 

Office:

J337

Email Addresses:

Max@spsu.eduor 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 information systems design and implementation within a database management system environment.  Students will demonstrate their mastery of the design process acquired in earlier courses by designing and constructing a physical system using database software to implement the logical design.

 

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

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 GaView

If you encounter any technical issues with GaView 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:

Regular class attendance is required and expected (counts for 20 points). Documentation for an emergency absence is REQUIRED. If an emergency arises, email information to Max@spsu.eduIn addition, attendance will be checked for administrative purposes, and students should not expect extra help or consideration from the instructor if evidence shows that absences were avoidable.  Please note that this course is a hybrid course (partially online) via 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.

 

Electronic Devices:

In order to minimize the level of distraction, all beepers and cellular phones must be on quiet mode during class meeting times. Students who wish to use a computer/PDA for note taking need prior approval of the instructor since key clicks and other noises can distract other students. Recording of lectures by any method requires prior approval of the instructor.

 

 

Tentative Course Schedule: (Subject to change)

 

Learning Module/ Week of�

Topic and Activities

Module One

May 19

- Overview of the Advance Database Course

- Lecture: Part  I  - The Context of Database Management

- Lecture: Part  II -  Database Analysis
- Class  discussions (chapter case studies)

- Orientation and Planning for the semester

- DB Case Study/Research Article Discussion

- Partially online class via GaView/Vista

Module Two

May 26

- Lecture: Part  III - Database Design

- Lecture: Part  IV - Implementation

- Class  discussions (chapter case studies)

- Quiz/Exercise

- DB Case Study/Research Article Discussion

- Partially online class via GaView/Vista

Module Three

June 2

- Class  discussions (chapter case studies)

- Quiz/Exercise

- Partially online class via GaView/Vista

- First Test � Covers Chapters 1, 2, and 3 - Fully Online- Check GaView

Module Four

June 9

- Lecture: Chapter 9- The Client/Server Database Environment

- Class discussions (chapter case studies)

- Quiz/Exercise

- DB Case Study/Research Article Presentation Last names start with the letters

�A�, �B�, �C�, �D�,�E�,�F�, �G�, �H�,�I�, or �J�

- DB Case Study/Research Article Presentation Last names start with the letters

- Partially online class via GaView/Vista

Module Five

June 16

- Lecture: Chapter 10- The Internet Database Environment

- Class discussions (chapter case studies)

- Quiz/Exercise

- Partially online class via GaView/Vista

- Second Test � Covers Chapters 5, and 7 - Fully Online � Check GaView/Vista

Module Six

June 23

- Lecture: Chapter 11- Data Warehousing and Data Mining

- Class discussions (chapter case studies)

- Quiz/Exercise

- DB Case Study/Research Article Presentation Last names start with the letters

�K�,�L�, �M�, �N�, �O�, �P�, �Q�, �R�, or �S�

- Partially online class via GaView/Vista

Module Seven

June 30

- Class discussions (chapter case studies)

- Quiz/Exercise

- DB Case Study/Research Article Presentation Last name starts with the letters

�T�, �U�, �V�, �W�,�X�, �Y�, or �Z�

- Partially online class via GaView/Vista

Module Eight

July 7

 

- Class discussions (chapter case studies)

- Quiz/Exercise

- Partially online class via GaView/Vista

- Third Test � Covers Chapters 9, 10, and 11 � Fully Online - Check GaView/Vista

Note:This test starts on July 5 and ends at July 11.

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 lecture material 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. This study time should be used to review the material presented in the previous class(es), complete any out-of-class work, preview the material to be presented in the next class(es) and conduct library search and preparation for the research project(s). Moreover, due to the accumulative nature of the material, the course requires a uniform effort throughout the semester.

 

Class Format:

Class meetings will include lectures, discussion, in-class examples/exercises and presentations.  Class participation is expected and is measured through the participation grade.  Attendance during group project presentations is mandatory. This course is hybrid via GaView/Vista.

 

Online Guidelines

All the online activities for online sessions will be posted on the Announcements section of the Vista main page. You are required to check announcements often and follow the instructions to obtain full credit for the online portion of your course. Please note that your instructor will provide you with an in-class session to familiarize you with Vista and other software used in this course. It is my highest recommendation that you attend these sessions and take serious note of instructions and guidelines so you can have a successful online experience.

 

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 Vista E-Mail.  You will receive no grade for these assignments. Please use the Assignment Tool to submit your assignments on specified times. If you have any problems with the assignment tool, please contact the Online Support Center at: http://help.view.usg.edu

 

If you encounter any technical issues with GaView 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.

 

Assignments:

Assignments are due at the beginning of the designated class period.  This helps to discourage missing class or showing up late on the day assignments are due.  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 the course website with the appropriate instructions and due dates.  Online assignments will be posted on Vista with specific deadlines.

 

DB Case Study and Research Articles: 

At the end or within the each chapter are case studies based on a real-world organization.  These cases help students synthesize chapter concepts and apply this new knowledge to concrete problems and scenarios. The purpose of the research articles is to familiarize the students on technology emerging since the publication of any written texts. Students will be expected to research and prepare a summary analysis of DB articles. Students are required to select only one case study.Students are also required to use three or more articles and incorporate them into their case study analysis summary. The primary and official resource for the professional articles is the ACM =http://www.acm.org/���

 

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:

 

Note: Check GaView/Vista for updated version.

 

Categories

Comment

Points

Quizzes/Exercises via GaView/Vista

Note: This category is not available on GaView/Vista this semester.Check with your instructor.

         10 quizzes/exercises,

         10 questions each,

         20 minutes time,

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

 

Assignments/Home Works via GaView/Vista

         All assignments/homeworks are combined into one. It includes 10 sections,

         Due close to the end of the semester,

         Can be visited multiple times until the due date,

         A copy of the completed assignments/homeworks must be submitted via GaView/Vista on the due date, close to the end of the semester.

         No attached files please!

         Just text is accepted.

100

DB Case and Major Study Presentation with related ACM article, and PowerPoint via GaView/VISTA

 

*Note 1: Regular class attendance is required and counts for 40 points out of 100 points in this category.

*Note 2: Presentation dates are announced at the beginning of the semester and there will no partial credit for any missed presentation.

         Case and Major studies are combined together,

         Students need to use several related ACM articles with this presentation,

         Undergraduate students must use at least three ACM articles with their presentations,

         A copy of the PowerPoint presentation is due close to the end of the semester via GaView/Vista drop box on due date.

100*

First Test � online via GaView/Vista

 

         50-100 multiple-choice and true/false questions,

         100-200 minutes,

         Online test via GaView/Vista

100

Second Test � online via GaView/Vista

         50-100 multiple-choice and true/false questions,

         100-200 minutes,

         Online test via GaView/Vista

100

Third Test � online via GaView/Vista

 

         50-100 multiple-choice and true/false questions,

         100-200 minutes,

         Online test via GaView/Vista

100

TOTAL POINTS

 

500

 

 

 

Last Test:

 

All students must take the last test, which is comprehensive in nature and given at the end of the semester. 

 

 

Grade Evaluation:

 

Note: Check GaView/Vista for updated version.

 

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

 

 

Grade Evaluation:

 

A

90% - 100%

B

80% - 89%

C

70% - 79%

D

60% - 69%

F

59% or below

 

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 SPSU 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. For the user interface designs and exercises in this course, plagiarism includes copying source programs and/or project designs and summaries. 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 under certain conditions, as long as the students are honest about it.

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.

Special Note.  If you suspect that your work is being misused by another student (e.g., one of your program disks or listings 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.

Special Arrangements:                                                                                                                                                  

Any student who requires special arrangements may notify the instructor in an individual manner.  In particular, students with disabilities who believe that they may need accommodations in this class are encouraged to contact the SPSU�s counselor working with disabilities as soon as possible to better ensure that such accommodations are implemented in a timely fashion.

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.

 

 

 

 

 

 ©