Syllabus for CIS-311

DATABASE MANAGEMENT SYSTEMS


COURSE DESCRIPTION

Database Management Systems provides students with fundamental concepts of databases and Database Management Systems (DBMS). It offers terminology, conceptual approaches, and practical approaches when designing and implementing different database types. Students will learn design considerations and solutions with a DBMS, using various industry standards and models available. Analytical and problem-solving skills will be strengthened.

The material also includes common tools and techniques utilized to optimize performance and secure the database and related resources. Other topics covered include:

  1. Entity Relationship Diagrams (ERD)
  2. Structured Query Language (SQL)
  3. Information and decision making
  4. Data Normalization

COURSE OBJECTIVES

After completing this course, you should be able to:

  1. Describe the basic database systems and database models.
  2. Explain the benefits of a relational database and construct its components.
  3. Use Structured Query Language (SQL) to create database table structures, perform various types of data manipulation and data administration, and query the database to extract useful information.
  4. Explain and provide examples of major database features that must be supported in current-generation databases and models.
  5. Compare the various application architectures used to connect databases to the Internet.
  6. Evaluate a variety of database administration strategies.

COURSE MATERIALS

You will need the following materials to do the work of the course. The required textbook is available from the College's textbook supplier, MBS Direct.

Required Textbook

  1. Database Systems: Design, Implementation, and Management, 8th ed. Rob, Peter & Coronel, Carlos (2009). Boston, MA: Thomson Course Technology.

    ISBN-13: 978-1-4239-0201-0

Required Software

  1. Open Office (can be downloaded at OpenOffice.org for free or at www.officebestdeal.com for $11.95)

COURSE STRUCTURE

Database Management Systems is a three-credit, online course, consisting of six (6) modules. You are required to participate in five (5) graded class discussions, complete four (4) written assignments, take five quizzes, and complete a final project.

Each module includes learning objectives, activities, a quiz and a final project.

  1. Module 1: Database Concepts
  2. Module 2: Design Concepts
  3. Module 3: Structured Query Language (SQL)
     
  4. Module 4: Advanced Database Concepts
  5. Module 5: Databases and the Internet
  1. Module 6: Database Administration

Consult the course Calendar for assignment due dates.

ASSESSMENT METHODS

For your formal work in the course, you are required to participate in online discussion forums, complete written assignments, and complete a final project. See below for more details.

Consult the course Calendar for assignment due dates.

Discussion Forums

In addition to an ungraded "Introductions" forum in Module 1, Database Management Systems requires you to participate in five (5) graded online discussion forums.

Communication with the mentor and among fellow students is a critical component of online learning. Participation in online discussions involves two distinct activities: an initial response to a posted question and subsequent comments on classmates' responses.

You will be evaluated both on the quality of your responses (i.e., your understanding of readings and concepts as demonstrated by well-articulated, critical thinking) and quantity of your participation (i.e., the number of times you participate meaningfully in the assigned forums). Responses and comments should be properly proofread and edited, professional, and respectful.

Meaningful participation in online discussions is relevant to the content, adds value, and advances the discussion. Comments such as "I agree" and "ditto" are not considered value-adding participation. Therefore, when you agree or disagree with a classmate, the reading, or your mentor, state and support your agreement or disagreement.

Deadlines for posting responses to the discussion questions are given in the course Calendar.

For posting guidelines and help with discussion forums, please see the Student Handbook located within the General Information page of the course Web site.

Written Assignments

The four written assignments consist of specific topics contained within the chapters from the textbook. Each written assignment may include several essay questions.

Prepare your written assignments using whatever word processing program you have on your computer. Include your name at the top of the paper, as well as the course name and code and the semester and year in which you are enrolled.

Before submitting your first assignment, check with your mentor to determine whether your word processing software is compatible with your mentor's software. If so, you can submit your work as you prepared it. If not, save your assignment as a rich-text (.rtf) file, using the Save As command of your software program. Rich text retains basic formatting and can be read by any other word processing program.

For help regarding preparing and submitting assignments, see the Student Handbook located within the General Information page of the course Web site.

Quizzes

There will be five graded quizzes for this course. The quizzes should be taken after you complete the reading assignments and online discussion for each module. There will be twenty (20) multiple choice questions on each of the quizzes, each worth 5 point. Each quiz will cover a particular module.

Consult the course Calendar for test deadlines.

Final Project

There will be a final project using Open Office software due in place of an online final examination. Consult the course Calendar for the deadline for submitting this project.

For help regarding preparing and submitting assignments, see the Student Handbook located within the General Information page of the course Web site.

Statement about Cheating

You are on your honor not to cheat during the exam. Cheating means:

  1. Looking up any answer or part of an answer in an unauthorized textbook or on the Internet, or using any other source to find the answer.
  2. Copying and pasting or in any way copying responses or parts of responses from any other source into your online test. This includes but is not limited to copying and pasting from other documents or spreadsheets, whether written by yourself or anyone else.
  3. Plagiarizing answers.
  4. Asking anyone else to assist you by whatever means available while you take the exam.
  5. Copying any part of the exam to share with other students.
  6. Telling your mentor that you need another attempt at the exam because your connection to the Internet was interrupted when that is not true.

If there is evidence that you have cheated or plagiarized in your exam, the exam will be declared invalid, and you will fail the course.

GRADING AND EVALUATION

Your grade in the course will be determined as follows:

  1. Online discussions (5)—25 percent
  2. Written assignments (4)—20 percent
  3. Quizzes (5)—25 percent
  4. Final project—30 percent

All activities will receive a numerical grade of 0–100. You will receive a score of 0 for any work not submitted. Your final grade in the course will be a letter grade. Letter grade equivalents for numerical grades are as follows:

A

=

93100

A–

=

9092

B+

=

8889

B

=

8387

B–

=

8082

C+

=

7879

C

=

7377

C–

=

7072

D

=

6069

F

=

Below 60

To receive credit for the course, you must earn a letter grade of C or better (for an area of study course) or D or better (for a nonarea of study course), based on the weighted average of all assigned course work (e.g., exams, assignments, discussion postings, etc.).

STRATEGIES FOR SUCCESS

First Steps to Success

To succeed in this course, take the following first steps:

  1. Read carefully the entire Syllabus, making sure that all aspects of the course are clear to you and that you have all the materials required for the course.
  2. Take the time to read the entire Online Student Handbook. The Handbook answers many questions about how to proceed through the course, how to schedule exams, and how to get the most from your educational experience at Thomas Edison State College.
  3. Arrange to take your examinations by following the instructions in this Syllabus and the Online Student Handbook.
  4. Familiarize yourself with the learning management systems environment—how to navigate it and what the various course areas contain. If you know what to expect as you navigate the course, you can better pace yourself and complete the work on time.
  5. If you are not familiar with Web-based learning be sure to review the processes for posting responses online and submitting activities before class begins.

Study Tips

Consider the following study tips for success:

  1. To stay on track throughout the course, begin each week by consulting the course Calendar. The Calendar provides an overview of the course and indicates due dates for submitting activities, posting discussions, and scheduling and taking examinations.
  2. Check Announcements regularly for new course information.

ACADEMIC INTEGRITY

Students at Thomas Edison State College are expected to exhibit the highest level of academic citizenship. In particular, students are expected to read and follow all policies, procedures, and program information guidelines contained in publications; pursue their learning goals with honesty and integrity; demonstrate that they are progressing satisfactorily and in a timely fashion by meeting course deadlines and following outlined procedures; observe a code of mutual respect in dealing with mentors, staff, and other students; behave in a manner consistent with the standards and codes of the profession in which they are practicing; keep official records updated regarding changes in name, address, telephone number, or e-mail address; and meet financial obligations in a timely manner. Students not practicing good academic citizenship may be subject to disciplinary action including suspension, dismissal, or financial holds on records.

Academic Dishonesty

Thomas Edison State College expects all of its students to approach their education with academic integrity—the pursuit of scholarly activity free from fraud and deception. All mentors and administrative staff members at the College insist on strict standards of academic honesty in all courses. Academic dishonesty undermines this objective. Academic dishonesty takes the following forms:

  1. Cheating
  2. Plagiarizing (including copying and pasting from the Internet without using quotation marks and without acknowledging sources)
  3. Fabricating information or citations
  4. Facilitating acts of dishonesty by others
  5. Unauthorized access to examinations or the use of unauthorized materials during exam administration
  6. Submitting the work of another person or work previously used without informing the mentor
  7. Tampering with the academic work of other students

Academic dishonesty will result in disciplinary action and possible dismissal from the College. Students who submit papers that are found to be plagiarized will receive an F on the plagiarized activity, may receive a grade of F for the course, and may face dismissal from the College.

A student who is charged with academic dishonesty will be given oral or written notice of the charge. If a mentor or College official believes the infraction is serious enough to warrant referral of the case to the academic dean, or if the mentor awards a final grade of F in the course because of the infraction, the student and the mentor will be afforded formal due process.

If a student is found cheating or using unauthorized materials on an examination, he or she will automatically receive a grade of F on that examination. Students who believe they have been falsely accused of academic dishonesty should seek redress through informal discussions with the mentor, through the office of the dean, or through an executive officer of Thomas Edison State College.

Plagiarism

Using someone else's work as your own is plagiarism. Although it may seem like simple dishonesty, plagiarism is against the law. Thomas Edison State College takes a strong stance against plagiarism, and students found to be plagiarizing will be severely penalized. If you copy phrases, sentences, paragraphs, or whole documents word-for-word—or if you paraphrase by changing a word here and there—without identifying the author, then you are plagiarizing. Please keep in mind that this type of identification applies to Internet sources as well as to print-based sources. Copying and pasting from the Internet, without using quotation marks and without acknowledging sources, constitutes plagiarism. (For information about how to cite Internet sources, see Online Student Handbook > Academic Standards > "Citing Sources.")

Accidentally copying the words and ideas of another writer does not excuse the charge of plagiarism. It is easy to jot down notes and ideas from many sources and then write your own paper without knowing which words are your own and which are someone else's. It is more difficult to keep track of each and every source. However, the conscientious writer who wishes to avoid plagiarizing never fails to keep careful track of sources.

Always be aware that if you write without acknowledging the sources of your ideas, you run the risk of being charged with plagiarism.

Clearly, plagiarism, no matter the degree of intent to deceive, defeats the purpose of education. If you plagiarize deliberately, you are not educating yourself, and you are wasting your time on courses meant to improve your skills. If you plagiarize through carelessness, you are deceiving yourself.

Thomas Edison State College. All Rights Reserved