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

Course Description: Concepts and Techniques of data organization and access; basic data structures, file organization and processing; database modeling and processing; database management systems, database analysis and design, and data administration.

Prerequisites: IFS 302 and Junior Standing

Objectives: To familiarize students with the syntax of Structured Query Language (SQL), and Using SQL to access Relational Database Management Systems (RDBMS),
To understand the role of RDBMS and front-end tools in Client-Server Computing,
To understand the role of network technology in the context of C/S computing,
To learn to Use PowerBuilder as a front-end tool, and
To develop an understanding of Graphical User Interface Design Guidelines

Text: “Instant SQL Programming,” Joe Celko, Wrox Press -1995 Edition or later.
“Official PowerBuilder 6.0 Fundamentals,” Craig Levin - ITP - 1998 Edition or later.

Important Dates:
January 12 - Classes begin
January 17 - Last day to register or enter a course, Last day to withdraw with 100% refund (U/G, Chase)
January 19 - Martin Luther King Day - No Classes
February 1 - 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).
February 16 - President's Day - University Closed No Classes
March 8-13 - Spring Break - No Classes < BR> March 27 - Last day to drop a full term course with a grade of W
Final Examination - May 11 (Tuesday)


Grading:
Four Unannounced Quizzes - 15% Each,
Project - 20%
Final Examination - May 11 (Tuesday)

Tentative Schedule:
SQL - Joe Celko
Introduction to SQL Chs.1-2 (Ch.3 - Exercise 2 in Levin)
SQL Arithmetic, Keys, Referential Integrity, and Basic Data Manipulation Chs.3-5
Advanced Data Manipulation (Joins, Aggregate Functions, and Subqueries) Chs 6-10
Embedded SQL and Cursors - Ch.11
LEVIN - POWERBUILDER
Basic PowerBuilder Environment Chaper 1, 2 & 3
Enhancing Your Application - Ch.4
Enhancing the Design - Ch.5
Programming with PowerScript - Chs. 6, 7 & 8
GUI Design - Chs.9,10 &11
Adding Value to Your Application 12 & 13
Additional Resources: Internet NewsGroup comp.soft-sys.powerbuilder