CS340 Final Portfolio

Completed during Course: Introduction to Databases

User Interface

http://classwork.engr.oregonstate.edu:39021/

Citations

Source code from CS340 starter code and Flask development article was used to learn how to implement our web app with blueprints. However, other than the general structure of the files and functions, the specific code within the SQL files, the route.py files, the templates, and overall functionality of the previous files, in terms of how it's used in our web interface and for our specific database, is unique.

Complete Source URLs:

• Activity 1: https://canvas.oregonstate.edu/courses/1987790/pages/activity-1-creating-a-customer-object-table?module_item_id=25022975

• Activity 3: https://canvas.oregonstate.edu/courses/1987790/pages/activity-3-creating-transaction-and-category-tables?module_item_id=25022977

• Flask Documentation Home Page: https://flask.palletsprojects.com/en/stable/

• Modular Applications with Blueprints: https://flask.palletsprojects.com/en/stable/blueprints/#my-first-blueprint

• Exploration: https://canvas.oregonstate.edu/courses/1987790/pages/exploration-developing-in-flask?module_item_id=25023028

• Flask Starter App: https://github.com/osu-cs340-ecampus/flask-starter-app

• app.py file from bsg_people: https://github.com/osu-cs340-ecampus/flask-starter-app/blob/master/bsg_people_app/app.py

• People.j2 file from bsg_people: https://github.com/osu-cs340-ecampus/flask-starter-app/blob/master/bsg_people_app/templates/people.j2

Specific Citations

For all templates

• File: Routes for Events CRUD implementation
• Database: SQL
• Revised: 9 March 2025
• Sourced from: Oregon State Univerity Ecampus Course CS340 - Exploration - Developing in Flask
• Source URL: Exploration: https://canvas.oregonstate.edu/courses/1987790/pages/exploration-developing-in-flask?module_item_id=25023028 Flask Starter App: https://github.com/osu-cs340-ecampus/flask-starter-app app.py file from bsg_people: https://github.com/osu-cs340-ecampus/flask-starter-app/blob/master/bsg_people_app/app.py
• Originality: Source code from app.py was used to start this assignment, and learn how to utilize routes and implement CRUD functionalities. The following code is unique other than database connection code and the general structure of the file.

For all routes.py files

• File: Routes for Entities CRUD implementation
• Database: SQL
• Revised: 9 March 2025
• Sourced from: Oregon State Univerity Ecampus Course CS340 - Exploration - Developing in Flask
• Source URL: Exploration: https://canvas.oregonstate.edu/courses/1987790/pages/exploration-developing-in-flask?module_item_id=25023028 Flask Starter App: https://github.com/osu-cs340-ecampus/flask-starter-app app.py file from bsg_people: https://github.com/osu-cs340-ecampus/flask-starter-app/blob/master/bsg_people_app/app.py
• Originality: Source code from app.py was used to start this assignment, and learn how to utilize routes and implement CRUD functionalities. The following code is unique other than database connection code and the general structure of the functions.

For app.py

• File: Initiailizing app
• Database: SQL
• Revised: 9 March 2025
• Sourced from: Flask Documentation
• Source URL: Flask Documentation Home Page: https://flask.palletsprojects.com/en/stable/ Modular Applications with Blueprints: https://flask.palletsprojects.com/en/stable/blueprints/#my-first-blueprint
• Originality: Source code from article was used to learn how to implement an app with blueprints. The following code is unique other than the general structure of the file.

For DDL.sql

• File: Data Definition Queries using Data Definition Language
• Database: SQL
• Revised: 25 February 2025
• Sourced from: Oregon State Univerity Ecampus Course CS340 - Activity 1/2/3
• Source URL: Activity 1: https://canvas.oregonstate.edu/courses/1987790/pages/activity-1-creating-a-customer-object-table?module_item_id=25022975 Activity 3: https://canvas.oregonstate.edu/courses/1987790/pages/activity-3-creating-transaction-and-category-tables?module_item_id=25022977
• Originality: Source code used for inspiration to complete this assignment. Query structures are based on examples within the source code, but the specific attributes and entities are specific to our unique db.

For DML.sql

• File: Data Definition Queries using Data Definition Language
• Database: SQL
• Revised: 25 February 2025
• Sourced from: Oregon State Univerity Ecampus Course CS340 - Activity 1/2/3
• Source URL: Activity 1: https://canvas.oregonstate.edu/courses/1987790/pages/activity-1-creating-a-customer-object-table?module_item_id=25022975 Activity 3: https://canvas.oregonstate.edu/courses/1987790/pages/activity-3-creating-transaction-and-category-tables?module_item_id=25022977
• Originality: Source code used for inspiration to complete this assignment. Query structures are based on examples within the source code, but the specific attributes and entities are specific to our unique db.

For main.css files

• Structure of CSS files originate from a personal project of Siya Sonpatki's with significant revisions for this project.