|
MASTER SYLLABUS |
|||||||||
|
CSIT 2425 (formerly CST 2425) |
|||||||||
| Class Hours: 3.0 | Credit Hours: 4.0 | ||||||||
| Laboratory Hours: 3.0 | Revised: Spring 04 | ||||||||
| NOTE: This course is not designed for transfer credit. | |||||||||
| Catalog Course Description: | |||||||||
| A comprehensive study of SQL using the Oracle relational database management system. Hands-on training will include the use of SQL*PLUS, database creation, data queries, view definition and use, operators and functions, security, calculation, indexing, utilities, and data transport. | |||||||||
| Entry Level Standards: | |||||||||
| The student should be able to use a standard keyboard and maintain 10 words per minute error-free typing rate. The student must have math, writing, verbal and English language skills at the college entry level. | |||||||||
| Prerequisites: | |||||||||
| CSIT 1810 and one programming course | |||||||||
| Textbook(s) and Other Course Materials: | |||||||||
| Required:
Textbook: Database Systems using Oracle, by Nilesh Shah, Prentice Hall, 2002. Textbook: Oracle 9i the Complete Reference, by G. Koch, McGraw-Hill, 2002. Supplies: Five 3-1/4" HD floppy diskettes or 2 zip disks. |
|||||||||
| I. Week/Unit/Topic Basis: | |||||||||
| Week | Topic | ||||||||
| 1 | Introduction/review, relational and object-oriented databases, normalization | ||||||||
| 2-3 | Oracle overview, basic SQL*Plus, basic SQL, table creation & modification | ||||||||
| 4-5 | Inserting and modifying data, constraints, sub-queries, joins, scalar data types | ||||||||
| 6-7 | Views, indexes, sequences, record locks, basic privileges, SQL*Plus reports | ||||||||
| 8-9 | PL/SQL language, data manipulation, transaction control, data types | ||||||||
| 10-11 | Cursors, exceptions, triggers, procedures, functions, packages | ||||||||
| 12 | Composite data types: records and tables | ||||||||
| 13 | Oracle database administration | ||||||||
| 14-15 | Oracle development tools (forms/reports using GUI wizards), Web tools | ||||||||
| 16 | FINAL EXAM | ||||||||
| II. Course Objectives*: | |||||||||
| A. | Develop a working understanding of the terminology associated with relational database processing. III, VII, VIII, IX | ||||||||
| B. | Become familiar with, have a working knowledge of, and demonstrate efficient use of: SQL, ORACLE and the SQL* product enhancement tools. IV, V, VI, VII, VIII, IX, XII | ||||||||
| C. | Develop a working relational database and develop restrictive access conditions appropriate for entering, modifying and producing output to an I/O device. III,IV,VI | ||||||||
| D. | Set-up, create filespace and provide environmental conditions to provide a user with a working SQL relational database. III,IV | ||||||||
| E. | Become familiar with issues related to data access, security, file allocation and process control. III, VII, VIII, IX | ||||||||
| *Roman numerals after course objectives reference goals of the CSIT program. | |||||||||
| III. Instructional Processes*: | |||||||||
| Students will: | |||||||||
| 1. | Use professional tools to produce software components and documentation. Technological Literacy Outcome, Personal Development Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 2. | Participate in a team using shared resources. Communication Outcome, Problem Solving and Decision Making Outcome, Personal Development Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 3. | Practice elements of the work ethic such as punctuality, professionalism, dependability, cooperation, and contribution. Personal Development Outcome | ||||||||
| 4. | Use professionally accepted methods and materials in their approach to completion of applications. Technological Literacy Outcome, Personal Development Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 5. | Create database forms and reports based on client input. Communication Outcome, Problem Solving and Decision Making Outcome, Technological Literacy Outcome, Information Literacy Outcome, Personal Development Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| *Strategies and outcomes listed after instructional processes reference Pellissippi States goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process. | |||||||||
| IV. Expectations for Student Performance*: | |||||||||
| Upon successful completion of this course, the student should be able to: | |||||||||
| 1. | Demonstrate proficient use of terminology associated with computers, software and database applications products. A,B,C,D,E | ||||||||
| 2. | Demonstrate an understanding of the use of hardware, firmware and systems terminology. A,B,C,D,E | ||||||||
| 3. | Demonstrate effective use of various manuals, documentation, tutorials, on-line directives and guides. A,B,C,D | ||||||||
| 4. | Demonstrate knowledge and use of major Oracle functions, commands and processes. A,B,C,D,E | ||||||||
| 5. | Demonstrate proficient use of the keyboard and mouse in accessing programs, data and/or files. A,B,C,D,E | ||||||||
| 6. | Demonstrate use of major SQL* tools commands and processes. B,D,E | ||||||||
| 7. | Demonstrate use of all major SQL programming commands and selections. B,D,E | ||||||||
| 8. | Demonstrate effective use of Oracle as a business tool. A,B,C,D,E | ||||||||
| *Letters after performance expectations reference the course objectives listed above. | |||||||||
| V. Evaluation: | |||||||||
| A. Testing Procedures: | |||||||||
| A minimum of two tests is recommended. Tests will cover material presented in class. Tests are not to be missed without a valid excuse. | |||||||||
| B. Laboratory Expectations: | |||||||||
| Lab attendance is required. Assignments will be given and must be completed and handed in at the designated date and time. | |||||||||
| C. Field Work: | |||||||||
| N/A | |||||||||
| D. Other Evaluation Methods: | |||||||||
| Class participation, quizzes and homework will also comprise the final grade for the course. | |||||||||
| E. Grading Scale: | |||||||||
| 93 100
A
88 92 B+ 83 87 B 78 82 C+ 73 77 C 65 72 D Below 65 F |
|||||||||
| VI. Policies: | |||||||||
| Attendance Policy: | |||||||||
| Pellissippi State Technical Community College expects students to attend all scheduled instructional activities. As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course (Pellissippi State Catalog). | |||||||||
| Academic Dishonesty: | |||||||||
| Plagiarism, cheating and other forms of academic dishonesty are prohibited. A student guilty of academic misconduct, either directly or indirectly through participation or assistance, is immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions that may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course. | |||||||||
| Other: | |||||||||
| 1. Plagiarism,
cheating, software piracy, non-educational use of computer systems and
other forms of academic dishonesty are strictly prohibited. A student caught
cheating or infracting specific rules will be given a grade of "F" for
the course.
2. Make-up exams: All exams are required, and make-ups will be allowed only in the rarest of cases. In the event of an emergency, notification of the instructor must be made in advance. 3. It is the student's responsibility to request help
from the instructor prior to an assignment's due date.
|
|||||||||