STUDY RESOURCES

Instructor: Dr. Vijay V. Raghavan
Office: BEP 447
Office Hours: 3:00 – 6:00 Tuesdays & 3:00 – 4:00 Thursdays
E - Mail: raghavan@nku.edu
Web Page: http://www.nku.edu/~raghavan

Course Description: Advanced database design concepts from an applied perspective; Advanced SQL with special focus on subqueries and different types of joins, creating and managing indexes, writing triggers and stored procedures, loading data into database tables from flatfiles.

Prerequisites: Certified Information Systems Major and Senior Standing

Text Books: Modern Database Management, 6e, Hoffer, Prescott and McFadden, © 2002 - ISBN 0-13-033969-5.
Oracle 8 Programming - A Primer © 2000 / 0-201-61258-5 By Rajasekar Sunderraman


Important Dates:
August 25 - Classes begin
August 30 - Last day to register or enter a course, Last day to withdraw with 100% refund
September 13 - Last day to drop a course without a grade appearing on student's permanent record (U/G); Last day to drop a course with 50% refund (U/G).
October 20-21 Fall Break – No Classes
November 1 - Last day to drop a full term course with a grade of W
November 26-29 Thanksgiving Holidays – No Classes
Final Examination – December 18 (Thursday)

Grading:
Four unannounced quizzes 15% each; Assignments 20%;
Final Examination – December 18 (Thursday)  - 20%

Tentative Schedule:

TThe Context Of Database Management.

1. The Database Environment.
2. The Database Development Process.
Database Analysis.

3. Modeling Data In The Organization.
4. Advanced Data Modeling.
Database Design.

5. Logical Database Design And The Relational Model.
6. Physical Database Design And Performance.
9. The Client/Server Environment.
10. The Internet Environment.
11. Data Warehousing.
Advanced Database Topics.

12. Data And Database Administration.
13. Distributed Databases.
14. Object-Oriented Data Modeling.
15. Object-Oriented Database Development.
The following sections will be covered from the Sunderraman text
SQL; Relational Algebra; Sub queriesPL-SQL Program Structure, Procedures and PackagesTriggers

The class is an advanced fast-paced class on database concepts and design. Students are expected to handle operational-environment problems in mature manner, allocate time outside of class to finish assignments and read materials assigned to get ready for each class.