300693 WT - ASSIGNMENT 1:
BASIC WEBSITE CONSTRUCTION
Due Fri Sep 04 2020 at Midnight
Released on 24/7/2020
PREAMBLE
1. Over the semester, you will be working in a group of two, even though this 1st assignment is an
individual one.
2. This assignment 1 is worth 20% of the total marks for this Unit. Your are required to build your own
website with raw HTML5, CSS, Javascript and SQL. You are not allowed to use any packages such as
Dreamweaver, Visual Studio or any other website building software. The site must be created
according to the required standards or specifications (see below for more explanation).
3. This part (concerning the use of VM or School Server) is subject to changes due to the uncertainty,
largely caused by Corvid19, at the time of releasing this page.
Scenario 1: You will have full access to a virtual Microsoft Windows 2008 server and will be
expected to maintain it. You will be given an administrator account and initial password. Follow
the instructions given by Bruce Kneale (subject to changes) to use your Virtual Machine (VM).
Your website needs to be set up on the VM allocated to you, accessible on your VM via
the url http://localhost/assignment1 (this hyperlink should work properly when you view this
assignment 1 page on your VM).
Scenario 2: You have access to student.cdms.westernsydney.edu.au and your
assignment will be set up there.
Note: Features not implemented on the live site will not be given marks.
4. Make sure that you DO NOT CHANGE other ADMINISTRATOR accounts created by Bruce as this
would otherwise mean that marker/s will not be able to access your server for the marking. This may
attract a penalty of 20% in marks.
5. Quality of the work, including such as the proficient and effective use of the technologies and
techniques, code validation according HTML 5 and CSS 3, ease of navigation, consistent and
aesthetically pleasing look and feel across the site, will also be a major factor of consideration for the
top grades.
6. You must both submit your whole website (zipped together using zip) electronically, and have the
whole website set up properly on your allocated Virtual Machine, all by the due date.
REQUIREMENTS
(20 marks)
1. Basic Webpages and Content. (6 marks)
On the designated virtual machine, create a website of your own for the Apache server (at port
80), consisting of at least a home page and 3 or so others, to demonstrate page linking.
This site should be about a specific medical condition of your choice, its symptoms and
potential long-term impact on the well-being and life style, as well as its treatment and
precaution. It could contain anything that is related to this medical condition. 24/7/2020
24/7/2020
One of these pages, or just a section of one of these pages, should be about yourself, the creator
of this site, your former study and/or work experience and perhaps your career goal.
Include some transparent and non-transparent graphics, different text sizes and colours, at least
one table illustrative of all the major table features, and various layouts using HTML5.
Please DO NOT use any Content Management System or any web authoring tools (other than a
plain text editor like notepad++) at this stage although you are free to make use of any image
editors.
2. Cascading Style Sheets. (4 marks)
Use suitable CSS style sheets to organise the layout, as well as the look and feel of your whole
whole website consistently.
Replicate your complete (primary) website, and replace the styling for the whole replicated site
using purely CSS style sheets for ALL the formatting so that they will all have a different but
consistent look and feel on the replicated site. In other words, your replicated website should be
the same as the original in its content and functinalities, except for the different external CSS
style sheets. This replicated site should look and feel as much different as possible. You
may check out this CSS Zen Garden to see how the same content can be presented hugely
differently with the change of the external CSS style files.
3. Forms, Queries, and Data Collection. (8 marks)
There are 3 aspects in this section. The first is to have a proper form set up for the interface on a
webpage, the second is to have proper Javascript for the interactivity (e.g. clicking a button, or
making an item selection or directly submitting a form, will fire up a database query), and the
third is to make use of a PHP script to query the database to return the results.
There should be a hyperlink or a button, somewhere on the form, that would list all the records
for at least one of the tables in the database (that table should be the table that you can enter data
dynamically via the form).
Create a form so that a user can select a health problem to list all the relevant symptoms
described either in healthproblems.sql or in a similar database of your own if you wish to add
more features or fields to the database. This simple database of just 3 tables is created on the
basis of the information at www.medicinenet.com, and is to keep track of a few popular
disorders such as heart attack, stroke and lung problems, stored in table Disorder, and their
corresponding symptoms stored in the table Symptom. The third table Feature simply stores
which disorder may have what symptoms.
There should be at least a way to collect additional data on health problems and/or symptoms on
the website, and have the data added to the database in MySQL so that these new data will be
automatically available to the future queries.
4. Exploratory Challenges. (2 marks)
Add one of the following aspects or features to your website that is not explicitly stated as the
requirements in the above. These aspects or features are
A fancy or state-of-art navigation scheme for your site, making more sophisticated use of
CSS;
An additional Javascript application, making use of DOM, to improve the interactivity or
data processing;
A facility to modify an existing table record in the database.
Student must explicitly state which part of their submitted work belongs to this subsection.
Otherwise their Exploratory Challenges will be considered absent.
5. Overall Quality and Professionalism. (20% of the total marks)
About 20% of the total marks will be awarded for the top quality of the submitted work as well
as to the professionalism demonstrated there. These are typically expected to go beyond the
minimal features already explicitly stated in the above subsections of REQUIREMENTS.
The overall quality can include, among others, the look and feel, the ease on the use of the site,
as well as the professional/proficient design and implementation throughout the student work.
Students are highly recommended to volunteer to demonstrate their most impressive
features to their instructor during the class of the submission week. This demonstration is
however expected to be just between the student and the instructor.
SUBMISSION
Go to the physical subdirectory of root of your website, say, c:\xampp\htdocs\assignment1, zip
everything within this directory and its subdirectories into a single file wt12345678.zip where
"12345678" is to be replaced by your student number.
This zip file should also include an SQL file wt12345678.sql which can be used to set up your
database. The database should have the name wt12345678 where, again, "12345678" is to be
replaced by your student number. The SQL file will typically take the form
-- delete the database if it's already there
-- "12345678" here and below should be replaced by your student number
DROP DATABASE IF EXISTS wt12345678;

-- create the database
CREATE DATABASE wt12345678;

-- select the database to use
USE wt12345678;

-- create a table within the database
-- "TableName" can be any legitimate table name
CREATE TABLE TableName
(

-- some sample fields here
-- yours will typically be completely different
Name varchar(20) PRIMARY KEY,
Age INT

);

-- more tables to be created here if required

-- fill the table/s with the data
INSERT INTO TableName VALUES ( 'david', 20 );
INSERT INTO TableName VALUES ( 'sally', 19 );

-- other records to be added here
If you already manually created the database wt12345678, you can export the database into an SQL
script, and you can also dump the database into an SQL file wt12345678.sql via e.g.
c:
cd c:\xampp\mysql\bin
mysqldump -p -u root wt12345678 > wt12345678.sql
at a commond prompt.
Zip (don't use the rar compression format) all the relevant files into a single zip file, and then upload it
via the submit button on the unit website. 1 mark may be deducted if the submission is done via the
rar compression. It's each student's responsibility to keep the submission receipt which will be
automatically generated after each successful submission.
You must also have your whole website set up on your allocated virtual machine. If you don't have
this set up properly, all your work related to web server, PHP and database will receive no marks.
If your site is not set up live on an allocated VM, and is set up on a School's server instead, you would
need to submit the corresponding files/data in a similar manner. Consult the unit coordinator if you
need further clarification near the submission time.