Assignment Dynamic Review Site

Assignment Dynamic Review Site

10-11-17 Maddox Smith 0 comment

---

Assignment Dynamic Review Site

ITECH3224/6224

World Wide Web Technology 2

Faculty of Science

Assignment 2 – Dynamic review site

Introduction

This is an individual assignment in which you will explore the use of data interchange between web servers and browsers, dynamic construction of page content, and API design, using PHP, JavaScript, XML, and JSON.

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 Description

Introduction

Raccoon 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 of average rating.

Users can submit new reviews of a raccoon, including their name, some review text, and a rating.

Database

A 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 review of a single raccoon. Each Raccoon may have many reviews.

CRICOS Provider No. 00103D           ITECH3224 6224 Assignment 2 1420

The assignment tasks are closely associated with the lab work of topics 7 to 10. Code and examples from lectures and labs should be a useful guide throughout this assignment. The assignment requires a number of files 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 reviews each.

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, or mythological 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 markup

Mark up the complete data using XML tags and save it as an .xml file. Check that the file is well- formed and report 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 and report the method used to validate.

Submit both files as part of your assignment.

Back-end API

Create 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)
• Should return raccoon id, name and image_url for all raccoons, without reviews
• Use an optional querystring/GET parameter to allow sorting by name & average rating
• Retrieve all details for a single raccoon (GET)
• 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 report about how you have followed HATEOAS.

Under Apache, this step will require configuring a .htaccess file to allow using clean URLs under the api folder (without a .php extension)

Front-end

Create 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 the average rating

CRICOS Provider No. 00103D           ITECH3224 6224 Assignment 2 1420

• 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 reviews

Note: This task may require finding images to use. Consider using Wikimedia Commons to find images with permissive licenses.

All functionality should be implemented using JavaScript, the DOM and the API, without reloading/refreshing the browser page.

Bonus task (Optional!)

Derive your averaging and sorting code based on the approach listed here:

//www.evanmiller.org/ranking-items-with-star-ratings.html

Additional task for ITECH6224 students

On the topic of “Session hijacking and session fixation” identify four (4) relevant, independent resources. Use these 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 contents

5. The theme of the review site (eg. Raccoon Review)
6. Statement of completion
7. DOM diagram
8. Essay task (ITECH6224 only)
9. Give details of any assistance received (apart from teaching staff).

Further details

Refer to the Course Description for details of submission to Moodle, late assignments, extensions, special consideration, plagiarism, student support, presentation of academic work and adopted reference style.

Submission

All files should be zipped and uploaded to Moodle by the due date and time.

CRICOS Provider No. 00103D           ITECH3224 6224 Assignment 2 1420

ITECH3224/6224 World Wide Web Technology 2

Faculty of Science

Assignment 2			Marking Guide
Name				ID		Marker
Criterion							Maximum		Obtained
.sql file – requirements satisfied							1
.xml file							2
–		Accurate					1
–		Well-formed					1
.json file							2
–		Accurate					1
–		Syntactically valid					1
Back-end API							6
–   Clean RESTful (resource-based) design, uses HATEOAS approach							1
–   List & Details (1), New review/rating (1), Delete (1), Update (1)							4
–   Sort based on query parameter							1
Front-end (Must use API to construct)							4
–		Menu					1
–		Details, including image					1
–   Submit a new review/ranking, including list and average update							1
–		Automatic update					1
Written task (ITECH6224 only)							5
–		Content					3
–   Adherence to academic standards							2
Report contents							2
–   Theme and statements of completion/acknowledgements. Document standards.							1
–		DOM diagram					1
Bonus!							2
–   Sort using Bayesian confidence							2
Quality of code:							3
–   Modularity – file and code structure. Not monolithic.							1
–		Indentation/layout, naming scheme					1
–		Use of comments, including quality and accuracy. Comments do not simply narrate code					1
		but illuminate intent and design decisions.
Totals
–		ITECH3224					20
–		ITECH6224					25
Final Mark (scaled, correct to 1 decimal place. Maximum of 20 marks)							20

Comments:

CRICOS Provider No. 00103D           ITECH3224 6224 Assignment 2 1420

Assignment Dynamic Review Site

STRATEGIC INFORMATION SYSTEMS

---

 STRATEGIC INFORMATION SYSTEMS 

In groups of three or four, you will be required to conduct research on AIS/ERP Systems for your client. Your team is required to pick a case study in one of the areas mentioned below (not limited to). Then prepare a Business Report for the client detailing the processes of selecting an AIS/ERP to help them to make informed decision for investment in information system to take their business to the next level including:

1. Define business processes,

2. Develop business requirements,

3. Determine the systems requirements,

4. Software and vendor selection

5. Determine at least three (3) ways which companies or organizations utilize such technologies to improve business efficiency

6. Evaluate the level of efficiency of the technology implementation

7. Examine potential security risks, data breaches

8. Provide guidelines on how these risks could be mitigated.

The report should be about 3000 words and should be submitted in an MSWord format document for the client. Each group would be required to find AIS/ERP that addresses the different aspects of the clients’ business especially the area of their enumerated challenges and should also ensure that the client’s business requirements are addressed. You may also employ any analysis or design tool in the preparation of your report – so long as the results are suitable for presentation in the required Word document and are your own work.

Remember: this is a report intended to convince a board of directors to adopt your proposal. Your report must therefore be complete, yet concise; be clear and convincing, and professionally presented. Above all, the report must be specific to the needs of the business.

HI5019 STRATEGIC INFORMATION SYSTEMS

Case Studies in the areas of: (The team needs to email the lecturer their choice)

•	Public Transport	•	Immigration
•	Flight Centres	•	Health
•	Real state agencies	•	Medicine
•	Education	•	Pollution
•	Library	•	Manufacturing
•	Banks	•	Agriculture

Submission Requirements:

Research reports are to be presented in size 12 Times New Roman or 10 Calibri Font and double spaced. The research should include a list of at least 5 references used in the research report and a bibliography of the wider reading done to familiarize oneself with the topic.

Submission:

• Soft copy to self-check and Final Submission with cover sheet

You are reminded to read the “Plagiarism” section of the course description. Your research should be a synthesis of ideas from a variety of sources expressed in your own words. All reports must use the Harvard referencing style. Marking rubrics are attached.

Assessment Criteria:

Type/Score	Very Good (10/10)	Good (7/10)	Satisfactory (5/10)	Unsatisfactory (3/10)
Fits with criteria	Appropriately choose an	Evidence of	Adequacy	Reports that choose
/10	AIS/ERP that fits. understanding	understanding of the	of understanding of	systems/software not
	of the nature and purpose of	nature and purpose of	the nature and	relevant will lose
	the business	the business	purpose of the	marks from this
			business	category.
Type/Score	Very Good (15/15)	Good (11/15)	Satisfactory (8/15)	Unsatisfactory (5/15)
Presentation and	Information is well organized.	Information is	Information is	Information is poorly
writing style	Correct layout including times	organized, Correct	somewhat	organized, Some
	new roman, font size 12 or	layout including times	organized, Some	elements of layout or
	calibri, font size10, double	new roman, font size	elements of layout	length incorrect.
/15 marks	spaced. About the right length.	12 or calibri, font	or length incorrect.
		size10, double		Proper grammar and
	Very well written, excellent	spaced. About the	Proper grammar	punctuation not
	paraphrasing and proper	right length.	and punctuation	always used.
	grammar and punctuation are		mostly used, but	Excessive overuse of
	used throughout.	Well written, some	overuse of direct	direct quotes
		paraphrasing and	quotes.
		proper grammar and
		punctuation

I5019 STRATEGIC INFORMATION SYSTEMS T2 2017

Type/Score	Very Good (15/15)	Good (11/15)	Satisfactory (8/15)	Unsatisfactory (5/15)
Introduction	Introduces the topic of the	Introduces the topic	Satisfactorily	Introduces the topic
	research report in an extremely	of the research report	introduces the topic	of the research
	engaging manner which arouses	in an engaging	of the research	report, but omits a
/15 marks	the reader’s interest.	manner which	report.	general background
		arouses the reader’s		of the topic and/or
	Gives a detailed general	interest.	Gives a general
	background and indicates the		background.	the overall “plan” of
	overall “plan”.	Gives some general		the report.
		background and	Indicates the overall
		indicates the overall	“plan” of the report.
		“plan” of the report.
Type/Score	Very Good (20/20)	Good (15/20)	Satisfactory (10/20)	Unsatisfactory (5/20)
Criteria	Evidence of understanding of	The chosen	Evidence of	You gain marks for
completion	the nature and purpose of the	software/system has	understanding of	ensuring that all of
/20	business.	the capacity to	the implications for	the points mentioned
	Evidence of understanding of	address challenges	the company	above as challenges
	the implications for the	identified within the		within the business
	company	business.		are covered in your
				report by the chosen
				software / system.
Type/Score	Very Good (10/10)	Good (7/10)	Satisfactory (5/10)	Unsatisfactory (3/10)
Evidence of	Substantial range of	Good range of	Suitable range of	Insufficient range or
Research	appropriate and current,	appropriate and	supportive evidence	number of supportive
	supportive evidence	current, supportive	used. Not always	evidence used.
/10 marks		evidence.	appropriate and/or
			current. Minimum
			cited.
Type/Score	Very Good (20/20)	Good (15/20)	Satisfactory (10/20)	Unsatisfactory (5/20)
Development of	Logical, insightful, original	Detailed, original	Adequate discussion	Inadequate discussion
Discussion	discussion with well-connected	discussion develops	develops logically.	of issues and/or
	paragraphs.	logically with some		lacking in logical flow
		connection between	Understanding of
	Evidence of full engagement	adjoining paragraphs.	reading shown. Few	Little/no
/20 marks	with the literature found, with		relevant analysis.	demonstrated
	relevant and detailed analysis.	Understanding of		understanding of
		reading shown. Some		reading.
		relevant analysis.
				None/little discussion
				or analysis.
Type/Score	Very Good (5/5)	Good (4/5)	Satisfactory (3/5)	Unsatisfactory (2/5)
Conclusion	An interesting, well written	A good summary of	Satisfactory	Poor/no summary of
	summary of the main points.	the main points.	summary of the	the main points.
	An excellent final comment on		main points.
/5 marks	the subject, based on the	A good final comment		A poor final comment
	information provided.	on the subject, based	A final comment on	on the subject and/or
		on the information	the subject, but	new material
		provided.	introduced new	introduced.
			material.

I5019 STRATEGIC INFORMATION SYSTEMS T2 2017

Type/Score	Very Good (5/5)	Good (4/5)	Satisfactory (3/5)	Unsatisfactory (2/5)
Referencing	Correct referencing (Harvard)	Mostly correct	Mostly correct	Not all material
	All quoted material in quotes	referencing (Harvard)	referencing	correctly
	and acknowledged.		(Harvard) Some	acknowledged.
/5 marks		All quoted material in	problems with
	All paraphrased material	quotes and	quoted material and	Some problems with
	acknowledged.	acknowledged. All	paraphrased	the reference list or
		paraphrased material	material	bibliography.
	Correctly set out reference list	acknowledged.
	and bibliography included.	Mostly correct setting	Some problems with
		out reference list and	the reference list or
		bibliography included.	bibliography.
Total
/100 marks
Final marks
/20

HI5019 STRATEGIC INFORMATION SYSTEMS T2 2017

STRATEGIC INFORMATION SYSTEMS