CO5047 Written Assignment

A design brief with reflective report

 

This document contains: a user specification, test plan, data dictionary and evaluation report.

 

Andrew Jones

6/7/2010

 


 

Contents

User Requirements Specification. 3

User Requirements. 3

Statement of the Project 3

Deadlines and Timescales. 3

Constraints and Solutions. 3

Constraints. 3

Solutions. 3

Storyboards. 4

Navigation Map. 6

Database Interactions. 6

Test Plan. 7

Data Dictionary. 8

Report 12

Completed Test Plan. 13

W3C Validation. 13

index.html 13

history.html 14

contactUS.html 14

upComingWalks.asp. 14

links.html 15

news.asp. 15

Styles.css. 15

Further Development 15

 


 

User Requirements Specification

User Requirements

The Rainbow Ramblers walking group have asked for a web site to promote their group and walking activities. The site has to incorporate a history of the walking group page as well as functionality for updating and editing the upcoming walks programme, adding news articles and links to other walking groups and associations.

The site must be CSS based; W3C validated and have database functionality. The primary goal is a clean, simply navigated site that is not graphics intensive that meets these requirements.

Statement of the Project

To design, build and implement a web site for the Rainbow Ramblers walking group that features: history about the groups development, a programme of upcoming walks, news and a photograph gallery.

Deadlines and Timescales

The project will go live before the 7th June 2010.

The web site url for the public site is http://www.rainbowramblers.org.uk/

The url for the management functions is http://www.rainbowramblers.org.uk/login.asp with the user name ah and a password of dos.

Constraints and Solutions

This section of the report will deal with the constraints, both users created and hosting together with the proposed solutions to overcome these.

Constraints

The Windows hosting package for the site has a number of constraints that will impact upon the design of the site, namely:

  A maximum site size of 200Mb

  A monthly bandwidth transfer limit of 2Gb

  A single Microsoft Access database

Solutions

The solutions available are straight forwards:

  The sites graphics content will be kept to a minimum, thus be primarily text based. Utilising CSS for the navigation and colour content.

  Image sizes will be kept to a minimum, but large enough to ensure that they are clear and crisp.

  Download times will be kept to a minimum, together with the demand on bandwidth

  A single Microsoft Access database will be implemented that contains a number of tables.

  Browser issues will be resolved through rigorous testing, although making the site W3C compliant will reduce these potential issues to a minimum.


 

Storyboards

Navigation Map

Database Interactions

The data base will have a number of interactions, these come in two forms:

  Queries from the database to form pages for public viewing

  The backend information management pages

Looking firstly at the pages for public viewing these are the news page and the upcoming walks programme, were the database is queried and all of the results are parsed into tables for display as the web page.

Secondly looking at the backend there are a number of pages that need to be implemented for: inserting a record, editing a record and deleting a record, this is the same for both page sets.


 

Test Plan

TestID

Test

Home

History

Up Coming Walks

News

Links

Contact Us

Photo Gallery

001

Page Loads

 

 

 

 

 

 

 

002

Background image repeats vertically

 

 

 

 

 

 

 

003

Page Title is unique for each page

 

 

 

 

 

 

 

004

Page header is displayed correctly

 

 

 

 

 

 

 

005

Navigation is displayed correctly

 

 

 

 

 

 

 

006

Navigation links change colour appropriately

 

 

 

 

 

 

 

007

Text headings are displayed correctly

 

 

 

 

 

 

 

008

Text displays correctly

 

 

 

 

 

 

 

009

Text links are shown in the correct style

 

 

 

 

 

 

 

010

Hyperlinks work

 

 

 

 

 

 

 

 


Data Dictionary

The following section outlines and details the data dictionary for use in the Rainbow Ramblers web site

Table 1 Overview of Login Table

Database Name

RainbowRamblers.mdb

Table Name

Login

Description

A table for storing the user names and passwords of users of the Rainbow Ramblers Web Site

Properties

The database will be available across the internet

End user rights

The end user will have the ability to add, delete and modify records

 

Table 2 Details of the Dictionary for Login Table

Column Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Relationships

Indices

loginID

A text field for storing the unique ID of the record

Text

10

Not Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

Primary Key

Password

A text field for storing the users password

Text

50

Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

 

Username

A text field for storing the users username

Text

50

Not Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

 

 


 

 

Table 3 Overview of the Upcoming Walks Table

Database Name

RainbowRamblers.mdb

Table Name

Walks

Description

A table for storing the programme of upcoming walks for the Rainbow Ramblers walking group

Properties

The database will be available across the internet

End user rights

The end user will have the ability to add, delete and modify records

 

Table 4 Details of the Dictionary for upcoming Walks Table

Column Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Relationships

Indices

WalkID

A text field for storing the unique ID of the record

Text

10

Not Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

Primary Key

WalkDate

A Date/Time field for storing the date of the walk

Date/Time

Long Date

Null

 

A date/time field has been chosen because it will allow for the date to be stored in a specific format

This field has no relationships

 

WalkIncludeOnPage

A text field for whether or not the walk should be included on the page of upcoming walks

Text

1

Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

 

WalkLeader

A text field for storing details of the walks leader

Text

255

Null

 

 

This field has no relationships

 

WalkMeetingPoint

A memo field for storing the details of the walks meeting point and starting instructions

Memo

 

Null

 

A memo field has been chosen because it will allow for any character to be entered and for much more data to be entered

This field has no relationships

 

WalkVenue

A text field for storing the venue of the walk

Text

255

Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

 

 

Table 5 Overview of the News Table

Database Name

RainbowRamblers.mdb

Table Name

news

Description

A table for storing the news articles associated with the Rainbow Ramblers Web Site

Properties

The database will be available across the internet

End user rights

The end user will have the ability to add, delete and modify records

 

Table 6 Details of the Dictionary for News Table

Column Names

Description

Data Type

Data Size

Null/not null

Default values

Comments

Relationships

Indices

NewsID

A text field for storing the unique ID of the record

Text

10

Not Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

Primary Key

ArticleDate

A date/time field for storing the new article date

Date/Time

Long Date

Null

 

A date/time field has been chosen because it will allow for the date to be stored in a specific format

This field has no relationships

 

NewsArticle

A memo field for storing the news articles

Memo

 

Null

 

A memo field has been chosen because it will allow for any character to be entered and for much more data to be entered

This field has no relationships

 

NewsTitle

A text field for storing the news article title

Text

255

Null

 

A text field has been chosen because it will allow for any character to be entered

This field has no relationships

 

 


Report

I expected this assignment to be straight forward, and it wasnt. I encountered serious problems with the update and insert forms for the database; another problem arose in the creation of the javascript file with Internet Explorer intermittently show an error on the page with an invalid character this took much longer than planned to debug and remains an unexplained issue with IE.

I feel that I have done a good job in developing the site for the Rainbow Ramblers, and am surprised by how well the design side worked, as this I feel is my weakest area when it comes to the production of a web site.

I dont think that I would do anything differently if I were to approach the assignment again.

Having completed the assignment my view of Dreamweaver has changed substantially from what a great tool to one of well it tries.

I feel that I have achieved my assignment goals together with those set out by the client. The client has responded very favourably about the site and the development fulfils all of the assignment criteria.

I thoroughly enjoyed creating the site and enjoyed immensely learning ASP and CSS. I also learnt that a solid brief with adequate planning is worth its weight in gold.

I feel that I coped well with the assignment; the web site was an enjoyable task, as ever I struggled with the written side, although Im getting better at it. I had allocated enough time to complete all of the tasks without unduly pressurising myself.

To improve the project I think that the addition of picture content into the site would enhance the viewability of the pages as they may appear to be very wordy, although this is in line with the target and expected market for the site.

My preparation with more than adequate and was clearly planned from the onset. The amount of information we were provided was more than adequate.

If I were to re-do the web site I would like to work collaboratively with a designer as I feel that the site could have a more effective design feel, although it stands up well against the brief of a clean simple site.

I have learnt a lot about developing ASP web pages and connecting to a database.

Design consistency was a personal priority in the development of the site, this has through the use of CSS been implemented in a flexible way, with global changes to the look and feel being simple to implement.


 

Completed Test Plan

The following test plan has been completed in Microsoft Internet Explorer, Mozilla Firefox and Google Chrome.

TestID

Test

Home

History

Up Coming Walks

News

Links

Contact Us

Photo Gallery

001

Page Loads

002

Background image repeats vertically

003

Page Title is unique for each page

004

Page header is displayed correctly

005

Navigation is displayed correctly

006

Navigation links change colour appropriately

007

Text headings are displayed correctly

008

Text displays correctly

009

Text links are shown in the correct style

010

Hyperlinks work

 

W3C Validation

The website has been validated and is compliant to W3C standards for both html and CSS, as such is allowed to use the W3C compliance logos on the site. For design reasons it has been decided that the graphics will only be used on the first page.

index.html

history.html

contactUS.html

upComingWalks.asp

links.html

news.asp

Styles.css

Further Development

The next stages of development for the site are to generate key words and submit it to search engines so that potential ramblers can find the site. The photo gallery will be populated by the members of the rainbow ramblers; it currently shows a blank gallery.

Further developments may include linking Google maps to show the planned routes of walks, but this requires GPS data for longitude and latitude which the group does not currently have.