Portfolio 4 Task

Details: Category: Level 1, Porfolio 4 Web Design, Server Side Programming, Problem Solving and Software Engineering (Database Design) (HTML,CSS,Javascript,PHP and SQLite); Published: Wednesday, 13 January 2021 10:22; Hits: 709

Portfolio Four: Web Design, Server Side Programming, Problem Solving and
Software Engineering (Database Design)

This portfolio is individual work.

In this portfolio, we are assessing the skills you have developed so far in the following areas:

Understanding of standards, formats and tools used in the design of information, multimedia and
web-based systems
Recognition of the need for adaptable approaches to problem solving.
Ability to specify and contextualize a problem and communicate effectively an appropriate
solution to a range of audiences
Use of software engineering techniques to design, code, test and evaluate a range of software
solutions

1. Problem Context
As you are aware from Professional Practice Weeks one and two, the City of Funderland is holding local
elections this year, so existing political parties and newly formed parties have begun mobilising to try to
capture the hearts and minds of the city’s young voters in a 3 month election campaign.

You have already made a website for your political party and a C# forms application to allow the city
council and each political party to capture data on how their party activists are working to publicise their
manifestos and to convert interested young people into party members and activists in their own right.

The City of Funderland is intending on running a series of election workshops throughout the city, in the
run up to the election and would like to implement a prototype web system to advertise the events taking
place across the year.

Your primary task this week is to create a web based system that has both:

1. a public-facing interface and
2. an administrator area.

To try to encourage more young people to attend political events, the City of Funderland council wants
the site to be quick and easy to use and therefore they do not require the users to register to use this
initial prototype system. The admin area will allow the City of Funderland political campaign managers to
manage the events listed on the website: for example adding, amending and deleting political events. This
site should not be linked to the public facing site.

Secondly, however, you should be aware that City of Funderland are considering building a more
advanced web based system that goes beyond publicising the events and allows users to register and
make bookings to attend an event. As this is just a consideration at the minute, City of Funderland require
only an initial database design of this more advanced system so that they can consider the feasibility of
developing such a system. They will provide you with more thoughts around this more advanced system
later in the week.

How to approach the week

2. Reflection on Feedback and Feedforward Plan

Reflect on your performance in Professional Practice Week 3 using your own thoughts and then consider
your tutor feedback and your response to the tutor feedback. You are advised to use the template as a
guide so that you make sure you have considered every point we are looking for you to address (subjectspecific
skills, transferable skills, time and effort spent, additional resources used, reflection on
performance, feedforward response to tutor feedback). You should do this first of all before you turn your
attention to this week’s tasks. (If you have not received your feedback you should speak with the module
leader.) This part of the week’s activities is worth 15%.

3. Web System Build (to be attempted from Monday with a deadline of Friday midday)

You are required to develop a prototype system to meet the needs specified by City of Funderland.

Part A - A professional public facing website for the City of Funderland Politcal Events developed using
HTML, CSS, Javascript, PHP and a SQLite database. You may use an open source HTML/CSS template, but
it must be referenced.

The functionality of the website should allow a user to:

Display a list of upcoming political events (without searching)
Display further information on any given event, when a user clicks on the title of the event.
Work out their eligibility to vote in UK (web form with JavaScript – no database).

Further advanced features should be:

Search for a political event using a range of criteria (e.g. date, postcode and parties present)
Display a list of events for a given month (clickable links, without searching).

All event data should be stored in your own local SQLite database – created with DB Browser.
The application will be tested using a local development server.

Part B – Admin Area: In addition to the public facing website, you are required to create an admin site.
This is not secured by a password – it is simply a different set of web pages. The functionality should be:

• Add a political event
• Amend an event (e.g. change name, description, date etc)
• Remove an event.

4. Database Design Documentation (issued later in week with a deadline of Friday 8pm)

You are also required to design the database of the more advanced system City of Funderland council are
considering developing in the future. This will be issued later in the week once the council have had a
chance to see initial development, poll the citizens regarding registering personal information, and think
about what further needs they might have.

5. What to Hand-in

Monday 12th February by 8pm

1. Upload your feedback reflection/feedforward plan to your PPW4 pages of your ePortfolio

– you are advised to have this done in the morning however so you can make an early

start with the web system development.

2. Upload Monday’s daily log

Tuesday 13th by 8pm upload Tuesday’s daily log
Wednesday 14th by 8pm upload Wednesday’s daily log
Thursday 15th by 8pm upload Thursday’s daily log
Friday 16th February by 12pm –

1. Upload to the CANVAS PPW4 Assignment link a zip file of your web project containing the

PHP files and sqlite.db file.

2. Upload to your PPW4 pages in your eportfolio a zip file of your web project containing the

PHP files and sqlite.db file

Friday 16th February by 8pm – upload the more advanced system database design to your PPW4

pages of your eportfolio.

6. Marking

You will be allocated a time during next week’s Web tutorials (Monday and Tuesday) during which you
will demo your system to a tutor. You must also bring to the demo a print out of your database design
documentation. The demo will use the PHP built-in web server. Please do not host your site on an
external server or use another database technology. We will only review work developed using PHP7 and
a SQLite database which can be reviewed in DB Browser.

Indicative marks

15% Feedback reflection/Feedforward plan, plus 4 daily logs (Monday-Thursday)
40% Core functionality – technical/creative web database development skills;
30% Advanced functionality
15% Database design documentation – evidence of structured approach to system design

Please note – we encourage you to use a free web template for the UI design, as most of the marks are
allocated for core functionality achieved by using client and server side scripting.

PART 2 Database Design Documentation (deadline of Friday 8pm)

The City of Funderland Council have been giving thought to a more complex system and they would like to
see you produce some designs for this. They have provided you with the following scenario:

In order to maximise the number of different citizens who are able to attend events the city council wishes
to limit people to be able to able to book onto only one event per day, however attendees can book onto
more than one event over time. People must have booked onto an event in advance if they are to be
allowed to attend it: an event will not run if no one has booked onto it.
Each political party may host as many events as they wish to during the campaign and some parties may
use more than one venue to host the events. While a given event takes place only at one designated
venue, each venue hosts many different events.

Your task this week is to draw the ERM for this scenario, using the notation you have been shown and
practiced using in class. Other notation will not gain more than 3 marks. The marking scheme is as
follows:

We do not require you to submit a normalisation table with attributes normalized to 3NF. However if you
want to do this to help ensure there isn’t redundancy in your database you can – but there are no marks
for producing a normalisation table.