WT — Assignment 1
300693 WT – ASSIGNMENT 1: BASIC WEBSITE CONSTRUCTION
Due Fri Sep 06 2019 at Midnight
Released on 29/7/2019, to be finalised on xx
1. Over the semester, you will be working in a group of two, even though this 1st assignment is an individual one.
3. 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). Features not implemented on the prescribed VM 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 the various books on modern computing or IT technologies, featuring their respective prominent technological aspects and their corresponding applicability in the IT industry.
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
WT — Assignment 1
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 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 book to list all the relevant reviewers and their respective ratings described either in bookreview.sql or in a similar database of your own if you wish to add more features or fields to the database. This simple database is to keep track of which reviewers have been assigned to review which book for the publisher, along with their review reports, and which book has been written by which authors. For simplicity, a book will be recorded for its title and author/s, an author or reviewer will be recorded for his or her name, and a review report should contain an integer rating value between 1 and 5 (inclusive) and the date on which the review report is completed.
There should be at least a way to collect additional data on books and/or reviewers and their respective ratings 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;
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.
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
28/08/2019 WT — Assignment 1
— 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,
— 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.
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.
本网站支持淘宝 支付宝 微信支付 paypal等等交易。如果不放心可以用淘宝交易！
E-mail: [email protected] 微信:dmxyzl003