Project: DBMS-backed Web Application

The goal of this assignment is for you to

1. learn and practice how to build a DBMS-backed web application that addresses a realistic problem,
2. practice the software engineering skills of requirement analysis, software design, implementation, and testing.

You are free to choose an application that is interesting or useful to you; however,

1. your application must have at least 2 (html) screens.
2. your application should deal with data that needs to be persisted in a DBMS.
3. your application should BOTH write and read data to/from a relational DBMS (noSQL data stores are not allowed).
4. your application must not be a trivial extension of Assignment 3.

You must build your web application using one of the following environment:

• Java+J2EE+JSF+JDBC with glassfish and Oracle DBMS. You may use the web application you developed in Assignment 3 as a starting point, but obviously, turning in Assignment 3 (or trivial extensions thereof) for this project assignment will get zero credit.
• Python with Flask Framework and Oracle DBMS. You can connect to Oracle DBMS in Python using the cx_Oracle module.

If you are not sure if your application idea would meet the requirements, please discuss with the instructor.

This is an individual assignment.

What to Submit to Laulima

1. A zip file of the source code including DDLs for creating the DBMS tables
2. A link to a 5-minute screencast/video that is a “sales pitch” to present and demo the application you have built. You can use the online tool screencast-o-matic.com to record the screencast.