1. Homepage
  2. Programming
  3. CS425 Database Organization - Course Project: Banking Application Development

CS425 Database Organization - Course Project: Banking Application Development

Engage in a Conversation
USIITCS425Database OrganizationBanking ApplicationSQLIllinois Institute of Technology

Project Description

Overview

In this project you will develop a banking application that allows customers to manager their accounts and bank employees to run analytical queries and manage customers. CourseNana.COM

Users

The application should support two main types of users: CourseNana.COM

  • customers
  • employee

Employees are either tellersloan specialists, or managers which each have different permissions in terms of what data they can access and what operations they can execute through the application. CourseNana.COM

Data

Branches

  • Branch: The bank operates multiple branches. For each branch we need to record the address at which the branch is located.

Employees

  • Employee: employees can be either tellers, loan specialists, or managers. For all employees we need to record personal information like their name, address, and SSN. Furthermore, we want to record their salaries and which branch they are working for.

Customers

  • Customer: For customers we record their name and addresses and their home branch.

Accounts

  • Account types: the bank has several account types a customer open, e.g., a variety of checking and saving accounts. Some accounts pay interest of a fixed interest rate. Some account types disallow negative balances (transactions resulting in negative balances would be rejected) and some account types will charge overdraft fees if the balance is below 0. Some account have monthly fees which may depend on the balance of the account (e.g., a checking account may waive its monthly fees if the account balance is more than $50.000).
  • Accounts: accounts have an account numbers and an account type (e.g., a checking account with certain benefits). We need to keep track of the current balance of an account. An account is owned by one or more customers.
  • Transactions: we also want to keep track of the transactions for each account. A transaction has a type (deposit, withdrawal, transfer, \ldots), an amount (e.g., positive for deposits and negative for withdrawals), and a description.

OPTIONAL BONUS: loans

  • Loans: Customers can have loans which have an amount, a runtime, and an interest schedule.

Access Control

  • customers should have only access to their accounts
  • tellers can read the current account balance of a customer and execute withdrawal and deposit transactions
  • managers can access all information
  • loan managers (in case you are implementing the bonus loan management) have access to loan information and customer information

Application

The application should distinguish at login between the four possible roles: managers, loan managers, tellers, and customers. Different functionality is available depending on which role is logged in. CourseNana.COM

Account Transactions

  • can be executed by: tellers, customers (for their own accounts only), managers
  • withdrawl removes some dollar amount from the balance of an account.
  • deposit increases the balance of an account.
  • transfer moves money from one account to another (customers can move money from one of their accounts to another person's account.
  • an external transfer moves money between an account of this bank to an account of another bank.

Account Management

  • can be executed by: customers (for their own accounts), managers
  • create, delete accounts
  • show statement for a month: the statement of a (past) month of an account should list all the transactions for this account during this month order by time. Furthermore, the account balance after each transaction should be shown. Finally, you should show the final account balance for the account at the end of the month.
  • show pending transactions: pending transactions are the transactions of the current month that are not part of a statement yet.
  • can be executed by: managers
  • add interest, overdraft fees, account fees: this adds interest to all account for the manager's branch and applies overdraft fees for accounts with negative balances (for account types which have overdraft fees).

Analytics

  • can be executed by: manager

This feature can be used by managers to answer questions like the ones shown below (come up with your own ideas of what other analytical queries could be relevant). CourseNana.COM

  • calculate the total net worth of all customers from a branch or across all branches

Get in Touch with Our Experts

WeChat WeChat
Whatsapp WhatsApp
US代写,IIT代写,CS425代写,Database Organization代写,Banking Application代写,SQL代写,Illinois Institute of Technology代写,US代编,IIT代编,CS425代编,Database Organization代编,Banking Application代编,SQL代编,Illinois Institute of Technology代编,US代考,IIT代考,CS425代考,Database Organization代考,Banking Application代考,SQL代考,Illinois Institute of Technology代考,UShelp,IIThelp,CS425help,Database Organizationhelp,Banking Applicationhelp,SQLhelp,Illinois Institute of Technologyhelp,US作业代写,IIT作业代写,CS425作业代写,Database Organization作业代写,Banking Application作业代写,SQL作业代写,Illinois Institute of Technology作业代写,US编程代写,IIT编程代写,CS425编程代写,Database Organization编程代写,Banking Application编程代写,SQL编程代写,Illinois Institute of Technology编程代写,USprogramming help,IITprogramming help,CS425programming help,Database Organizationprogramming help,Banking Applicationprogramming help,SQLprogramming help,Illinois Institute of Technologyprogramming help,USassignment help,IITassignment help,CS425assignment help,Database Organizationassignment help,Banking Applicationassignment help,SQLassignment help,Illinois Institute of Technologyassignment help,USsolution,IITsolution,CS425solution,Database Organizationsolution,Banking Applicationsolution,SQLsolution,Illinois Institute of Technologysolution,