代写程序接单-University of Adelaide - 2022 COMP SCI 2207/7207 Web & Database Computing Final Assessment Practice

University of Adelaide - 2022 COMP SCI 2207/7207 Web & Database Computing Final Assessment Practice 

 Complete the tasks on the following pages before the Due date. You must use one of the approved development environments with telemetry enabled. See the environment setup page (available in Week 13) for details. Submit your work via Gradescope and the Submission Assessment. You can only make multiple submissions, but only your last submission before the deadline will be marked. Failure to submit before the submission cutoff will result in a mark of 0. Part 1 You have been hired to design a web application for an online shop that sells shoes. The system requires the following features: Users can search the different shoes available Shoes can be searched/filtered by: Shoe Size Different shoe styles Different Brands/Labels Price Users can sign-up and log-in Users can order shoes Users can view their order history Thinking about such a system, complete the following tasks: Task 1.1 (30 marks) Design a database schema diagram for the system described. Be sure to include appropriate relationships and cardinalities. Be sure to normalise the schema to at least 3rd normal form. Submit as an image or pdf file. Task 1.2 (10 marks) When building a database schema, N-N relationships need to be properly reduced/decomposed. 01010417 Briefly discuss how this applies to the system you've designed in Task 1.1 and, specifically in terms of your system and its relationships, explain how this relates to database normalisation. Task 1.3 (30 marks) Implement your database schema from Task 1.1 in MySQL When you create the database Ensure appropriate tables, data types, keys and integrity constraints are present. Add at least 1 row of test data to each table. Download a backup/dump of the database and upload as a .sql Task 1.4 (10 marks) Write a SQL query to retrieve the name and email address of all users who bought a given item in the last 5 days. You can assume the item's unique indentifying information is provided. https://adelaide.mobius.cloud/modules/unproctoredTest.QuestionSheet 1/2 2022/6/3 晚上7:20 University of Adelaide - 2022 COMP SCI 2207/7207 Web & Database Computing Final Assessment Practice Task 1.5 (160 marks) Implement a basic web application for the search feature of this online shop. Use only the technologies covered in this course: HTML & CSS JavaScript, AJAX, & basic client-side Vue.js NodeJS/Express MySQL Only implement the search page/feature and any necessary supporting code on the server. Users should also be able to filter search results by: Shoe Size Different shoe styles Different Brands/Labels Price Be sure to follow best practices as discussed throughout the course. Excluding the node_modules folder, submit/upload your implementation as a zip file The marks for this task are assigned as follows: Up to 30 marks for functionality Up to 20 marks for HTML & CSS Up to 20 marks for client side JS and Vue Up to 20 marks for AJAX requests Up to 20 marks for server side routes Up to 20 marks for MySQL integration Up to 30 marks for good UX, standard compliance, maintainability & security practices Task 1.6 (15 marks) Betts (https://www.betts.com.au/) is an example of an online shop that sells shoes. Identify a feature present in both the Betts website, and your implementation from Task 1.5. Specifically in terms of perceivability and kinematic load, discuss how these two systems compare https://adelaide.mobius.cloud/modules/unproctoredTest.QuestionSheet 2/2 


51作业君 51作业君

Email:51zuoyejun

@gmail.com

添加客服微信: ITCSdaixie