/ Course Description and Objectives
Textbook and References
Software
Methods of Instruction
Evaluation
Student Responsibilities
Attendance Policy
Academic Dishonesty
ADAAccommodation Notice

Instructor: Dr. Vladimir Zanev
Office Location/Phone Number: CCT 442/ (706) 507-8182
Office Hours: Mon-Thu 3:00 p.m.- 4:00 p.m. , Fri:10:00-11:30 a.m.
E-mail: CougarVIEWclass e-mail or
Website:

This course is offered as an online class in the Summer term of 2011. Class meets 100% online at
( )

Section / Days / Time / Location
CRN51489 (Graduates) / MTWR / Online, 85 min. sessions / Online

Online Interface:
WebCT will be the primary method of online interaction in this course. Course materials (course outline, calendar, schedule, assignments, Midterm and Final exams, course notes, resources, email, and grading will be available through WebCT. You can access WebCT at:
or
At this page, click on the "Log on to" link to activate the WebCT logon dialog box, which will ask for your WebCT username and password. Your WebCT username and password are:

Username: lastname_firstname
Password: DDMMYY
where DDMMYY is the student birth date. (Example - Birthday of Oct. 25, 1978 is 251078)

If you try the above and CougarVIEW will not let you in, please use the "Comments/Problems" link at the bottom of the home page to request help. If you are still having problems gaining access a day or so after the class begins, please e-mail me. Once you have clicked on the course's name and accessed the course itself, you will find a home page with links to other sections and tools, and a menu on the left-hand side. This course homepage and the left-hand menu will give you access to all course materials.

Top ...

Course Description and Objectives

Course Description:
Prerequisite - CPSC 3131 (Introduction to Database Systems 1).
This course is intended for computer science students and professionals who have already acquired a basic background on databases. The objective of the course is to introduce the students to the most advanced concepts and recent issues in several areas of database technology, including the following: advanced database design and implementation, transaction management and concurrency control, data warehouse databases, distributed database management systems, object-oriented databases, database administration, and e-commerce databases. The course includes an extensive database work and individual database projects. Specific topics covered in this course include:

  • Transaction Management and Concurrency Control
  • Distributed Database Management Systems
  • Object-Oriented Databases
  • Data Warehousing
  • Databases in Electronic Commerce
  • Web Database Development
  • Database Administration
  • SQL Server 2008, database design, implementation, and maintenance
  • Transact-SQL, views, stored procedures, functions, triggers, custom rules

Expected Outcomes:

At the completion of this course, students will have an understanding of:

  • How modern database systems implement transaction management;
  • How to design a distributed database system;
  • Basic principles of object-oriented databases;
  • How to create and manipulate transactions in SQL;
  • How to create and tune-up a database in SQL Server;
  • How to create user types, defaults and custom rules in SQL Server;
  • How to backup and restore a database in SQL Server;
  • Principles of modern data warehousing technologies.

Top ...

Textbook and References
Textbook - required
/ Title: Database Systems: Design, Implementation, & Management
Authors: Carlos Coronel, Steven Morris, Peter Rob
Edition: Ninth Edition
Publisher: Thomson, Course Technology,
ISBN-10:0-5384-6968-4
ISBN-13: 978-0-5384-6968-5
SQL Server 2008 Lecture Notes / See SQL Server 2008 Online Web page
SQL Server 2008 Online Lectures / See SQL Server 2008 Camtasia Lectures Web Page

Top ...

Software

Software
To complete all lessons, projects, and exams, you will need a computer with:

  • Windows XP/Vista/7, browser, Word, and PowerPoint
  • SQL Server 2008
    Department of Computer Science, as a participant of MSDNAA (Microsoft Developer Network Academic Alliance program), enables all enrolled students to obtain free licensed copies of certain Microsoft products, which include and SQL Server 2008. You can download a free copy of SQL Server 2008 from the CSU MSDNAA Web site. See How To ... Web page for details.
  • Internet Access (account) to the CSD SQL Server 2008 (the Department SQL Server 2008)
  • Internet Access (account) to the CSU CougarVIEW Web site (WebCT)

Top ...

Methods of Instruction

Methods of Instruction:

  • Textbook readings
  • Online Lectures and Notes
  • Projects
  • Quizzes
  • Assignments
  • Midterm Exam
  • Final Exam

Readings and Online Lectures
The CPSC 5138U/G online class is scheduled MTWR with online sessions each one of 85 min. To complete all class requirements you need an additional amount of time. The class topics are organized in units. In an unit you have to cover chapter topics from the textbook and appendices, slides, online lecture notes and audio-video lectures The topics covered in the class follow the course schedule. See the class Schedule for details. Each student is expected to complete all textbooks chapters, the online lecture notes and audio-video lectures.

Projects

The projects are "hands-on practice" part of the course that allows developing skills and experience in developing databases from scratch and working with advanced database topics with SQL Server 2008 DBMS. Each project provides you with practice developing databases and tables, creating and running SQL transactions, triggers, stored procedures, functions, and setting up different levels of database security. The projects are related to major database topics aimed at providing you with database theoretical background, practical skills and experience. The details of each of these projects are outlined in the Projects area of the class Web site.
Most of the projects will be graded on the CSD Server (CSU SQL Server 2008). The projects have to be developed and saved on your personal database not later than the due date. Late projects are not accepted for credits. See the Projects area of the class Web site for details.

Quizzes
At least seven quizzes are scheduled. The quiz questions cover topics from textbook chapters. Questions on the quizzes may include the following: multiple choice answer selection and short essay questions. All quizzes will be delivered through WebCT. The quizzes are open textbook but since they will be timed (short time - about 20-30 min for about 20 questions), it is required beforehand a good preparation for a successful quiz.

Assignments
In addition of the other class requirements the graduate students have to complete assignments. Three assignments are scheduled. Each assignment consists of readings, project, and report. These assignments cover topics from SQL Server 2008 - Reporting Services, Integration Services, and Analysis Services. Late assignments are not accepted for credits. See the Assignments area of the class Web site for details.

Exams
Your performance in this class will be measured by two exams - Midterm and Final Exam. No make up exam will be given unless the exam was missed due to a documented emergency.
The Midterm Exam will be a timed, problem-solving exam. You can use your textbook, lecture notes and all resources (including Internet).
The Final Exam will be a comprehensive, proctored exam. You have to find a proctor who will administer the exam and certify that the exam was taken by you under the prescribed conditions or you have to take the exam at a testing center. The proctor must be approved by me ahead of time. Do this in at least two weeks before the last day of the class so I can communicate by mail and phone with the proctor. Suitable proctors would be public librarians or college and university officials. Colleagues, friends, or neighbors are not suitable to serve as proctors. Consult me, if you have questions. The local student can take the Final Exam at our Department CCT 450 Lab. The Final Exam will be closed textbook and lecture notes. Questions on the Final Exams may include the following:

  • Transact-SQL coding
  • short essay questions
  • multiple choice answer selection

Top ...

Evaluation

Evaluation
The final grade will be obtained from the following:

Quizzes / 15%
Projects / 20%
Assignments / 10%
Midterm Exam / 25%
Final Exam / 30%

The letter grade will be assigned as follows:

Grade / Points
A / 90-100
B / 80-89
C / 70-79
D / 60-69
F / 0 -59

Top ...

Student Responsibilities

Student Responsibilities

  • Each student is responsible to manage his/her time and maintain the discipline required to meet the course requirements.
  • Each student is responsible to read from the textbook, lecture notes, references, and tutorials all topics covered in the class
  • Each student is responsible to read from the textbook, references, and tutorials all summaries, key terms, review questions, and problems
  • Each student is responsible to be prepared and complete in time all projects
  • Each student is responsible to execute all assignments and quizzes
  • Each student is responsible to adhere to all course deadlines and actively to participate in class meetings
  • Each student is responsible to take the exams as they are scheduled in the course schedule.

"I didn't know" is no an acceptable excuse for failing to meet the course requirements. Students who fail to meet their responsibilities do so at their own risk.
Top ...

Attendance Policy

Attendance Policy
Attendance at all classes and other activities (lecture periods, laboratory sessions, tests, examinations, or other schedule meetings is required of every student at Columbus State University. The attendance record begins with the first meeting of the class, and one who registers late is responsible for class work missed. Student should note that the Computer Science Faculty does not initiate "class drops". A student wishing to drop should complete the official procedure before the deadline. Those who violate the attendance policy after that deadline may receive an "F" at the discretion of the instructor. After the midpoint of the quarter, no drop slip will be signed by the Dean unless extreme circumstances can be proved.
Top ...

Academic Dishonesty

Academic Dishonesty:Academicdishonesty includes, but is not limited to, activities such as cheating andplagiarism ( It is a basis for disciplinary action. Anywork turned in for individual credit must be entirely the work of the studentsubmitting the work.All work must be your own.You may share ideas butsubmitting identical assignments (for example) will be considered cheating.You may discuss the material in the course and help one another with debugging;however, any work you hand in for a grade must be your own.A simple way toavoid inadvertent plagiarism is to talk about the assignments, but don't readeach other's work or write solutions together unless otherwise directed. Foryour own protection, keep scratch paper and old versions of assignments toestablish ownership, until after the assignment has been graded and returned toyou.If you have any questions about this, please see me immediately.Forassignments, access to notes, the course textbooks, books and other publicationsis allowed. All work that is not your own, MUST be properly cited. This includesany material found on the Internet. Stealing or giving or receiving any code,diagrams, drawings, text or designs from another person (CSU or non-CSU,including the Internet) is not allowed. Having access to another person’s workon the computer system or giving access to your work to another person is notallowed. It is your responsibility to keep your work confidential.
No cheating in any form will be tolerated. Penalties for academic dishonesty mayinclude:

  • a zerograde on the assignment or exam/quiz
  • a failing grade for the course
  • suspension from the Computer Science program
  • dismissal from the Computer Science program.

All instances of cheating will be documented in writing with acopy placed in the Department's files. Students will be expected to discuss theacademic misconduct with the faculty members and the chairperson.
Top ...

ADA Accommodation Notice

ADA Accommodation Notice
If you have a documented disability as described by the Rehabilitation Actof 1973 (P.L. 933-112 Section 504) and Americans with Disabilities Act (ADA) andwould like to request academic and/or physical accommodations please the Officeof Disability Services in the Center for Academic Support and Student Retention,Tucker Hall 100 or at (706) 568-2330, as soon as possible. Course requirementswill not be waived but reasonable accommodations may be provided as appropriate.

Top ...