Database & UI Design
Study Project
This project was part of the database study course. The goal was to create a fictional mobile application database, define the app's operations, and design UI mockups.
The tasks included defining use cases and user stories, creating a database schema, and writing SQL scripts and queries.
We chose to design an app for a fictional company called Rubrica. The app's purpose is to help employees manage their work projects and schedules more efficiently. It includes essential features for project management, collaboration, and communication, such as the ability to book meeting rooms, make notes, and create to-do lists.
This was a pair assignment, and we divided the tasks equally. I was responsible for designing the UI mockups using Figma.
Year
2022
The project involved describing the app’s operations and structure by creating use cases, user stories, and a schema with the most essential tables and their relations.
The main part of the project involved writing SQL scripts to create the database tables and test data, as well as developing SQL queries to extract meaningful information from the stored data.
At the end of the project, I designed the UI mockups of the application to provide a more concrete picture of the fictional app.
Key Takeaways
Ideated a fictional app concept and defined its features.
Wrote user stories to capture the app's functionality from the user's perspective.
Created a database schema to structure the app’s data.
Developed SQL scripts and queries to manage and extract meaningful data.
Designed UI mockups using Figma to visualize the app’s interface.