Syllabus for CIS-311

DATABASE MANAGEMENT


COURSE DESCRIPTION

This course 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: entity relationship diagrams (ERD); Structured Query Language (SQL); information and decision making; and data normalization

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 complete your coursework. Some course materials may be free, open source, or available from other providers. You can access free or open-source materials by clicking the links provided below or in the module details documents. To purchase course materials, please visit the University's textbook supplier.

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.

Promoting Originality

One or more of your course activities may utilize a tool designed to promote original work and evaluate your submissions for plagiarism. More information about this tool is available in this document.

Discussion Forums

In addition to an ungraded "Introductions" forum in Module 1, Database Management 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 POLICIES

To ensure success in all your academic endeavors and coursework at Thomas Edison State University, familiarize yourself with all administrative and academic policies including those related to academic integrity, course late submissions, course extensions, and grading policies.

For more, see:

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