Bank Management System

This project is a Bank Management System designed to handle various banking operations, such as managing accounts, processing transactions, and handling bank applications.

Database Structure

Database: bank_1

This database is responsible for managing core banking operations, including customer accounts, staff details, transactions, and vault management.

Tables:

account

CREATE TABLE account (
    account_number INT(10),
    password VARCHAR(255),
    name VARCHAR(255),
    email VARCHAR(255)
);

customer

CREATE TABLE customer (
    account_number INT(10),
    name VARCHAR(255),
    email VARCHAR(255),
    balance DECIMAL(10,2),
    nid CHAR(10),
    date_of_birth DATE,
    join_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

staff

CREATE TABLE staff (
    user_id INT(11) AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    password VARCHAR(255) NOT NULL
);

transaction_history

CREATE TABLE transaction_history (
    time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    from_account_number INT(10),
    to_account_number INT(10),
    transaction_type VARCHAR(255),
    amount DECIMAL(10,2)
);

vault

CREATE TABLE vault (
    bank_name VARCHAR(256),
    bank_master_account INT(10),
    balance INT(10)
);

Database: bank_system

This database handles the management of bank applications and approved banks.

Tables:

bank_applications

CREATE TABLE bank_applications (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    bank_name VARCHAR(100) NOT NULL,
    owner_name VARCHAR(100) NOT NULL,
    approved TINYINT(1) DEFAULT 0
);

banks

CREATE TABLE banks (
    id INT(11) AUTO_INCREMENT PRIMARY KEY,
    bank_name VARCHAR(100) NOT NULL,
    account_number INT(10) NOT NULL,
    balance DECIMAL(10,2) NOT NULL
);

Features

• Account Management: Handles customer accounts, including creation, authentication, and balance management.
• Transaction Processing: Records all transactions between accounts, maintaining a comprehensive history.
• Staff Management: Manages staff details and access to the system.
• Vault Management: Manages the bank's central vault, keeping track of the master account's balance.
• Bank Applications: Handles the application process for new banks, including approval and management of approved banks.

Technologies Used

• MariaDB: For managing and storing the relational data across the two databases.
• SQL: For querying and manipulating the database.

Setup and Installation

1. Clone the repository.

[git clone https://github.com/your-username/your-repo.git](https://github.com/ovijitM/Banking_system_with-Php-Xmpp-.git)
cd your-repo

2. Configure the database connections in the project to connect to bank_1 and bank_system.
3. Import the provided SQL files to set up the bank_1 and bank_system databases.
4. Run the application.

License

This project is licensed under the MIT License - see the LICENSE file for details.