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 app operations and design UI mockups.
Tasks included defining use cases and user stories, creating database schema and making SQL scripts and queries.
We chose to design an app for a fictional company named Rubrica. The idea of the app was to make it easier for employees to manage their work projects and schedule. App includes all important features employees need to manage their projects smoothly and stay in contact with their colleagues. One can also book a meeting room, make own notes and to-do -lists with the app.
This was a pair assignment. We divided the tasks equally and I also designed the UI mockups with Figma.
Year
2022
Project included describing the operations and the structure of the app by creating use cases, user stories and a schema with most necessary tables and their relations.
The main part of the project was to make SQL script that created the database tables and test data and to create SQL queries that provided meaningful information about the data stored in the database.
At the end of the project, I designed the mockups of the application’s user-interface to give more concrete picture of the fictional application.
Key Takeaways
Ideate a fictional app
Write user stories
Create schema
Make SQL script and queries
Create mockups with Figma