SQL App
Scent of Death
My Approach
My Approach
Aimed to dive deep into the workings of a SQL database in its raw form.
While cloud databases offer convenience, wanted to grasp the fundamentals, learning how things work at the core.
It was all about gaining a fundamental understanding of SQL databases, and this project provided the perfect opportunity for that.
My Approach
Vision and Innovation
My Approach
The vision for the "SQL App" catered to teachers needing a user-friendly tool to manage students' marks in a school database.
The innovation lies in enabling teachers to create, edit, and delete student records using their ID's, streamlining the process of managing student data efficiently.
My Approach
Resolving Complex Problems
My Approach
The main complexity of this project revolved around effectively managing classes of data elements and tables and ensuring their proper placement within the database.
Unlike in tools like Excel, there was no visual representation to guide the process, making it more complex.
My Approach
Identifying Unique Challenges
My Approach
One unique challenge we encountered in developing the app was creating a cursor class from scratch.
This cursor class was essential for traversing through each row in the database to retrieve the desired results.
My Approach
User-Centric Design
My Approach
For a user-centric design, the app incorporated basic Android UI elements and a simple form structure.
This approach aimed to provide users with a familiar and intuitive interface.
My Approach
Meeting User Needs
My Approach
The app was designed with a focus on basic usage, catering to everyday needs rather than professional use.
It efficiently handled essential functions like create, edit, delete, and retrieve.
It was built with proper anchoring, ensuring smooth operation across multiple Android versions.
My Approach
Screenshots
Skills
Android Studio
Java
