Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

/ / creat a web application using visual studio mvc c# individual account authentication using crud functionality A . Database design and development You are

//creat a web application using visual studio mvc c# individual account authentication using crud functionality
A. Database design and development
You are required to design and develop a SQL database that stores user, product, and transaction
related data:
Identify the necessary entities for your applications 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.
-first the user needs to log in and then go to the products page where they will coose items to add to cart then after the user will press purchase which will take them to the transactions page where they will enter their card information detils then after the user will click confirm and then after they go to the order history page where they can see all of their orders
-The database design efficiently implements the
requirements for KhumaloCraft, including
relevant entities, relationships and constraints.
The necessary tables have been created to
store data related to users, products, and
transactions.
(Evidence includes screenshots of the relational
diagram and database structure)
-The database has been deployed to Azure and is
integrated and accessible to the web
application.
(Evidence includes screenshots of the process
for deploying the database)
-Users can effectively insert data in the database
through the web application. Data related to
products, users, and transactions can be stored
on the database using the web application.
-Product information is retrieved correctly from
the database and displayed in a user-friendly
manner to clients in the web application.
-Functionality for processing and accessing order
information from the database is implemented
in a user-friendly and efficient way in the web
application.
Clients are able to place orders of the craftwork
and can see their previous orders.
KhumaloCraft can see client orders and process
them.
can i get the code for everything to make it work as well as the models ,views and crud pages

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Secrets Of Analytical Leaders Insights From Information Insiders

Authors: Wayne Eckerson

1st Edition

1935504347, 9781935504344

More Books

Students also viewed these Databases questions