Web Application Design Assignment

Aim:

To create a design, build and test a small web application using both client and server side technologies and a web server scripting language.

Learning outcomes covered:

1. Use a server side scripting language to create web applications incorporating data base connectivity; dynamic page generation, authentication and demonstrating data security.

6. Perform testing and maintenance on Web Applications.

You are to come to your tutor with an idea for a database driven website that can be implemented as a Web Application. The website must be appropriate for a small business, professional body or charity/public service body and must be of suitable complexity to meet the learning outcomes of this paper.

The site must have as a minimum the following features and functions:

Home page, About, Services, Testimonials, Contact form, Feedback, Enrolment/Signup page, Policy Documents, News/Advise (FAQ) or Blog style page.

The site must make use of at least 3 web services such as live maps, social media feeds and weather / news tickers

The website must be able to support a feedback form and appointment/service request form or similar

If you do not have a site idea of your own you may with the permission of your tutor use the scenario listed below:

Scenario Background

- Geyserland Small Business Accounting Services is a small accounting practice based in central Rotorua.

- They offer basic accounting services to their clients ranging from basic bookkeeping through to payroll and taxation services including GST returns
- They take few appointment bookings via email from clients but would like to expand this by branching out into the web by offering an appointment request service that works via email
- They want a website with the following features and functions:
- Home page
- About Us
- Accounting Services
- Advise (FAQ) page
- Contact form
- Consultation/Appointment request page
- Policy Documents
- External/Useful links page
- Visual location map
- Weather ticker
- Social media feed
- They have their company logo, which is on their company stationary and company office but are open to other design ideas for the site. (A copy of which will be available on Moodle for download and use in Part B of this assignment)

Part A

Create a design document that contains both logical, physical and database design specifications. You will need to research the site style for your site owner's type of business to ensure your design is appropriate for the genre.

Your design documents must include a site outline / scoping document describing the site features and functions that will be produced. It must also contain a graphical representation (mock-up/storyboard and wireframes) of the user interface, including fonts (style, weight, size, etc.) colour codes, measurements and a banner and logo. It must also contain a site navigation map. These designs can initially be produced on paper (highly advisable) but transferred to a digital format for submission in the assignment

You are to select an appropriate software development methodology and explain with justification why you believe it is appropriate for managing the development of your website.

Part B

Based on your design document from part A, create a 2-3 page html template - home page and 1-2 typical content pages. The templates should be saved with a .php file extension. The presentation layer must be created using CSS3 and the content layer must be html5 compliant and preferably use semantic mark-up. You must use the company logo unaltered in your layout but may source all other graphic elements yourself. Your graphics must be appropriate for the site you are producing. Any graphics you do not create yourself must be sited and referenced using APA6 format in Part A of this assignment.

Your CSS layout must make use of the bootstrap framework to style some part of the page. Your pages should also be mobile responsive.

You are to design a data model and build a database that would service the above website. You can do this using phpMyAdmin on your web hosting service. Populate the database with at least 6 test records. Create a series of test statement in SQL that would retrieve data appropriate for two of the website pages identified in your Part A design.

All files in parts A and B must be contained in an appropriate folder structure

Attachment:- BooksAliveWebsiteOutline.rar