POE Part $2-$ Create a database and integrate to the web application

$($Marks: $100)$

Related Content: Learning Units: $3-4$

Assessment

$\backslash$table$[[\backslash$table$[[$Assessment$/],[$Deliverable$]],$Marks,Weight,Duration$],[$Part $2,\backslash$table$[[80$ total marks. $($Your mark awarded for Part$2$ will$],[$be calculated as a percentage.$)]],25\%,15$ Hours$]]$

Your submission document:

Your answers to the following questions must be submitted in an MS$-$Word document, containing the following:

Your student number

The module code

The URL of your deployed application with the updated functionality

The GitHub link for the web application source code

$,$ ER diagram and screenshots of the database design and structure

Screenshots of the process for deploying the database

Screenshots of the web application $($My Work page$)$

Screenshots that show that users can insert data to the SQL database via the web application

Screenshots that show that users can order any product

Note: Make sure you read the instructions given earlier in this document and follow the specified file name format.

Instructions:

The web application developed in Part $1$ is a useful start in terms of basic functionality. However, at this point, the web application does not allow any transactions, and it does not allow clients to interact with KhumaloCraft since it does not store the necessary information anywhere.

Based on the feedback you received for Part $1,$ you should make relevant improvements to your existing web application. Thereafter, you are required to implement the following enhancements to your web application:

A$.$ Database design and development

You are required to design and develop a SQL database that stores user, product, and transactionrelated data:

Identify the necessary entities for your application's functionality.

Design a database using SQL Server with the different entities.

Write the various queries necessary for your application.

Deploy your database on Azure.

B$.$ Integrating your database and web application

Implement functionality on your My Work page of your web application which replaces the static details of the craftwork with the data from your database.

The data that should be displayed is the product information $($name$,$ price, category, availability$).$

$,$ Ensure that a user can insert data to the database using the web application.

A client should be able to place an order of a craftwork they like, and should be able to view their previous orders.

$,$ KhumaloCraft users must be able to see client orders and process them.

Submitting your document for this part of the POE

Once you have completed your submission doc containing the answers to all the questions above, submit your document using the submission link on the Learn page for this module.

Notes:

Your solution for Part $2$ must incorporate all the requirements from Part $1$ and Part $2.$

Make sure you read the instructions given earlier in this document and follow the specified file name format.