Assignment Problem:
Assignment Description: You are required to build a web application with CRUD functionality (create, read, update, and delete) with user access control.
The application should include client and server components with a database storing data:
1. The server should be a RESTful web api built using Nodejs and Express.
2. The client should be built using HTML, CSS, and JavaScript. Use the Fetch api to make calls to the server api endpoints.
3. Use an Azure SQL database for storage
Assignment Part 1: Describe your chosen application area and its functionality.
a) Provide a database ERD (no more than 4 tables).
b) Define the api endpoints required.
c) Define access control for public and admin users.
Assignment Part 2: Create an Azure SQL database with the required tables and sample data.
a) Create a user with limited permissions for access via the server app.
b) Provide an SQL script to create the database and add sample data.
c) Configure the SQL DB Firewall to allow these addresses: 193.1.123.51 - 193.1.123.52 and 79.97.88.49.
Assignment Part 3: Build the server-side Rest API which will allow the data to be accessed.
a) Define routes to act as api endpoints (supporting required CRUD functions).
b) Use Passport to control access to resources.
c) All data should be sent and received as JSON.
d) All input data should be validated before use.
Assignment Part 4: Build a client web application using HTML, CSS, and JavaScript. The application should:
a) Run in a single page.
b) Use Bootstrap 4 for layout and styling.
c) Display data in an appropriate format.
d) Allow a user to login, logout.
e) Control access to functions by conditionally display UI options based on whether a user is logged in.
Assignment Part 5: Marks will be awarded for documentation and code quality and also descriptive code comments.
Our Web Application with CRUD Functionality Assignment Help service is the topmost online service provider organizations in the industry and a number of students acquire their dream grades by availing our online services.
Tags: Web Application with CRUD Functionality Assignment Help, Web Application with CRUD Functionality Homework Help, Web Application with CRUD Functionality Coursework, Web Application with CRUD Functionality Solved Assignments, SQL Database Assignment Help, SQL Database Homework Help