This project focuses on the development of ConcertSaver, a mobile application designed to provide users with discounted concert tickets. The system aims to simplify the process of finding and purchasing concert tickets at reduced prices, making concerts more accessible and affordable for a wide range of users.
This project was created in collaboration with my teammate, Charlotte Isabel Busse Mejia. Charlotte was responsible for the planning and developing of the SQL database.
The primary objectives of this project are to:
- Develop a database system to manage concert-related data efficiently.
- Design and implement user-friendly interfaces through mockups.
- Create detailed and optimized SQL queries for data handling and analysis.
- Present the project with a clear and engaging PowerPoint presentation.
- User Registration: Account creation to access discounts.
- User Login: Secure login with optional social media integration.
- Concert Search: Search for concerts by keywords, city, venue, or artist, with filtering options.
- View Concert Details: Display detailed information, including prices and discounts.
- Ticket Purchase: Add tickets to a cart, proceed to checkout, and receive a QR code upon confirmation.
- Conceptualized the idea of ConcertSaver and outlined the core features and functionalities with Charlotte.
- Designed the database schema to efficiently manage and organize concert-related data with Charlotte.
- Designed and structured presentation slides.
- Illustrated technical and business aspects with high-quality visuals.
- Created user interface prototypes using tools like Figma and Adobe XD.
- Simulated user interactions to optimize system usability.
- Wrote and optimized SQL queries for data manipulation.
- Tested query accuracy and ensured alignment with project requirements.
- Database Management: MySQL, PostgreSQL, SQLite
- Mockup Design: Figma, Mockup world
- Presentation: Microsoft PowerPoint
- Schema Design: Miro
DBConcertSaver_Group4 08032024.sql: Database schema and initial data.SQL Queries_Group4 08032024.sql: Queries.SQL project_ConcertSaver_Group4.pdf: Mockup Design and Presentation.
We are proud to share that this project received a perfect score of 30/30 as part of the Project Instructions & Delivery assignment submitted on March 8, 2024.
This report is the final project for the Information Management and Databases course at Laurea University of Applied Sciences in Finland.
Thank you for exploring our project! Feel free to reach out for collaboration or questions.