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:

COURSE OBJECTIVES

After completing this course, you should be able to:

CO1        Describe the basic database systems and database models.

CO2        Explain the benefits of a relational database and construct its components. 

CO3        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. 

CO4        Explain and provide examples of major database features that must be supported in current-generation databases and models.

CO5        Compare the various application architectures used to connect databases to the Internet.

CO6        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 University's textbook supplier, MBS Direct.

Required Textbook

ISBN-13: 978-1305627482

Required Software

COURSE STRUCTURE

Database Management Systems is a three-credit, online course, consisting of six modules. Modules include an overview, topics, learning objectives, study materials, and activities. Module titles are listed below.

ASSESSMENT METHODS

For your formal work in the course, you are required to participate in online discussion forums, complete written assignments, module quizzes, and 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 six 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 provided 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

You are required to take five module quizzes, one each in modules 1-5. These are open-book, unproctored, online quizzes consisting of multiple-choice questions. There is no time limit and you are encouraged to take each quiz multiple times; the gradebook will record your most recent score. You will receive feedback each time you take a quiz, so use this feedback to guide your review of the textbook material and then take the quiz again for further practice.

Consult the Course Calendar for due dates.

Final Project

You are required to complete a final project (Part 1 and Part 2) using Open Office software. For full details and requirements of this two-part project, visit the Final Project section of the course site.

Consult the Course Calendar for due dates.

GRADING AND EVALUATION

Your grade in the course will be determined as follows:

(Part 1)—20 percent

(Part 2)—20 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

=

93–100

C+

=

78–79

A–

=

90–92

C

=

73–77

B+

=

88–89

C–

=

70–72

B

=

83–87

D

=

60–69

B–

=

80–82

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 course not in your area of study), 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:

Study Tips

Consider the following study tips for success:

ACADEMIC INTEGRITY

Thomas Edison State University is committed to maintaining academic quality, excellence, and honesty. The University expects all members of its community to share the commitment to academic integrity, an essential component of a quality academic experience.

Students at Thomas Edison State University 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.

All members of the University community are responsible for reviewing the Academic Code of Conduct Policy in the University Catalog and online at www.tesu.edu.

Academic Dishonesty

Thomas Edison State University 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 University insist on strict standards of academic honesty in all courses. Academic dishonesty undermines this objective. Academic dishonesty can take the following forms:

Plagiarism

Thomas Edison State University is committed to helping students understand the seriousness of plagiarism, which is defined as using the work and ideas of others without proper citation. The University takes a strong stance against plagiarism, and students found to be plagiarizing are subject to discipline under the academic code of conduct policy.

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, or without identifying it as a direct quote, 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.

For examples of unintentional plagiarism, advice on when to quote and when to paraphrase, and information about writing assistance and originality report checking, click the links provided below.

Examples of Unintentional Plagiarism

When to Quote and When to Paraphrase

Writing Assistance at Smarthinking

Originality Report Checking at Turnitin

Disciplinary Process for Plagiarism

Acts of both intentional and unintentional plagiarism violate the Academic Code of Conduct.

If an incident of plagiarism is an isolated minor oversight or an obvious result of ignorance of proper citation requirements, the mentor may handle the matter as a learning exercise. Appropriate consequences may include the completion of tutorials, assignment rewrites, or any other reasonable learning tool in addition to a lower grade for the assignment or course. The mentor will notify the student and appropriate dean of the consequence by e-mail.

If the plagiarism appears intentional and/or is more than an isolated incident, the mentor will refer the matter to the appropriate dean, who will gather information about the violation(s) from the mentor and student, as necessary. The dean will review the matter and notify the student in writing of the specifics of the charge and the sanction to be imposed.

Possible sanctions include:

Copyright © 2016 by Thomas Edison State University. All rights reserved.