Question Number: 357

CRICOS Provider No. 00103D ITECH3224 6224 Assignment 2 1420 Page 1 of 4ITECH3224/6224World Wide Web Technology 2Faculty of ScienceAssignment 2 – Dynamic review siteIntroductionThis is an individual assignment in which you will explore the use of data interchange between web serversand browsers, dynamic construction of page content, and API design, using PHP, JavaScript, XML, andJSON.Details of the weight of the assignment and due date are given in the course description.Please note: you may adapt the application to the review of anything you wish – within tasteful boundaries –but you should keep the basic schema the same.For example, you could do reviews of guitars, microbreweries, running tracks, nightclubs, coffees, tv shows,shoes, games, chicken parmigiana or similar. Adjust table names and foreign keys appropriately.Task DescriptionIntroductionRaccoon Reviews is a website that allows raccoon enthusiasts to connect over their shared interest.Each raccoon has a dedicated page that shows a photo and a name, a list of reviews, and some form ofaverage rating.Users can submit new reviews of a raccoon, including their name, some review text, and a rating.DatabaseA simple database with two tables contains data about raccoons, and their reviews.The database has the following structure:Raccoon(id, name, image_url)Review(id, raccoon_id, reviewer_name, review, rating)Each record in the Raccoon table refers to a single raccoon, and each record in the Review table is a reviewof a single raccoon. Each Raccoon may have many reviews.CRICOS Provider No. 00103D ITECH3224 6224 Assignment 2 1420 Page 2 of 4The assignment tasks are closely associated with the lab work of topics 7 to 10. Code and examples fromlectures and labs should be a useful guide throughout this assignment. The assignment requires a number offiles and a report to be produced. The report should respond to written tasks that are included below.Initial TaskCreate the database using your MySQL skills. You will need at least 4 raccoons, with at least 2 reviewseach.You may normalize the database if you wish, to include a dedicated "reviewer" table.Invent your own data – name raccoons after your family, favourite bands, explorers, movie characters, ormythological figures, for example.Use appropriate data types – in particular Review.review should be a TEXT field to allow long entries.Review.rating is an integer value from 1 to 5 inclusive, where 5 indicates that this is an amazing raccoon.Submit your SQL file as part of your assignment.XML and JSON markupMark up the complete data using XML tags and save it as an .xml file. Check that the file is well-formed andreport the method used. Draw a diagram showing the structure of the DOM tree associated with the .xml file,using data from any ONE record. Include the root element, node types, elements and attributes.Similarly, mark up the complete data using JSON and save it as a .json file. Check that it is valid JSON andreport the method used to validate.Submit both files as part of your assignment.Back-end APICreate a RESTful XML or JSON API (your choice), implementing, at minimum, the following functionality.Use the HTTP method specified in parentheses:• List all raccoons (GET)o Should return raccoon id, name and image_url for all raccoons, without reviewso Use an optional querystring/GET parameter to allow sorting by name & average rating• Retrieve all details for a single raccoon (GET)o including reviews• Create a new review/rating (POST)• Delete a review/rating (DELETE)• Update an existing review/rating (PUT)Follow HATEOAS (Hypermedia as the Engine of Application State) practices. Include a note in your reportabout how you have followed HATEOAS.Under Apache, this step will require configuring a .htaccess file to allow using clean URLs under the apifolder (without a .php extension)Front-endCreate an HTML/CSS/JS page which uses JavaScript, the DOM and your back-end API to:• Display a menu of all raccoons. Allow sorting the menu by name and rating• Display an individual raccoon's details when the menu item is selected, including the image and theaverage ratingCRICOS Provider No. 00103D ITECH3224 6224 Assignment 2 1420 Page 3 of 4• Allow the user to submit a new review/ranking, which will be displayed immediately in the review list,and upon which the raccoon's average will be updated from the server• Periodically (every 30 seconds), poll the details for the current raccoon and display any new reviewsNote: This task may require finding images to use. Consider using Wikimedia Commons to find images withpermissive licenses.All functionality should be implemented using JavaScript, the DOM and the API, without reloading/refreshingthe browser page.Bonus task (Optional!)Derive your averaging and sorting code based on the approach listed here:http://www.evanmiller.org/ranking-items-with-star-ratings.htmlAdditional task for ITECH6224 studentsOn the topic of “Session hijacking and session fixation” identify four (4) relevant, independent resources. Usethese resources to write an essay discussing the topic in your own words.Take care to cite appropriately. Word count should be 450-550 words (excluding references)Report contents1. The theme of the review site (eg. Raccoon Review)2. Statement of completion3. DOM diagram4. Essay task (ITECH6224 only)5. Give details of any assistance received (apart from teaching staff).Further detailsRefer to the Course Description for details of submission to Moodle, late assignments, extensions, specialconsideration, plagiarism, student support, presentation of academic work and adopted reference style.SubmissionAll files should be zipped and uploaded to Moodle by the due date and time.CRICOS Provider No. 00103D ITECH3224 6224 Assignment 2 1420 Page 4 of 4ITECH3224/6224 World Wide Web Technology 2Faculty of ScienceAssignment 2 Marking GuideName ID MarkerCriterion Maximum Obtained.sql file – requirements satisfied 1.xml file- Accurate- Well-formed211.json file- Accurate- Syntactically valid211Back-end API- Clean RESTful (resource-based) design, uses HATEOAS approach- List & Details (1), New review/rating (1), Delete (1), Update (1)- Sort based on query parameter6141Front-end (Must use API to construct)- Menu- Details, including image- Submit a new review/ranking, including list and average update- Automatic update41111Written task (ITECH6224 only)- Content- Adherence to academic standards532Report contents- Theme and statements of completion/acknowledgements. Document standards.- DOM diagram211Bonus!- Sort using Bayesian confidence22Quality of code:- Modularity - file and code structure. Not monolithic.- Indentation/layout, naming scheme- Use of comments, including quality and accuracy. Comments do not simply narrate codebut illuminate intent and design decisions.3111Totals- ITECH3224- ITECH6224Final Mark (scaled, correct to 1 decimal place. Maximum of 20 marks)202520Comments: