Objective:

You are required to create a list of tables and columns for a Banking Management System that manages customer information, accounts, transactions, and branches. Your task is to identify relevant tables and specify key columns for each.

Requirements:

You will need to define the necessary tables and columns to support the following functionalities required for the Banking Management System.

1. Customer Management

• Tracking customer details (name, contact info, account type)
• Customer account creation and management
• Managing customer addresses, identification documents
• Customer onboarding and offboarding processes

2. Account Management

• Account creation and closure
• Managing account types (savings, current, loans)
• Interest calculation and statement generation
• Integration with transactions and balance tracking

3. Transaction Management

• Recording transactions (deposits, withdrawals, transfers)
• Managing transaction types (cash, check, online)
• Transaction approval workflows
• Tracking failed or fraudulent transactions

4. Loan Management

• Loan application and approval process
• Interest rate management for loans
• Repayment schedules and tracking

5. Card Management

• Assing credit or debit cards to the accounts
• Track credit limits
• Track credit used and available credit

6. Fund Transfer

• Ability to transfer funds into other bank accounts
• Add and update beneficiary information
• Initiate fund transfer

7. Employee and Branch Management

• Record Employee details
• Organizing branches (e.g., New York, Los Angeles, Chicago)
• Assigning employees to branches
• Branch resource management and reporting

Sample Tables:

Note: These are just a few example tables; you will need to design additional tables based on the functionalities outlined above for the Banking Management System.

Customers
Accounts
Transactions
Branches

Sample Columns:

Table Name: Customers

• CustomerID: Unique identifier for each customer (Primary Key)
• FirstName: Customer's first name
• LastName: Customer's last name
• AccountID: Foreign key referencing the Account table

Additional Guidelines:

• Ensure every table has a primary key.
• Define foreign keys where needed to establish relationships between tables.
• Include important columns relevant to the business scenario (e.g., for customers, include columns like DateOfBirth and PhoneNumber).

Final Notes:

We recommend that you define the necessary tables and columns, along with sample data, using tools like Google Sheets or any relational database design tool.

Students enrolled in our online Zoom class will receive guidance throughout this assignment, and their progress will be manually reviewed incrementally until they reach a certain level of completion.

As a beginner, it is recommended that you complete the table and column listings for 50-75% of the functionalities mentioned above. Completing listings for 100% of the functionalities is a real BONUS.

GOOD LUCK WITH YOUR ASSIGNMENT!!!

Don't forget to contact us if you need any further assistance with your assignments, and most importantly, for a manual review and approvalof your work.

To gain complete access, login with gmail or outlook, no need of signup. click here

SAMPLE TABLE DESIGN