Instructor: Dr. Vladimir Zanev Office Location/Phone Number : CCT 442/ 569-3056 Office

Instructor: Dr. Vladimir Zanev
Office Location/Phone Number: CCT 442/ 569-3056
Office Hours: Mon, Wed, Fri: 10:00 a.m.-12:00 noon. ; Tue,Thu: 2:00-4:00 p.m.
E-mail: CougarVIEWclass e-mail or
Website: (WebCT Vista)

Class meetings:

Course Description: Course Prerequisite – CPSC 3131.
CPSC Database Systems 2 is a continuation of CPSC 3131 Database Systems 1. This course is an introduction to Oracle database management system. Oracle has a strong lead in the modern relational database industry and market. The course is designed to give the students a further understanding of database system use from the standpoint of a developer and a designer. The students are introduced to the client/server Oracle DBMS, Structured Query Language (SQL) with Oracle extensions, and selected Oracle tools such as SQL*Plus, iSQL Plus, PL/SQL, Form Builder, Report Builder, DB administration. A case study approach will be used.

Course Objectives:

Upon completion of this course, the student will be able to:

• Gain expertise with creating, maintaining, and working with relational database tables using SQL
• Understand the PL/SQL procedural programming language and how it is used with SQL commands;
• Learn how to use Oracle 10g Form Builder to develop database form applications
• Learn how to use Oracle 10g Report Builder to develop database report
• Learn how to use Oracle 10g software tools to develop integrated database applications
• Create PL/SQL named program units stored on the server or client machine
• Become familiar with DB administration tasks and how to use the Web based Oracle Enterprise Manager
• Learn critical-thinking techniques for solving unstructured problems by identifying and analyzing an information systems problem and designing a working database system
• Learn problem-solving skills for solving Oracle database problems

Software
To complete all lessons, assignments, and tests, you will need to access a computer with:

• Windows XP, Internet Explorer, and PowerPoint
• Oracle 10g Developer Suite
• Student Data Files (you can download it from the textbook Web site or from the Resources Web page on the class WebCT site )

Oracle Accounts
To access Oracle 10g DBMS on our Department server, you have to use your account:

• User Name: lastname_firstname
• Password: sidXXXX ( XXXX are the last four digits of your CSU ID)
• Host: orcl

Methods of Instruction:

• Lectures
• Problem-Solving Assignments
• Tests

Class Lectures
The CPSC 3132 class will meet regularly TR from 9:30 a.m. - 10:45 a.m. at CCT 407. The lecture topics covered in the class follow the course schedule. Each student is expected to attend all class lectures, to read the textbook chapters, make notes, and complete all case studies covered in the class.

Assignments
Problem-solving activities as designing and developing source code, compiling and debugging, running and testing of programs cannot be learned simply by reading a textbook. You must practice, practice, and practice solving different problems by implementing real programs. Eight assignments about database design and implementation, SQL coding for inserting, updating, deleting, and retrieving database content will be assigned and graded. Late assignments are not accepted for credits.All assignments are due on the day given in the assignment, no later than 11:59 PM EST. See the Schedule and Assignments Web pages of the class Web site for details.

Tests
Four tests are scheduled. They will be timed, take-home tests delivered through WebCT Vista. During the test you have to solve a problem writing a SQL, PL/SQL code, developing database forms, reports, or database integrated application. You can use your textbook, the student data files, slides, notes, and Internet resources. No make up test will be given unless a test was missed due to a documented emergency.

Evaluation
The final grade will be obtained from the following:

The letter grade will be assigned as follows:

Grading Example:

G = 75*0.40 + 85*0.6 = 81.00
It is a B.
Passing grade for this class - C (see the catalog).

Student Responsibilities

Each student is responsible to

• manage his/her time and maintain the discipline required to meet the course requirements;
• read from the textbook all topics covered in the class;
• attend class regularly and actively participate in classroom discussions;
• complete assignments by their due dates;
• take the tests as they are scheduled in the course schedule;
• abide by documented lab rules;
• respect the value of the other students' time while in the classroom, this means no surfing the Web or playing games;
• read any e-mail sent by the instructor and respond accordingly.

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

While in the classroom, students should turn off cell phones or place them on vibrate. In addition, to be respectful of other students' time and money, playing games, chatting, and/or surfing the Web is not allowed since these activities can be distracting to other students.

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

Academic Dishonesty
Academicdishonesty includes, but is not limited to, activities such as cheating andplagiarism ( Misconduct). 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 inwriting with a copy placed in the Department's files. Students will be expectedto discuss the academic misconduct with the faculty members and the chairperson.For more details see the Faculty Handbook: theStudent Handbook:

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.