Lead Instructor:
Dr. Frank
Chao
Office:
LeMay Hall, Cubicle
#19, 3rd Floor
Phone: (919) 662-3656
Office Hours:Posted In Blackboard
Textbook(s):
Title: None
Special Instructions: Students should read the
Characteristics of a Successful Online Student
(http://www.waketech.edu/dist_ed/internet/studchar.html) and take the
Successful Internet Student Self-Assessment
(http://www.waketech.edu/dist_ed/internet/assessment.html) BEFORE
enrolling in an online course at Wake Tech.
Software used to complete
coursework: Oracle9i
or 10g
Other
required equipment:
Intel compatible PC
Credit Hours: Three (3) Semester
Hours
Pre-requisites: CIS115
Co-requisites: none
Course
Description:
This
course introduces database design theories and analyses. Emphasis is
placed on normalization, data integrity, and data modeling. Upon
completion, students should be able to design normalized database
structures which exhibit data integrity and understand the Oracle
architectural components.
Course Goals:
- Data Models
- Normalization
- SQL
- Role and Use of Relational Design
Course
Objectives:
Upon
successful completion, students will be able to demonstrate (through
completion of classwork and assignments):
- Modeling
- Normal Forms
- SQL
- Relational Design
| The Core Values of Wake Technical
Community College |
| Respect |
Instructor and students will foster an
environment that is respectful of all. |
| Responsibility |
Instructor and students will foster an
environment that promotes taking responsibility for one's actions
and obligations. |
| Critical Thinking |
Instructor and students will strive to improve
the critical thinking skills of analysis, synthesis, and
evaluation. |
| Communication |
Instructor and students will strive to ensure
that both written and oral communications are clearly
understood. |
| Collaboration |
Instructor and students will strive to develop
collaborative skills. |
| Grading Is As
Follows: |
| Attendance |
20% |
none |
| Assignments |
20% |
none |
| Midterm |
20% |
none |
| Semester Project |
40% |
none |
Classroom
Policies:
- Students are responsible for all of the information presented in the
Wake Technical Community College Student Handbook.
- Please note that computers are to be used at all times for official
course purposes. Use of computers for general web
surfing, email, chat rooms, etc. is not allowed. Violation of this rule
will result in a grade deduction and possible loss of computer
privileges.
- The college forbids the use of audible electronic equipment (cell
phones, pagers, etc.) during instructional time.
- If you miss a lecture or arrive late, you are responsible for the
material presented, handouts distributed, and any announcements made
that day. The instructor will not provide notes for missed classes.
Tentative
Schedule
Note: This schedule is
subject to some changes/modifications per Instructor -- This offered
as only a study guide. The pace of each class differs according to
the instructional needs of the students in the class. Always consult
with your instructor. Note** A Final Project may be assigned in leiu
of a Final Exam. |
| Unit |
Coursework |
Textbook/Assignments |
|---|
| 1 |
Introduction to databases and Oracle CASE approach |
none |
| 2 |
Data Modeling Stages |
none |
| 3 |
Data Modeling and Database Design |
none |
| 4 |
Basic Conceptual Modeling (continued) |
none |
| 5 |
Entities and Relationships |
none |
| 6 |
Relationships and Attributes |
none |
| 7 |
Table Normalization |
none |
| 8 |
Midterm |
none |
| 9 |
Introduction to Oracle and Oracle installation |
none |
| 10 |
Basic SQL Skills in Oracle (I) |
none |
| 11 |
Basic SQL Skills in Oracle (II) |
none |
| 12 |
Basic SQL Skills in Oracle (III) |
none |
| 13 |
Basic SQL Skills in Oracle (IV) |
none |
| 14 |
Basic SQL Skills in Oracle (V) |
none |
| 15 |
Database Project |
none |
| 16 |
Database Project Submission |
none |
Disability Support
Services is available for students who require academic
accommodations due to any physical, psychological, or learning
disability. To determine eligibility, contact the office at 108-S
Holding Hall or call
662-3405 (TDD 779-0668)
|
Copyright
2004/2005 Wake Technical Community College All Rights
Reserved |
