/ShopAppDatabase

Project for "Databases" subject with a Pilot Application written in Java , connected to a MySQL database.

Primary LanguageJava

Music Instruments Store Database Project

Overview

This repository contains the code for a pilot application developed as part of a university database course project. The project focuses on creating a database-backed application for managing and selling musical instruments. The application is designed to interact with a MySQL database created using MySQL Workbench.

Features

  • Product Management: The application allows users to add, view, and update information about musical instruments, including details such as name, category, price, and quantity available.

  • Order Processing: Users can place orders for instruments, and the application updates the inventory accordingly. It tracks order details, including customer information, ordered items, and total cost.

  • Database Integration: The application seamlessly integrates with a MySQL database created in MySQL Workbench. The database stores information about instruments, orders, and customers.

Technologies Used

  • Frontend: JavaFX
  • Backend: Java
  • Database: MySQL
  • Database Design: MySQL Workbench