Scribd
Upload
9 views2 pages

React Assignment

The project aims to develop a Single Page Application (SPA) with CRUD functionality for a dynamic data table, utilizing SQL Server and Prisma ORM for database interactions. The frontend will be built with NextJS and will include features such as displaying sales data, best-selling products, and annual/quarterly sales and profit metrics. Form validation will be implemented using Zod or a similar library to ensure data integrity before submission.

Uploaded by

parthiv192
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views2 pages

React Assignment

The project aims to develop a Single Page Application (SPA) with CRUD functionality for a dynamic data table, utilizing SQL Server and Prisma ORM for database interactions. The frontend will be built with NextJS and will include features such as displaying sales data, best-selling products, and annual/quarterly sales and profit metrics. Form validation will be implemented using Zod or a similar library to ensure data integrity before submission.

Uploaded by

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

PROJECT OBJECTIVE:

Build a Single Page Application (SPA) that includes CRUD (Create, Read,
Update, Delete) functionality on a dynamic data table. The application
should interact with a SQL Server database using Prisma as the ORM for
seamless database interaction. The frontend will be built using NextJS to
provide a smooth and interactive user experience.

PROJECT REQUIREMENTS:

1. Database:

 SQL Server will be used as the database engine.


 Prisma ORM will be implemented for seamless database interaction.

2. Data Table (use ag-Grid if possible):

 Create a database using the provided script file, which includes a


sales table with the following columns: id, sale_date, product,
customer_id, quantity, unit_price, total, discount, profit, city, and
county.

 Display this data in data table, and perform the following operation:
o Best-Selling Product
o Annual Sales and Profit
o Quarterly Sales and Profit

3. CRUD Operations:

 Create: Add new data.


 Read: View data in a data table.
 Update: Edit existing data (if possible, use inline editing).
 Delete: Remove data from the system.

4. Form Validation:

 Use Zod or any relevant validation library to validate forms before submission.
TECHNICAL STACK:
Frontend:

 React (or your preferred frontend framework)


 React Router for navigation
 CSS/SCSS for styling
 Zod or another form validation library for form handling

Backend:

 NextJS
 Prisma ORM for database operations
 SQL Server as the database engine

You might also like