It is a one-semester course, which deals with mastering Rapid Applications Development (RAD) for DB systems. The course is divided roughly into five parts. The first of these consisting of a deep study of Normalisation theory and schema refinement by Normalization (1NF trough 5NF); it includes overview of functional dependencies and schema refinement by Normalization (1NF trough BCNF), Multivalued Dependencies and 4NF, Higher Level Normal such as 5NF and Domain Key Normal Forms (DKNF), Practical concerns about Normalization. The second part deals with PL/SQL Programming, consists on deep study of the language including Built-in Data Types, Control Flow Constructs, Designing and Implementing Cursors, Triggers, Procedures, Functions and Packages. The third part focuses on learning functionalities of CASE Tools and 4GLs for database design (Oracle Designer), Rapid Application Development (RAD) and GUI design (Oracle Developer: Forms, Graphics and Reports).The Fourth part concerns the DB technology; it deals with technology of a DB server such as Concurrency Control and Query Optimization, Distributed Architectures including Client/Server, Distributed DB and Two-Phase Commit Protocol. The fifth part deals with supporting DB interaction on the World Wide Web, it consists in learning how to design Data-Intensive WEB sites and studying techniques and tools for DB access through the WEB. The last part consists in studying procedures, policies and techniques of Managing DB Environment including both data and DB Administration.
