The objective of this tutorial is to expose you to some important features and tools of Oracle Designer/2000 and Developer/2000. You will learn how to use Designer/2000 and create E-R diagrams, Function Hierarchy diagrams, Process diagrams, and Data Flow diagrams that are needed to design a database and implement a user defined system in client's organization. Later on, in this tutorial, you will also learn the basics of Developer/2000 that will help you create forms, reports, and screens, and finally generate a working application system.

Tutorial Overview:

The project you will work on this tutorial will be to build a hypothetical "Student Registration System"-- a system that manages student requests for enrollment in courses at a university. This highly simplified system will have Student Information, Course Information and also data regarding the enrollment of students in different courses.

This tutorial will have 13 lessons. 1-11 are currently here, and 12-13 will be posted soon. Please note that these lessons have not yet been copyedited. Once they are, the revisions will be posted here.

These lessons will focus on:

• Lesson 1
  • Logging on to Designer/2000 and creating a new application system
• Lesson 2
  • Creating dataflow diagrams using the Dataflow Diagrammer
• Lesson 3
  • Creating process maps using the Process Modeller
  • Differences between the Process Modeller and the Dataflow Diagrammer
• Lesson 4
  • Creating functional hierarchies using the Function Hierarchy Diagrammer
• Lesson 5
  • Creating E-R models using the ER Diagrammer
  • Understanding some of the differences in modeling conventions/ notations of Hoffer, George & Valacich (1999). and Oracle Designer/2000
• Lesson 6
  • Converting the E-R model to a physical database design using the Database Design Transformer
• Lesson 7
  • Creating matrix diagrams using the Function Hierarchy Diagrammer and the Matrix Diagrammer
• Lesson 8
  • What is Developer/2000
  • Logging on to Developer/2000 and creating new modules and forms using the Datablock Wizard and the Layout Editor
• Lesson 9
  • Adding objects to the basic form and writing simple triggers to add more functionality
• Lesson 10
  • Adding alerts and creating procedures
• Lesson 11
  • Designing reports using the Report Editor

Main Page About the Book Student Resources Oracle Resources Instructor Resources Contact Us