CHAVANNI is a stock broker system that allows customers to invest and trade in shares. It has two users - brokers and customers.
So, this application provides a comprehensive and user-friendly platform for stockbrokers and their clients. It simplifies the work of stockbrokers and provides their clients with a seamless investment experience.. So, Whenever anyone wants to trade in stocks he/she needs to create a trading account and then they can start buying or selling the stocks. The broker is an admin who has all the data related to stocks as well as users. So basically it’s a system that manages client and their holdings.
Broker
- Login with fixed credentials
- View all customers
- Add new stocks
- View all stocks
- Delete customer
- Delete stock
- Logout
Customer
- Sign up with first name, last name, username, password, address, mobile number, and email
- Login with their own credentials
- View all stocks
- Buy and sell stocks
- View holding
- Add and withdraw funds to and from wallet
- Logout
Fields: customer_id, first_name, last_name, username, password, address, mobile_number, email, stock_id, stock_name, quantity, price_per_share, transaction_id, transaction_type, date, amount, wallet_id, balance, timestamp, is_deleted
customers has a one-to-one relationship with wallet stocks has a many-to-many relationship with customers through transactions table is_deleted field is added to all tables to mark records as deleted instead of actually deleting them
Clone the project to your local machine.
Install the required dependencies.
Update the properties file with database credentials.
Run the project from the main class.
Use the project based on the user type - broker or customer.
Appropriate exceptions will be thrown for invalid data entry, such as duplicate email or incorrect stock name.
- Java
- MySQL
- JDBC
- STS
I believe constructive criticism is a good thing. So any Feedback is appreciated. Thank you for your time.