GenAI-Powered Database Race in Oracle APEX

Objective:

Students will learn how to use GenAI to rapidly design and implement a database prototype for RPM Pittsburgh in Oracle APEX, including an optional app built on top of the database.

Setup:

1. Company Overview: RPM Pittsburgh (https://www.rpmpittsburgh.com/).
   Students explore the site to understand core business needs, like managing tenants, properties, payments, and maintenance requests.

2. Team Assignments:

   • Front-End Team: Focuses on user-facing data, such as the tenant and property owner interactions.

   • Back-End Team: Focuses on operational data, like properties, tenant records, and maintenance requests.

3. Winner Criteria:

   • First team to build a realistic database prototype in Oracle APEX wins.

   • Bonus points for creating a simple app (optional) based on their database.

Instructions for Students:

1. Understand the Requirements

   • Spend 10-15 minutes reviewing the RPM Pittsburgh website to identify key data entities and relationships.

   • Front-End Example: Tables for users, login details, property views.

   • Back-End Example: Tables for properties, tenants, maintenance requests.

2. Generate SQL Script Using GenAI

   • Use your preferred GenAI tool (e.g., ChatGPT, GitHub Copilot, Bard).

Prompt Example:
Generate an SQL script for a database to manage tenants, properties, maintenance requests, and payments for a property management company.

2. • Review the script for realism and completeness. Make edits if necessary.

3. Build the Database in Oracle APEX

   • Create a new workspace in Oracle APEX.

   • Run the SQL script to create tables and relationships.

   • Test your schema by entering sample data.

4. (Optional Bonus) Build an App

   • Use Oracle APEX’s app builder to create a simple app interface:

     • Front-End Team: A property search or tenant login portal.

     • Back-End Team: A maintenance request tracker or tenant database viewer.

5. Submit Your Prototype

   • Ensure your prototype includes realistic entities, relationships, and attributes.

   • Take screenshots of your database schema and any apps created.

Deliverables:

1. A working database prototype (tables with PKs and FKs) in Oracle APEX.

2. (Optional) A simple app built on top of the database.

Evaluation and Winner Selection:

• The first team to complete a realistic prototype wins:

  • One winner for the front-end team.

  • One winner for the back-end team.

• Bonus recognition for teams that build a functional app on top of their database.

Learning Experiences for You (I hope :)

• Real-Time Competition: Rewarding is based on speed and accuracy.

• Practical Focus: Teams see their efforts turn into tangible results in Oracle APEX.

• Real-World Context: Working on a business problem makes the task relevant and engaging.