Oracle Designer Tutorial |
This chapter describes the tutorial in this document, and includes the following sections:
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.
The length of time to allow to complete the tutorial will depend on:
Typically, allow 2 to 3 hours to complete 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.
The SQL*Plus window appears.
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.
The tutorial tables are removed.
When the operation is complete, you are prompted to close the window.
For more information, refer to Lesson 11, "Conclude 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 the course of this tutorial you will make the necessary changes to the information held in the Oracle Designer repository. You will:
|
|