This file contains a timeline of what was done for the project by each group member and the timestamp for the same
Project created in Github. Updated Log file. User: Aaradhy
Topic possibility discussed : Arcade Shop inventory subsystem. Updated Log file. User: Aaradhy,Dhruv,Unnat
Topic changed to making a system similar to unstop website where hackathon, competitions etc are tracked and offered. Updated Log file. User: Aaradhy,Dhruv,Unnat
Topic discussed thoroughly and finalised as the one discussed above. Updated Log file. User: Aaradhy,Dhruv,Unnatt
We started making entities and entity models for the users, organisers etc.. Updated Log file. User: Aaradhy,Unnat
Completed with the Entity Relationship Model (ER Model) for the project. Updated Log file. User: Aaradhy,Dhruv,Unnat
Completed with converting the Entity Relationship Model into an Enchanced Entity Relationship (EER ) model and listing down all the entities. Updated Log file. User: Aaradhy,Dhruv,Unnat
Completed with converting the EER Model that we made above into a Relational Schema. Updated Log file. User: Aaradhy,Dhruv,Unnat
Submitted the EER Model along with the Relational Schema on the portal on Blackboard. Updated Log file. User: Dhruv,Unnat
New team member added: Jasmehar
Digitally started to recreate the ER Model to enchance it and make it easier to code. User: Dhruv & Jasmehar
Finished creating the EER Model digitally. Users: Dhruv & Jasmehar.
Finished creating the EER,Relational Model Digitally. Users:Aaradhy,Dhruv,Unnat,Jasmehar
Started converting the Relational model into a mySQL database using SQL queries. User: Aaradhy
Finished converting the relational model into a mySQL database which was exported and verified among the rest of the team members. User: Aaradhy, Unnat
Started creating the backend using axios and node.js, express and linking it to the SQL database. User: Aaradhy
Started working on the frontend framework using vite react vanilla javascript and Tailwind CSS. User: Aaradhy
Implemented CORS connection facility in the backend server and got the backend server running locally on http://localhost:8080/ User: Aaradhy
Finished with the frontend UI design & linked the backend framework to the frontend framework. User: Aaradhy
Finished adding some functionality as well as implemented a simple admin level hardcoded login form in the webapplication. User: Aaradhy
Given the first project evaluation to the Assigned TA. User: Aaradhy,Dhruv,Unnat,Jasmehar
Added various crud procedures to the database. https://github.com/Aaradhy-Sharma/dbms-project-1/blob/main/Screenshot%202024-03-19%20at%2019.10.13.png User: Aaradhy
Looking for various options to implement user and admin level access separately for the dbms. User: Aaradhy, Jasmehar
Started working on making different access modes for user and admin level access. Kept as783 as an admin level authorization and dm409 as a user level. User: Aaradhy
Started refining the database to support normalisation forms etc... User: Aaradhy
Finished with separate admin and user level views. Kept as783 as an admin level authorization and dm409 as a user level.
- Added support for dark and awesomify mode User: Aaradhy
Added normal and dbnormal() function and procedure respectively to the database. normal() is used to check the current highest normalisation form of a table taken as input(tablename) and dbnormal() takes db name (proj) in our case as input and then proceeds to call normal() for all the tables present in the database. User: Aaradhy
Tried fixing the error of undefined values being sent to the backend in response to crud/edit operations being performed in the frontend. I have been unsuccessful in trying to find a fix for the same despite spending multiple hours on the same. The same is left for the other team members to try and resolve in the remainder time.