Term Project
A Database Application with Web/Smartphone Interface
Due Date for Demonstration and Report: Dec 29, 2022
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:
- Database backend: The application must use a backend database for data management.
- Browser/Smartphone frontend: The users are allow to access the application any where using Web browser or smart phone.
- New user registration: A new user must register for a permission to access the application.
- Login/Password: A registered user must login with username and password to access the application.
- Insert/Delete/Update: The application must allow the users to perform operations directly or indirectly corresponding to the insertion, deletion and update of data items in the database.
- Query/Search: The application must also allow the users to search for desired data items corresponding to the querying of the database.
- Session/Transaction: A user interacts with the application in a session-based conversation allowing the user to construct a complete transaction of operations.
- Confirmation/Commit: A confirmation process must be performed before actually carrying out the set of operations in the transaction.
- Persistence: Once the transaction is committed, the effects must be persistent.
- DBA interface: 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.
