[go: up one dir, main page]
Scribd
Upload
53 views3 pages

Nodejs.+ React Machine-Test-Nadsoft.

The document outlines a machine test project involving API CRUD operations for student data using Node.js and PostgreSQL, along with a React.js frontend. It includes tasks for designing a normalized database schema, implementing RESTful API endpoints, adding pagination logic, and creating a user-friendly interface with Bootstrap forms. Additional deliverables include a zip file of the project code, SQL scripts for the database, and a Postman collection for API testing.

Uploaded by

Danish Ibrahim Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
53 views3 pages

Nodejs.+ React Machine-Test-Nadsoft.

The document outlines a machine test project involving API CRUD operations for student data using Node.js and PostgreSQL, along with a React.js frontend. It includes tasks for designing a normalized database schema, implementing RESTful API endpoints, adding pagination logic, and creating a user-friendly interface with Bootstrap forms. Additional deliverables include a zip file of the project code, SQL scripts for the database, and a Postman collection for API testing.

Uploaded by

Danish Ibrahim Khan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Machine Test

Task Overview: API CRUD operations for student data with normalized tables,
and implementing pagination logic using Node.js and PostgreSQL, with React.js
frontend

Task 1 : Database Schema Design


• Provide a normalized database schema for storing student information and their
marks. Ensure that the schema follows best practices for normalization.
• Include tables for students and marks.
• Specify the relationships between these tables using foreign key constraints.

Task 2 : API CRUD Operations


• Implement RESTful API endpoints using Node.js for CRUD operations on student
data.
• Create endpoints for:
• Creating a new student record
• Retrieving a list of all students
• Retrieving a single student by ID with marks
• Updating a student's information
• Deleting a student record
• Use Postman or any other application to test API endpoints and ensure they
function correctly.

Task 3 : API Pagination Logic


• Extend the API created in Task 2 to support pagination for retrieving lists of
students.

• Implement pagination logic using query parameters such as page and limit.

• Ensure that the API returns paginated results along with metadata like total count
of records.

Task 4 : React.js Frontend Integration to interact with NodeJs APIs


• Design Bootstrap forms using React.js to interact with CRUD operations on

student data.
• Implement a Bootstrap list view to display paginated student records.

• Integrate SweetAlerts for user feedback on create, update, and delete operations.
Additional Deliverables:

• Code Zip: Provide a zip file containing the Node.js project code, including all
necessary files and dependencies.

• Database Schema SQL Script: Include SQL scripts to create the necessary tables
and relationships in the PostgreSQL database.

• API Collection: Export the Postman collection containing requests for testing the
API endpoints. This collection should include sample requests for each CRUD
operation and pagination logic.

You might also like