| Instructor: |
Peter Ping Liu, Professor, Ph D, PE,
OCP, CQE and CSIT |
| Office: |
4032 (304D) Klehm Hall
|
| Phone: |
(217)581-6267 (with voice mail)
|
| Email: |
pliu@eiu.edu |
| Course
Description: |
Study of advanced database technology (Oracle) for
applications in contemporary industry including architecture,
operations, system maintenance and management. |
| Credit: |
2-2-3 |
| Prerequisite: |
Experience with and access to high performance computer
which allows students to install their own Oracle software. System
requirements: RAM >128 MB and enough hard drive capacity, Windows
98/NT/2000. |
|
Course Objectives:
|
Students will:
- Demonstrate
principles of design, development, and administration relevant
to Oracle database technology.
- Formulate
a working definition of database development and administration.
- Identify
the contemporary architecture of database systems.
- Survey the
characteristics of widely used hardware, operating systems
, and software for the database technology applications.
- Apply advanced
database technology to manage operations in industry.
- Gain a working
knowledge of developing and maintaining a small-scale database
project.
- Develop skills
of leadership, problem solving, and communication.
- Participate
in local (e.g., EIU list server) and external (e.g., Oracle
Technology Network) electronic discussion groups on Oracle
database technology.
- Discuss issues related to Internet-centered revolution
in computer technology.
|
| |
| Readings: |
 Textbook:
Bobrowski, S., Oracle 8i for Windows NT: Starter Kit, Berkeley:
Osborne/McGraw-Hill (c2000).- Internet: http://www.oracle.com
and other web sites.
- Assigned Readings in Database Technology
|
| |
| Course Outline: |
-
Principles and applications of database
technology
-
Installing Oracle
Project I
-
Configuration and architecture of Oracle
Project II
-
Database access with SQL
Projects III, IV
-
Programming with PL/SQL
Project V
-
Building a database
Project VI
-
Security and resource management
Project VII
-
Database space management
Project VIII
-
System backup and recovery
Project IX
-
System performance tuning
-
Final Project
|
|
|
| Evaluation: |
A total score will be calculated using the
following weighted percentage:
|
Discussion
|
20%
|
|
Projects
|
45%
|
|
Mid-term test
|
10%
|
|
Final project
|
25%
|
Individual grade is based on the total score using the following
scale:
|
Total >= 90
|
A
|
|
80 <= Total <90
|
B
|
|
70 <= Total < 80
|
C
|
|
60 <=Total < 70
|
D
|
|
Total< 60
|
F
|
|
| |
| ADA Statement: |
If you have a documented disability and wish
to receive academic accommodations, please contact the Coordinator
of the Office of Disability Services (581-6583) as soon as possible. |
| Unofficial Definition of Professor: |
Those who go to college and never get out of college. |
