Welcome to our SQL Project !

Explications :

This project was created by three second year students of computer sciences. As part of our SQL lessons, our final exam is a project which consists in the making of a website linked to a database storing the informations of a random company. 🏗️

The use of our website is quite simple : users create departments, positions and employees thanks to complete forms. It then adds these informations to the linked database which is displayed in few web tabs. ✔️

Fonctionalities :

The website allows the user to do few things on their own.

• Home :

  • Actknowledge writers and their code's property

• Departments :

  • List all departments and allows to check on employees

• Add departments :

  • Create a new department to the DB also linked to both departments and positions

• Add position :

  • Create a new position to the DB also linked to departments

• Add employees :

  • Create a new employee to the DB also linked to departments

• Search :

  • Search employees thanks to a search bar

Property :

The project belongs to its authors. ✍️

Authors (3) :

• ACHARD Lisa => [email protected] 👩‍🎓
• CROIZIER Jules => [email protected] 👨‍🎓
• RIVALANT Nicolas => [email protected] 👨‍🎓

Used tools and technologies :

• PHP (OOP) 👨‍💻
• MySQL 🗄️
• Vue ⚙️
• Picocss 🖌️

Credits :

The group is thankfull for LABILLE Auriane's advices and demonstrations with the tool Picocss which saved quantity of time for the front end.

Instructions :

• Git clone the repository

• Project setup :

npm install

• Compiles and hot-reloads for developpment :

npm run serve

• Compiles and minifies for production :

npm run build

• Lints and fixes files :

npm run lint

• Customize configuration : See Configuration Reference

Is everything clear ? Alright ! 🎉

Final step... Enjoy ! 😄

-------------------------

Nantes YNOV Campus - B2 Informatique - 2023/2024

SQL Project - 2023

-------------------------