|
|
| Course Description
The course provides the basic concepts of database systems, with a
practical focus for undergraduate students. It familiarizes
students with relational database and
SQL.
At the conclusion of
CS364, students will be able to
- organize, maintain and retrieve information from a relational
database
- design a relational database (client-server app) observing system life cycle
- integrate emerging Internet technologies in
databases
- apply ORACLE software
Students are allowed to use any client software to
interface Oracle database (web-/ non-enabled ). |
|
| Textbooks
Database Systems by P. Rob and C.
Carlos, 7th ed., Course Technology
2007
Acquire Oracle Certification !
OCP Oracle DBA certification boxed set by Couchman
Jason
|
|
| Grading
The grading scale for all assignments and examinations is as follows:
- A 90 - 100 %
- B 80 -
89 %
- C 70 - 79 %
- D 60 - 69 %
- F
0 - 59 %
Final grades will be based on 5 components as weighted below:
- Attendance/Homework
20 %
- Midterm Exam 20 %
- Project /
Presentation 30 %
- Final Exam 30 %
Any component submitted after the due date earns
automatic 30 % deduction. To get a passing grade all components must be
done or an incomplete grade will be awarded. |
|
Miscellaneous
Policies / Responsibilities
- Students are expected to come to class prepared (have textbook and
have read required assignments), and submit homework on time avoid
penalty. If a student is not able to attend class, student should
contact the instructor prior to class.
- Projects will be executed in groups or teams. Other activities
must be done individually to avoid penalty. Make-ups and incompletes
are not encouraged and can only be granted for rare cases. Avoid
submitting virus-infested disks or a score of zero will be awarded.
- The instructor may revise this syllabus as deemed necessary.
- All misconducts will be forwarded to the Chair after the first
warning.
|
|
| American With
Disabilities Act
Any student whose disability falls within ADA guidelines and who is
registered with the Adaptive Needs Program should inform the instructor
during the first week of class of any special needs or equipment
necessary to fulfill the requirements of this course. Students who have
or may be dealing with a disability should speak with the disability
office (260-481-6657). |
|
| Course
Content: (Warm and interactive
lecture with demonstration.) |
| Chapters
|
Lecture Topics
|
| Chapter
1
|
Introduction to Database Systems
|
| Chapter
2
|
Relational Database Model |
| Chapter
3
|
Entity-Relationship Model
|
| Chapter
4
|
Schema Refinement & Normalization
|
| Chapter
5
|
SQL: Queries, Programming, Triggers
|
| Chapter 6 |
Database Design |
| Chapter
7
*
|
Relational Algebra and
Calculus |
| Chapter
8*
|
File Organizations and
Indexing - Tree & Hash |
| Chapter |
Data Mining |
|
| Other Info:
Instructor Dr. E. Udoh, Phone
260-481-6946, Room ET 125P, Email udohe@ipfw.edu,
Lecture Time: Tuesday & Thursday 3 - 4:15 PM /
4:30 - 5:45 PM
Office Hours: Tuesday 10:15 - 11:15 AM & 2 -
3 PM
(Students are required to adhere to these times
or send me an email).
* This course is designed with the interest
of the student at heart. Get involved, no student can afford to be a
spectator in computer science!
|
|