Build a web application with CRUD functionality

Assignment Help Web Project

Reference no: EM132422699

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

Part 1 - Describe your chosen application area and its functionality.

- Provide a database ERD (no more than 4 tables).

- Define the api endpoints required.

- Define access control for public and admin users.

Part 2 - Create an Azure SQL database with the required tables and sample data.

- Create a user with limited permissions for access via the server app.

- Provide an SQL script to create the database and add sample data.

- Configure the SQL DB Firewall to allow these addresses: 193.1.123.51 - 193.1.123.52 and 79.97.88.49.

Part 3 - Build the server-side Rest API which will allow the data to be accessed.

- Define routes to act as api endpoints (supporting required CRUD functions).

- Use Passport to control access to resources.

- All data should be sent and received as JSON.

- All input data should be validated before use.

Part 4 - Build a client web application using HTML, CSS, and JavaScript. The application should:

- Run in a single page.

- Use Bootstrap 4 for layout and styling.

- Display data in an appropriate format.

- Allow a user to login, logout.

- Control access to functions by conditionally display UI options based on whether a user is logged in.

Part 5 - Marks will be awarded for documentation and code quality and also descriptive code comments.

Reference no: EM132422699

Questions Cloud

Analyse the ethical and legal issues discussed in this case : BUSS 1004 Business Law Assignment Help and Solution - Middle East College, Oman. Analyse the ethical and legal issues discussed in this case

Do you believe government efforts to manage the economy : Do you believe government efforts to manage the economy usually make things better or worse? Provide research support for your position

Explain the rationale for free trade : Question: Explain the rationale for free trade and why there are times when free trade is not beneficial.

Defining features of the product in jazzercise : How the company is differentiating itself from competition What is your substantiated opinion of the potential rebrand effectiveness?

Build a web application with CRUD functionality : Description - You are required to build a web application with CRUD functionality (create, read, update, and delete) with user access control

What could cause the effort to fail : Facebook has decided to increase its customer base by creating new services to compete with what they have. How could this be done successfully?

Negatively to sprint plan to attract new customers : Why do you think the stock market reacted negatively to Sprint's plan to attract new customers?

Develop a critical understanding of future trends in hrm : develop a critical understanding of future trends in HRM within the context of current academic literature. The second purpose is to develop your oral communica

Amazon virtual assistant alexa assignment : Amazon Virtual Assistant Alexa Assignment help and solutions:- digital marketing concepts explain how you'll market that product in 2019.

User Account

All Pages