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.
