Skip to content

To Track & Manage Income or Expense Transaction of an user. Working Demo Link:

Notifications You must be signed in to change notification settings

vivekVells/Salary-Manager-Java-MySql-Project

Repository files navigation

View all of my Projectworks - click over here -> Vivek Vellaiyappan Project Works

Salary Manager

Project Working Demo Video: https://youtu.be/JTzFz7wpwvk

Documentation: Link

  • Kindly view the above documentation link to review all of the works I have done for this particular project that involves
    • designing the database
    • how i modularized the codes by blocks
    • architecture diagrams (ER diagram, Block Diagram)
    • db commands used (DDL, DML) - triggers usage

Objective

  • To track and manage the income and expense transaction of a person

Languages Used

  • Java
  • MySql (via JAVA JDBC Connectivity)

Features

  • Create an User Account
  • Enter Income or Expense Information
  • View Income or Expense or Net Balance Summary Information

Project SourceCode:

Concepts Learnt & Practiced

  • Efficience & Importance of DataBase Designing
    • DML, DDL, Triggers and Variables
    • Normalization & Bridge/Junction
    • How to avoid data redundancy and mantain data integrity
    • Entity Relationship Diagram
  • OOPS concepts
    • Modularity of the code blocks which enabled to understand the value of code reusability
  • JDBC stuffs
    • Connection Establishing, Statement Creation, ResultSet retrival
  • How to export and execute a runnable Jar file
  • How to clear previous output in the windows console
  • How to send email using javax.jar file

Future Code

  • Little tweaks
  • Moving to better GUI

About

To Track & Manage Income or Expense Transaction of an user. Working Demo Link:

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages