联系方式

  • QQ:99515681
  • 邮箱:99515681@qq.com
  • 工作时间:8:00-23:00
  • 微信:codinghelp

您当前位置:首页 >> Database作业Database作业

日期:2020-08-18 10:49

KIT214 2020 S2

Assignment 1

Online Shopping System using MVC

Weight 15%

You need to create an Online Shopping Management System (SMS) using the MVC model. This

system is Multi-database registration and search system that allows users to speed up search process

for products using several databases. It relies on separation of concept that makes it

reusable, 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, email

ii. Login: Any user with an account should be able to log in with following details:

a. Username/password

iii. 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, the

separation of database layer from application layer is required. This means your SMS should be

deployed 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 with

multiple models and decide which view should be displayed.

? Model: different models for databases’ tables.

? View: different views for different UI parts

VM for hosting database server

? You can create your own database design in MySQL. It should contain tables for Items and

Users etc.

? 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 available

beside the information in (a)

? Every database can have the same tables but must contain at least one extra/different column

depending on the information available. You will also have to create 2-3 VIEWs as suitable.

KIT214 2020 S2

Based on the above system architecture, your application must be hosted on 1 VM and

connect to MySQL server on another VM to query all databases and report results for

Search 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 application

to establish a remote connection with MySQL server

For 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 file

in MyLO, but your VMs must be running for evaluation.

Due to Online teaching, you will need to screen record a presentation for this Assignment

with 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 code

and configurations and why/how you have done them. It should be about 7-10 mins long (not

very strictly).

Further details and checklist on how to make this video will be released later.

Please see unit outline for late submission rules


版权所有:留学生编程辅导网 2018 All Rights Reserved 联系方式:QQ:99515681 电子信箱:99515681@qq.com
免责声明:本站部分内容从网络整理而来,只供参考!如有版权问题可联系本站删除。