Sem 5 DBMS project using Next.js and Prisma

Team Members

• PES1UG22CS264 - K N Sunav - Sunavkn
• PES1UG22CS275 - Karan Prasad Hathwar - musashi-13

Problem statement

A vehicle service and parts management system built using Next.js, Prisma, PostgreSQL, and tailwindcss. With the database hosted on Neon we are able to have the entire project up and running.

How to run

• Clone the repository
  • git clone https://github.com/musashi-13/cerberus-dbms-project
• Install dependancies
  • pnpm install
• Create .env file with your jwt token, database url, and database user.
  • DATABASE_URL="..."
• Migrate the schema to your database
  • pnpm prisma migrate dev
• Run the project
  • pnpm dev

Nextjs Database system - project checklist

Setting up the project

• Create and set up next.js typescript project with tailwindcss
• Create schema for the database
• Connect neon database with the project
• Migrate schema and populate the tables

Frontend

• Build a frontend with next.js and tailwindcss
• Design the website layout and features
• Set up routes and pages
• Add assets

Backend

• Write authentication backend
• Write database queries for the project specifications - login, employee login, signup, update and delete account, create/get/delete appointments, creata/get/delete vehicles, add feedback, get employee appointments and accept appointments
• Test user creation and login
• Test cascading deletes and changes

Pending Implementation

• Create employee, parts management, and a few more features
• Bug Fixing