Expense Tracker DBMS Project

Overview

This Expense Tracker DBMS (Database Management System) project is designed to help users manage and track their expenses efficiently. The project uses SQL for database management and PHP for server-side scripting.

Features

• User authentication: Register and login functionality to secure user data.
• Expense management: Add, edit, and delete expenses with details such as category, amount, and date.
• Category management: Manage expense categories for better organization.
• Summary and reports: View expense summaries and generate reports based on different criteria.

Technologies Used

• Database: SQL (Structured Query Language)
• Server-Side Scripting: PHP
• Front-End (Optional): HTML, CSS, JavaScript (You may choose to create a separate front-end application or integrate this with an existing one.)

Setup Instructions

Database Setup:

• Create a new database for the project.
• Import the provided SQL script to set up the necessary tables and initial data. The database is in db folder named dbmoney.sql

$ mysql -u your_username -p your_database < dbmoney.sql