” KIT214留学生编程 写作、System课程 辅导、SQL编程KIT214 2020 S2Assignment 1Online Shopping System using MVCWeight 15%You need to create an Online Shopping Management System (SMS) using the MVC model. Thissystem is Multi-database registration and search system that allows users to speed up search processfor products using several databases. It relies on separation of concept that makes itreusable, extensible and maintainable. The functionalities for the SMS should be as follows:i. Register: Any user should be able to register an account with following details:a. Name, Username, Age, Address, password, emailii. Login: Any user With an account should be able to log in with following details:a. Username/passwordiii. Search: Any logged in user should be able to search for an item in the databases: By seller name By item name By price By type (e.g. food, electronics, cleaning, toys, furniture) By Year of manufacture (only year YYYY)For deploying and testing your SMS, Nectar Cloud will be used. As a design requirement for SMS, theseparation of database layer from application layer is required. This means your SMS should bedeployed in one VM and your MySQL server will be deployed on the other VM.VM for hosting web application. The structure of your application will look like the following: Controller: receives user query and execute the logic to retrieve results. It will interact withmultiple models and decide which view should be displayed. Model: different models for databases tables. View: different views for different UI partsVM for hosting database server You can create your own database design in MySQL. It should contain tables for Items andUsers etc.KIT214留学生作业 写作、System课程作业 辅导、 You need to create at least 2 databases in MySQL server(a) For items registered before 2015, only item name, seller and price are available(b) For itemsregistered from 2015, item type and year of manufacture are also availablebeside the information in (a) Every database can have the same tables but must contain at least one extra/different columndepending on the information Available. You will also have to create 2-3 VIEWs as suitable.KIT214 2020 S2Based on the above system architecture, your application must be hosted on 1 VM andconnect to MySQL server on another VM to query all databases and report results forSearch feature. Note that not all databases will have the same type of information. best security Practice must be applied to connect to remote MySQL server the results Should be retrieved from all databases for given query You need to configure security groups and open the required ports to allow your applicationto establish a remote connection with MySQL serverFor anything NOT covered in tutorials, you have to search yourself.Submission:You will need to Submit your source code, SQL files for databases and a ReadMe file as a zip filein MyLO, but your VMs must be running for evaluation.Due to Online teaching, You will need to screen record a presentation for this Assignmentwith a recording of your Screen activities and your audio. (Instruction will be given in the tutorials)In this video, you need To explain everything you have done i.e. explain your codeand configurations and why/how you have done them. It should be about 7-10 mins long (notvery strictly).Further details and Checklist on how to make this video will be released later.Please see unit outline for late submission rules如有需要，请加QQ：99515681 或邮箱：99515681@qq.com
“
添加老师微信回复‘’官网 辅导‘’获取专业老师帮助，或点击联系老师1对1在线指导。
