How to use db connection in transaction and bank statement

Assignment Help Web Project
Reference no: EM132309372

Secure Bank Pty. Ltd

Task 1

INTRODUCTION

Secure Bank Pty. Ltd. has started its bank services and is in early stage of their business. Being in 21st century, ease of access and user friendly are the two most important factors in any service offered by the banks. To increase their business and attract more customers they have decided to develop a web site where customers would be able to perform all the banking activities without any hassle.

DETAILS

The site includes functions such as Accounts, Transactions, eStatements, Transfer & Pay, Manage, and Message. More detailed sub-menus are possible and the client is happy for you to suggest a possible solution. If you implement the site with those functions as placeholders only is fine as it is PART 1.

The website should have 3 different account types.

1. Bank Manager: This account should be able to add/remove any account.

2. Business Account

3. Savings Account

DELIVERABLES

Opening Account(s)

Menu option: Accounts, Transactions, eStatements, Transfer & Pay, Manage, and Message

At least a couple of transactions are stored

View the balances of accounts

POINTS TO CONSIDER FOR FUTURE DEVELOPMENT

As it is a prototype version (PART 1), the client (Secure Bank Pty. Ltd.) will ask you to include more functions. At the same time, the client is open to any suggestions from you.

PLANNING & DEVELOPMENT CONSIDERATIONS

Planning the site.

• Plan a site overall in the first place is a crucial step to construct a site. Understand the client’s needs and plan accordingly. For example, planning a design theme for the site with variations of the theme that may be used for sub sections is a recommendation.

Develop using the appropriate tools.

• HTML 5 for static content.

• Cascading Style Sheets (CSS) for formatting.

• JavaScript, Ajax and jQuery for client-side interactivity. (Mainly for PART 2)

• PHP for dynamic content and server-side interactivity (Mainly for PART 2)

• MySQL for data storage and retrieval.

Apply consistent structure.

The files needed for the web site will be included in a single folder (directory) - the name of this folder is the same as your alacritas username. The files must be organized into sensibly chosen subfolders (i.e. sub-folder for CSS or sub-folder for images, etc.).

All semantic structure of the website is controlled by “HTML”. Pay close attention to the elements that you use - make sure that you use the most appropriate element for the kind of text you are marking up.

All layout and other details of the appearance of the website are controlled by valid CSS rules. You place the overall CSS rules in an external style sheet.

All client side behavior of the website (the response to mouse clicking or keyboard reaction) are controlled by valid JavaScript / Ajax / jQuery.

All data is stored in the MySQL database.

Description of Task – Part 1

HOME PAGE

This is the starting/entry point to the Site which will have:

• a registration page

• login/logout section

• any information about the site and

• placeholders of other menu option: Accounts, Transactions, eStatements, Transfer & Pay, Manage, and Message

• links to each page, if it is relevant.

Note: For Assignment (Part 1) the login/logout section does not need to authenticate a user.

REGISTRATION PAGE

This is where new users can register to use the system. However, this is guideline/suggestion ONLY. You may create your own design of tables.

Further details are in the DETAILS section above.

Proper input validation must be applied at this point including:

• double entry password check

• password is:

o 8 to 12 characters in length

o Contains at least 1 lower case letter, 1 uppercase letter, 1 number and one of the following

special characters ~ ! # $

VIEW ACCOUNT PAGE(S)

Other functions will include Accounts (to view balance), Transactions, eStatements, Transfer & Pay, Manage, and Message. You may include these menu options as placeholders only in Part 1 of Assignment according to your design decision. More detailed sub-menus are possibilities.

Task 2

INTRODUCTION

Your prototype is implemented with the clients feedback. Now we need to make it fully functional. A general member may have one or two accounts: general savings and business accounts. Although transactions for both could be the same, the only difference is the limit on daily transactions in amount. Manager has a different access level to manage everyone’s accounts and their requests of creating accounts or ordering credit card, etc. can be granted.

As a bank website, there are three different access levels:

Public user, General member (Account Holder), and Bank Manager

All pages of the website contains the following sections:

1. Header section of each page contains the title of the page, e.g. Savings Account, Business Account, or Manager Area.

2. Main content per page based on your design.

3. Navigation with its own design.

4. When login is successfully: welcome text message (Not pup-up nor alert) with an account name (e.g. Welcome William) with the relevant contents. Last access time is displayed.

a. Member of bank

i. Account details

ii. Optionally two different accounts

b. Manager

i. Account management table is displayed.

ii. ID (auto generated), Username, Name, DoB, Email, Account type, and Access

1. Access column displays two options as drop down list, i.e. bank account holder, or manager so that the manager can change another person’s access level.

5. Logout button: short message with the logout time

6. Footer section: your username and student number

DESCRIPTION on TASKS Part 2

DETAILS

To use the online Banking system, customers must first register by providing their Name, E-mail address, mobile phone number, account type (business or savings) and password. A bank account number should be allotted and the user should be able to use the services.

The website should have 3 different account types.

Username is displayed in its relevant page and it is unclickable after logging in.

1. Bank Manager

2. Account Holder

a. Savings Account

b. Business Account

I. Bank Manager

This account should be able to add/remove any account.

Should be able to approve transactions over $25000.

Should be able to view all transactions history in a day, week, month and last three months.

II. Business Account

This account should be able to conduct transactions up to $50000/day.

Should be able to send/receive in different currencies (USD, AUD, GBP and etc.)

III. Savings Account

This account should be able to conduct transactions up to $10000/day.

Should be able to send/receive in only local currency (AUD).

The other features of Banking website are:

1- Inter-bank Funds Transfer (between different banks)

2- Intra-bank Funds Transfer (within the same bank)

3- Bill payments (e.g. Power, Water, Phone and NBN) – user can add different organisation to make a transaction

4- Bank Statements (1 month ($2.5 fee), 3 month ($5 fee) and 6 month ($7 fee))

5- Credit card request (annual fee for savings account ($50) for business account ($100))

6- Transaction history (up to 3 months)

Money Transfer type: Inter and Intra

These items should be provided:

From: BSB and Account Number

To: BSB and Account Number (In Inter-bank case, another field for “Bank Name” should be there)

Amount: In AUD (Inter and Intra in case of savings account)

In Foreign Currencies (Inter banking in case of Business account)

Purpose: Reason for transferring (e.g. Family support, loan payment, School tuition fee etc)

Confirmed message including transaction details is to displayed at the end of transaction.

Bill Payments

From: BSB and Account Number

Bill Type: e.g. Water, Power, Phone or NBN

Amount: In AUD

Bank Statement

In the start of bank statement current account balance should be there along with the account details (like normal bank statement).

Period: 1 month, 3 months or 6 months – date can be chosen by a user.

Fee: Fee should show up based on the period and deducted from account balance

Data available in bank statement:

Date, From account, To account, Debit or Credit, Purpose, Amount and transaction ID.

Reference no: EM132309372

Questions Cloud

What is a decentralized federation : What is a decentralized federation? How does it differ from a coordinated federation and centralized hub?
Discuss the accounting principles in brief : Use the Internet to research a company that had a change in accounting principles within the past five (5) years. Discuss the accounting principles.
Discuss how the investors or securities markets will react : ACC00712 - Business Accounting - Southern Cross University - analysis of Australian financial regulatory framework, discuss what are the fundamental
Analysis of the missed opportunities for innovation : Write a 200-300 word business proposal to the organization's Board of Directors to revitalize the organization through some well thought out innovative.
How to use db connection in transaction and bank statement : KIT502-Web Development,University of Tasmania,Australia: Plan a site overall in the first place is a crucial step to construct a site.
Determine best methods of public administration strategies : The main theme of the conference is to determine the best methods of public administration strategies and models in federal agencies in the United States.
Determine the appropriateness of decision making : Determine the appropriateness of decision making in terms of professional standards and ethics. Apply advanced federal taxation concepts to business situations.
Discuss how an organisation approach to csr : Discuss how an organisation's approach to CSR can impact on its strategic priorities? You may use appropriate frameworks and examples to support your answer.
Ethically questionable over the past year : Has Take-Two Interactive Software, Inc. taken any actions, though legal, that may be ethically questionable over the past year?

Reviews

len2309372

5/21/2019 2:31:44 AM

Have implemented a functional site with requirements of both the site operator and user in professional manner All the requirement completed in professional manner including different access level of different users and fully functional management Implemented all required functions (Bank manager, business account, savings account, Money transfer, bill payments, and Bank statement function) in a professional manner Have completed all the requirements to a high level, with a consistent, professional look and feel throughout. In addition to useful and meaningful comments in the code, human readable comments included for better maintainability

len2309372

5/21/2019 2:29:48 AM

those files are materials which I think can help with understanding of this assignment. More specifics, what I want you help me to do is to finish the second part which showed in the second file and there are also marking criteria in the third file. This assignment including two parts, I finished the first part and due last month which showed the information in the first file, the reason why I post as well, is because the second part is fully and further functional for bank in this case, and it is based on first part, so I post all sources about this assignment. In the first part, we achieved some basic and simple functions of this bank, I can deal with it , but I think second part is too difficult for me cause I don't have IT background. We are studying basic web development project, so maybe it is easy for you to do, so I think you can finish without complex coding. Also I think this assignment allowed database connection in transaction and bank statement .

Write a Review

Web Project Questions & Answers

  Evaluating an ecommerce website

Create a check list that contains key point for evaluating an ecommerce website - Write a short, reflective report about website

  Gpc and runtime magic quotes

Create a script that lets you know whether Zeus or Helios has the GPC and Runtime Magic Quotes turned on or off. The output should have appropriate labels that define what output signified and should display 'ON' or 'OFF' depending on the setting.

  Creating functions through conditional operator

Use the conditional operator and the cal_days_in_month function, determine the number of days in the current month and output to browser whether it is normal month or a leap month.

  Web development projects with database

Since the vast majority of web-development projects involve a database, do you think that computational activities should be performed there, or do you think they belong in the XML page or stylesheet?

  Comparing shelf software packages

Required assistance with comparing and contrasting two main off the shelf software packages that could be implemented in an organization.

  Web based scams

Web phishing, pharming and vishing are popular web based scams. Talk about currently used tools and recommended measures to defeat this kind of attacks efficiently?

  Explanation of contextual links

The most powerful hypertext capabilities is the the contextual link. Wikipedia . com is a great example of a site that utilizes contextual links.

  How architectural and protocol changes occur

Discuss how architectural and protocol changes happen, the administrative organization that oversees the technical development of the Internet,

  Traditional approaches for training professionals

Webinars and other web conferencing techniques have proved most beneficial for the provision of affordable quality corporate training.

  Internet for business

Discuss how can a business use the Internet and give at least three examples with web links demonstrating your answer.

  It influences the behavior of organizations

Information technology influences the behavior of organizations. Name one effect of Information technology implementation and long-term usage you suppose having a positive contribution and one having a negative consequence.

  Importance of a guided navigation system

Explain the use and importance of a guided navigation system and shopping cart for a website designed for e-commerce and business purpose.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd