Rapid Development with Oracle CASE®

Chris Billings is a founding member of Renaissance Computer Education and Consulting, a firm established to provide high-quality computer training and Oracle consulting. Chris Billings specializes in Oracle CASE tools as well as in 3GL languages and development environments. Maria Billings is a founding member of Renaissance Computer Education and Consulting, a firm established to provide high-quality computer training and Oracle consulting. Maria Billings served as an international trainer and consultant for Oracle Corporation. She has taught courses in Oracle RDBMS, CASE, and programming tools, as well as structured development techniques. 0201633442AB04062001

1. Introduction.


Aims of this Book.



A Little Background.



Workshop Timeline.



2. Planning.


A CASE Study Scenario.



The Workshop Method.



Preparing for our Workshop.



An Introduction to the Team.



Interviewing for Business 'Direction' and Boundaries.



On Introductory Briefings.



On Interviewing.



How to Begin?



Our Directional Interviews.



Recording Strategy-level Information.



Access to CASE.



Initial Set-up of an Application.



Diagramming Functions in CASE.



Designer I Using the Entity Relationship Diagrammer.



Strategy Summary.



3. Analysis.


Preparing for a Detailed Look at the Business.



An Analysis Interview.



Reaching Elementary Functions and Avoiding Mechanisms.



On Normalization.



More Details.



Refining Entities in CASE Dictionary.



Defining Attributes in CASE Dictionary.



On Domains.



Unique Identifiers.



Business Units.



Using Dataflow Diagrams.



Cross-checking with the Matrix Diagrammer.



Reports during Strategy and Analysis.



On Feedback Sessions.



4. Data Design and Implementation.


Preparing for the Design of a Relational Database.



On Denormalizing.



Creating Table and Tablespace Definitions.



Default Database Design.



Creating Sequence Definitions.



A Detailed Look at Column Definitions.



Column Validation and Derivation.



On Edit Text.



Key Constraints Referential Integrity.



On Indexes.



Additional Design Issues.



Creating a Relational Database with the DDL Command Generator.



Implementing Reference Tables.



So Where Are We?



5. Application Design and Implementation.


Creating Module Definitions.



Refining Module Definitions.



Detailed Data Usage of Modules.



On User Preferences.



Specifying Links.



CASE Generator for SQL Forms.



Further Examples.



Designing and Generating a Report.



SQL Plus Reports.



SQL ReportWriter Reports.



Designing and Generating, and Testing Menus.



Project Delivery.



Additional References.



Appendix A: User Extensibility.


Appendix B: Reverse Engineering and other Re-Words.


Appendix C: Journaling.


Appendix D: Diagrams.


Appendix E: List of Figures. 0201633442T04062001