Term Project
A Database Application with Web or Smart Phone Interface
Due Date for Demonstration and Report: Jan 20, 2021
In this term project, you are to exercise the entire process of database application development through the design and implementation of a database application with Web and/or smart phone interface using popular tools like PHP/MySQL and Python/PostgreSQL. You are free to choose any application domain you like. However, your application must have the following characteristics:
- The application must use a backend database for data management.
- The users are allow to access the application any where using Web browser or smart phone.
- A new user must register for a permission to access the application.
- A registered user must login with username and password to access the application.
- The application must allow the users to perform operations directly or indirectly corresponding to the insertion and deletion of data items in the database.
- The application must also allow the users to search for desired data items corresponding to the querying of the database.
- A user interacts with the application in a session-based conversation allowing the user to construct a complete transaction of operations.
- A confirmation process must be performed before actually carrying out the set of operations in the transaction.
- Once the transaction is committed, the effects must be persistent.
- For extra credit, you may design an extra interface for the system administrator to manage the database on-line. Or, you may design an APP to access your application on a mobile device.
Things to Do
- Propose an application of your choice.
- Conduct a requirement analysis to obtain the data requirement and function requirement of the target application.
- Draw the ER/EER diagram for your application.
- Convert the ER/EER diagram into a set of relation schemas.
- Design the application protocol(s) that may be required in your application.
- Design and implement your database application.
- Document the entire process by writing a project report.
- Demonstrate your application to the instructor and submit your report at the same time.
- Be prepared to explain your design and program while demonstrating your application.
