CS 340 Database Project (Group 111)

This web application is a Pokemon database called “Bill’s PC Pokemon Database.” The homepage serves as an index page that links to all entity pages. Each page supports full CRUD functionality for its entity. The Capture page demonstrates relationship functionality between Pokemon, Trainers, and Locations.

Database Entities

The database includes the following entities:

• Pokemon
• Trainers
• Locations
• Captures
• Types

Link to project

[http://classwork.engr.oregonstate.edu:9112/]

Tools used

HTML, CSS, JavaScript, Handlebars, Express, Node, MySQL

We are using Node.js with Express.js for the backend, Handlebars for templating, and MySQL with the mysql2 driver for the database. Environment variables are managed with dotenv, and stored procedures are used for Create, Update, and Delete operations.

Citations

Module 6: Exploration - Web Application Technology

Source code for setting up the web app adapted from module 6 materials. Canvas Link

Module 7: Exploration: PL/SQL part 2, Stored Procedures for CUD

Source code for stored procedures adapted from module 7 materials. Canvas Link

Module 8: Exploration: Implementing CUD operations 8 in your app

Source code for CUD operations adapted from module 8 materials. Canvas Link

OpenAI

ChatGPT was used as a resource to help understand Handlebars templating syntax, minor stylistic choices, and interface alignment.