Programming Requirements: You have been hired to create a professional looking web application for employees of Jazz National Bank.

The application requirements include:

1) Bank Account Database

a. AccountType Table (this table must have at least 3 rows of data in it)

TypeID (primary key, can be autonumber)

Type (Checking, Savings, Money Market, Investment, etc)

InterestRate

b. Bank Account Table (this table must have at least 5 rows of data in it)

AccountID (primary key, can be autonumber) TypeID (foreign key referential integrity should be enforced)

FirstName LastName Balance

c. User Access Minimum of 2 accounts (1 admin with full access, 1 read only)

2) Web Application (using cookies and sessions) create your own interface design

a. Log-In Page

b. Index.PHP - Do not display Index.PHP unless the user is logged in. Check for a session object to see if the user has been authenticated (based on database user accounts). This page should display a table of BankAccounts

c. Application Requirements

i. Add Account

ii. Update Account Information

iii. Delete Account iv. Process a Transaction (updating balances)

1. Withdraw (must be less than the account balance accounts cannot have a negative balance)

2. Deposit v. Data should be validated to ensure appropriate data has been entered by the user

d. Display a Transaction Log for this Session

e. End of Session:

i. Update Database with correct balances as needed

ii. Clear the Transaction log

iii. Log Out iv. End the Session

v. Delete Session

vi. Clear Transaction Log Additional Requirements:

Persistent Cookies should be maintained for 2 days

Application should verify that cookies are allowed, and should provide an appropriate messaging if cookies are not allowed (program should not crash)

The multiple web pages should be nicely designed, standardized using CSS, and be developed for ease of use.

Data input requirements should include the selection of the best input controls and (limited) error checking.

Good complete commenting throughout is expected

Use meaningful names to identify all of your files, variables, controls and form elements

Identify your work as your own:

o Add your name in a label to the index.php form

o Place Programmed by: your name as a comment at the top of each .html or .php file in your project

Use MVC coding.