Entities and Attributes of Online Banking System
1. Customer
- CustomerID (primary key): Unique identifier for each customer
- Name: Name of the customer.
- Address: Address of the customer.
- Contact: Contact details of the customer (e.g.: Phone number).
- Username (Unique) : username to login to the banking system.
- Password: Encrypted password of the user.
2. Account
- AccountID (primary key): Unique identifier of account.
- CustomerID (foreign key referencing Customer): Identifier of the customer who owns the account.
- Type: Defines the account type whether savings, current etc.
- Balance: Amount of money available in the account.
3. Transaction
- TransactionID (primary key): Unique identifier of the transaction, automatically increments.
- AccountID (foreign key referencing Account): Identifies the account where the transaction took place.
- Type: Defines the transaction type i.e. deposit or withdrawal.
- Amount: Shows the balance amount used for the transaction.
- Timestamp: The date and time of the transaction.
4. Beneficiary
- BeneficiaryID (primary key): Unique identifier of the beneficiary.
- CustomerID( foreign key referencing Customer): Identifies the customer who added the beneficiary.
- Name: Name of the beneficiary.
- AccountNumber: Account Number of the beneficiary.
- BankDetails: Bank Name of the Beneficiary added.
How to Design a Database for Online Banking System
Designing a relational database for an online banking system is an important and interesting task that requires careful planning and consideration. The database serves as the backbone of the banking system that stores and organizes large amounts of financial data securely.
In this guide, we will explore How to Design a Relational Database for an Online Banking System by designing the entity relationship diagram and Database Model with the help of various required entities, attributes, and relationships.
Contact Us