Oracle Designer Tutorial


Prev Next

Chapter 2
Preparing for the tutorial

This chapter describes the tutorial in this document, and includes the following sections:

Scope of the tutorial

This tutorial does not attempt to describe in detail the functionality of every component of Oracle Designer. Instead, the tutorial concentrates on how to use the components together to progress from a high level business model to a working generated application. For comprehensive information, refer to the Oracle Designer help system.

Note that to enable you to use several different Oracle Designer product components within a relatively short period, the tutorial assumes a very small business scenario. This scenario is not representative of the more sophisticated environments in which Oracle Designer is typically used.

Time to allow for the tutorial

The length of time to allow to complete the tutorial will depend on:

Typically, allow 2 to 3 hours to complete the tutorial.

How to follow the tutorial

Before you follow the tutorial, the TUTORIAL workarea and application system must have been imported into the repository. (If you are responsible for importing these, refer to Appendix A for more information.)

To follow the tutorial for the first time, you must begin by ensuring that the database tables that will be created during the tutorial do not already exist. You do this by following the instructions in the next section "Removing existing tutorial tables". The remainder of this chapter sets the scene for the tutorial.

Start the tutorial with the first task in Lesson 1 and continue until you reach the end of the final task in the last lesson. If you attempt to start the tutorial half way through, you will be unable to complete some of the lessons.

If you want to take a break during the tutorial and resume later, we suggest you stop between lessons, rather than in the middle of a lesson.

Removing existing tutorial tables

To remove existing tutorial tables:

  1. Select the Drop Tutorial Tables program in the Oracle Designer Tutorial folder

    The SQL*Plus window appears.

  2. When prompted to enter a username, enter the username, password and database you will be using to follow the tutorial on one line, in the following format:

    Enter user-name:<your_username>/<your_password>@<your_database>

    For example, if the username is ‘analyst’, the password is ‘teachme1’ and the database you are using is called ‘olympic’, you would type the following:

    Enter user-name:analyst/teachme1@olympic

    If you are not sure what to enter, ask your system administrator.

    You are prompted to confirm you want to delete the following tables (if they exist):

    CUSTOMERS
    ORDERS
    PRICED_PRODUCTS
    ITEMS
    PRODUCTS

    Do not delete these tables unless you are sure these tables are no longer required. If you are not sure, type N and press [Return]. Ask your system administrator to create a new user for you to follow the tutorial, and repeat steps 1 and 2.

  3. To delete the tables, type Y and press [Return].

    The tutorial tables are removed.

    When the operation is complete, you are prompted to close the window.

  4. Type EXIT and press [Return] to close the SQL*Plus window.

To drop the tutorial tables after you have completed the tutorial:

For more information, refer to Lesson 11, "Conclude the Tutorial".

Background to the tutorial

Analysts and developers at a pizza delivery company called Speedy Pizza have already carried out some analysis and design activities to produce a system for taking customer orders and dispatching pizzas.

Your task is to make additions to the design of the system and to implement a small part of it.

In particular, you will create an on-screen form for entering details of the company's new products. These details will be stored in a database that you will design and create.

If you have Oracle's Web PL/SQL Generator installed, you can implement the same system as a web application.

During this Tutorial

During the course of this tutorial you will make the necessary changes to the information held in the Oracle Designer repository. You will:



Next

Prev

Next

oracle.gif (1205 bytes) 
Copyright © 2000 Oracle Corporation.  
All Rights Reserved.