7 short labs in Database

GEIT 3341 DATABASE I LAB 3

GEIT 3341 Database I

Lab 3

Web Development with Apex II

Due Date:

Submission Method: Demo

Objective(s) Target CLO(s) Reference How to develop a web database 5 Instructor Demo application using Oracle Application Any book and/or Express. In today’s lab, you will learn tutorial on Oracle how to develop a web application from Application Express existing tables.

Name

ID

Section

Instructions: This is a hands-on step-by-step lab that will teach you how to

• Build a first cut of an app based on existing tables

• Learn how to install a dataset to generate the tables needed by the application

• Learn how to add pages, and link pages

GEIT 3341 DATABASE I LAB 3

PART 1: Preparing the dataset (0.5 point)

1. From your APEX workspace home page, select SQL Workshop, click Utilities, and then click Sample Datasets.

2. On the Project Data row, click Install.

3. Click Next. 4. Click Install Dataset. 5. Click Exit.

PART 2: Creating the Application (5.5 points)

A. Step 1: Creating and naming the app 1. In the App Builder menu, click App Builder. 2. Click Create. 3. Click New Application 4. In the Create Application wizard, for Name enter Lab3_ID 5. Click Set Appearance button in Appearance. 6. On the Appearance dialog, for Theme Style select Vita – Slate. 7. Click Choose New Icon.

8. On the Choose Application Icon dialog, select an icon color and an icon of your

choosing. Click Set Application Icon. 9. Click Save Changes.

GEIT 3341 DATABASE I LAB 3

B. Step 2: Add the dashboard page 1. In the Create Application wizard, click Add Page

2. Click Dashboard.

3. For Chart 1, enter the following:

Pay attention! Don’t click Add Page.

GEIT 3341 DATABASE I LAB 3

4. Click Chart 2, and enter the following:

5. Click Chart 3, and enter the following:

6. Click Add Page

C. Step 3: Add the project page

1. In the Create Application wizard, click Add Page. 2. Click Cards. 3. On the Add Cards Page, enter the following:

4. Click Add page

D. Step 4: Add the Milestone Pages 1. In the Create Application wizard, click Add Page. 2. Click Interactive Report. 3. On the Add Report Page, enter the following:

4. Click Add Page

GEIT 3341 DATABASE I LAB 3

E. Step 5: Add the Tasks Pages(Faceted Interactive Report and Calendar) 1. In the Create Application wizard, click Add Page. 2. Click Faceted Search. 3. On the Add Faceted Search Page, enter the following:

5. Click Add page

6. Place the Tasks Search page up under the Dashboard page. After the edit button, drag and drop the tasks search to place it under the dashboard page.

7. In the Create Application wizard, click Add Page. 8. Click Interactive Report and fill it with the following.

8. In the Create Application wizard, click Add Page 9. Click Calendar. 10. On the Add Calendar Page, enter the following:

GEIT 3341 DATABASE I LAB 3

F. Step 6: Generating the App 1. Scroll to the bottom of the page, and click Create Application.

2. Once the application has been generated, your new app will be displayed in the

application home page. Click Run Application. 3. Enter your user credentials. Click Sign In. 4. Your runtime environment is ready! Play around with the new application!