Instructor Information

Dr. Hyrum D. Carroll

TSYS School of Computer Science
Columbus State University
CCT 442
(706) 507-8182

Office Hours

Mon: 9:30 - 10:30 AM
12:00 - 1:00 PM
Tue: 10:00 - 11:00 AM
Wed: 9:30 - 10:30 AM
12:00 - 1:00 PM
3:00 AM - 4:00 PM
Thu: 8:30 - 9:30 AM
Fri: 9:30 - 10:30 AM
12:00 - 1:00 PM
3:00 AM - 4:00 PM
and by appointment
 

Class

Section 01 Section V01
Tuesdays (on-line)
9:30 - 10:45 AM (on-line)
CCT 408 (on-line)
CRN: 20583 CRN: 20251

Required Textbook

textbook   Title: Delivering Business Intelligence with Microsoft SQL Server 2012
Edition: 3rd, 2012
Author: Brian Larson
Publisher: McGraw Hill
ISBN-10: 0071759387
ISBN-13: 9780071759380

Software Requirements

To complete all lessons, projects, and exams, you need:

Course Description

This course provides an overview of modern database management systems and issues relating to these systems. Topics include developing a logical model, deriving the physical design, creating data services, creating a physical database, and maintaining a database in a variety of environments.

Course Learning Outcomes

Upon completion of this course, students will have an understanding and knowledge of:

Course Assessment

Learning Activities

Performance Evaluation

CategoryPercentage
Assignment and quizzes   25%
Projects 35%
Midterm 20%
Final Exam 20%

Grading

Course letter grades are determined by the final course average according to the following chart:
PercentageGrade
90 – 100 A
80 – 89 B
70 – 79 C
60 – 69 D
<60 F
The last day to drop without a grade is Friday, January 26, 2018.

Course Websites

The course schedule, assignment descriptions, syllabus, etc. are hosted at http://csc.columbusstate.edu/carroll/6127/. Grades, assignment submissions, quizzes, etc. are hosted in CougarVIEW. You are expected to monitor the websites and your CSU email account frequently (i.e., at least every other day).

CougarVIEW

You can access the course through CougarVIEW at: cougarview.columbusstate.edu.
Use your school credentials to access the site. If CougarVIEW will not let you in, go to the CSU Help Desk or call them at (706) 507-8199. If you are still having problems gaining access a day or so after the class begins, please e-mail me immediately.
Once you've entered CougarVIEW, you will see a list of courses you have access to. The CPSC 6127 course is listed as "Contmpry Is In DB Man Sys". Next to this, you should see my name as the instructor. You may also see new discussion postings, new calendar postings, and new mail messages. Clicking on the name of the course will take you to the course's home page. If you do not see the "Contmpry Is In DB Man Sys" course in the list, please e-mail me immediately.
Once you have clicked on the course's name and accessed the particular course itself, you will find a home page with links to other sections and tools, and a menu on the left-hand side. Feel free to explore the areas in the course.
If you need technical support related to the use of CougarVIEW, you can refer to any of the links located in the "Technical Resources" widget located on your "My Home" and your "Course Home" pages. If you cannot solve your problem after reviewing the knowledge base help pages, you can call help center 24-7 and talk to a Help Center agent. The number is 1-855-772-0423.

Email

You must be able to read and respond to e-mails sent to your university email account. Additionally, I do not use nor check the CougarVIEW email account.

Lecture

Attendance is required by the university and will be recorded at the beginning of each class. If you can not make a class, please inform me and get the relevant materials from a classmate. Although you'll miss out on the attendance points for that day, you'll at least minimize the impact.
Computers are permitted in lecture for note taking and completing exercises. Other activities such as web surfing, stock trading, and social networking are inappropriate. Not only do they distract you but also others.
Students that do not attend both of the first two lectures may be dropped from the course.
An audible cell phone ring and noise during class will require the possessor to bring fruit, cookies, or equivalent for the entire class during the next lecture time.
Additionally, all views are to be heard and engaged respectively. As scholars, we are expected to analyze subject matter critically and express reasonable positions that are based on logic and fact rather than on emotion.

Projects

They are due at 11:59 PM Eastern Time on the assigned due date (unless indicated otherwise). Late projects will be reduced by the following schedule (Sunday and Monday are counted as 1 day late):
# of days late Penalty
1 -10%
2 -30%
3 -50%
≥ 4 -100%
For example, let's say projectX was due on a Friday, and that you earned 85% of the total points. If it turned in before the end of Friday, then you get all 85%. If it's turned in on Saturday, you will get 76.5% (= 85% * [100% - 10%]). If it's turned in on Sunday or Monday, you will get 59.5% (= 85% * [100% - 30%]). If it's turned in on Tuesday, you will get 42.5% (= 85% * [100% - 50%]). If it's turned in after Tuesday, you will get 0%.
If an assignment contains portions that are more than 75% similar to other material (not provided by the instructor), zero points will be awarded. Additionally, the a BART incident may be recorded as well.
Students missing two or more projects will receive an F or FA in this course.

Final Exam

Section 01 Section V01
Thursday, May 10th, 8:00 - 10:30 AM in CCT 408 Thursday, May 10th, 8:00 - 10:30 AM in CCT 408 or with a proctor

Advice for Succeeding in this Course

What To Do When You Get Stuck

General steps for addressing a coding challenge:
  1. Isolate the problem and replicate it in the simplest form possible
  2. Search for answers (e.g., in the book, on-line, etc.)
  3. If you've already spent an hour trying to solve the problem, contact me during my office hours or via email. If you email me, mention what you've already attempted to solve the problem (for example, the steps above). (Note, if you email me a question, and then later figured out a solution, please send a second email indicating that it's resolved :)

Administrative Policies and Academic Resources

ADA and 504 Statement

If you have a documented disability as described by the Americans with Disabilities Act (ADA) and the Rehabilitation Act of 1973, Section 504, you may be eligible to receive accommodations to assist in programmatic and/or physical accessibility. We recommend that you contact the Center for Accommodation and Access located in Schuster Student Success Center, Room 221, 706-507-8755 as soon as possible. The Center for Accommodation and Access can assist you in formulating a reasonable accommodation plan and in providing support. Course requirements will not be waived but accommodations may be able to assist you to meet the requirements. Technical support may also be available to meet your specific need.

Commitment to Meeting the Graduate Program's Academic Dishonesty Policies

Commitment to Meeting the Graduate Program's Academic Dishonesty Policies document thumbnail
Note, on-line sections must CC the instructor as well to receive points.

Student Complaint Process

Information and resources for student complaints and academic appeals are located at the following link on the Columbus State University website http://aa.columbusstate.edu/appeals/.

Course Attendance Policy

Refer to the CSU Catalog (https://academics.columbusstate.edu/catalogs/current/regulations/undergraduate/index.php#attendance) for more information on class attendance and withdrawal.
Discussion Etiquette
CSU is committed to open, frank, and insightful dialogue in all of its courses. Diversity has many manifestations, including diversity of thought, opinion, and values. Students are encouraged to be respectful of that diversity and to refrain from inappropriate commentary. Students as well as faculty should be guided by common sense and basic etiquette. The following are good guidelines to follow: Never post content that is harmful, abusive; racially, ethnically, or religiously offensive; vulgar; sexually explicit; or otherwise potentially offensive.
Student Responsibilities
As a student in this course, you are responsible to: "I didn't know" is NOT an acceptable excuse for failing to meet the course requirements. If you fail to meet your responsibilities, you do so at your own risk.
Instructor Responsibilities
As your instructor in this course, I am responsible to: