E-hub is a software company that provides various types of software solutions to clients across India. Design a system that enables the end user to view, add, edit or delete employee details of the organisation. The user can retrieve employee details just by entering their employee ID. Similarly, maintain their client details so that the end user can view, add, edit or delete client details. Also they can generate reports on their deliverables, employee and client details.
The application we made is primarily aimed towards the company admin and the various clients working with the company.
The hosting is now totally complete link for website https://e-hub-with-react-and-flask.vercel.app/
https://drive.google.com/file/d/152yvvYL-PvYGeLL2wNvOQPDDqae4Y1HT/view?usp=sharing
for working of website create a s.py file with the parameters host, dbname ,user ,password
host=""
dbname=""
user=""
password=""
id: CLI001
password: something
id: ADM001
password: 12345678
id: EMP001
password: qwerty
- client will recieve a mail on signup
- Change the password or forgot password button
- Enhancing data security within the database through the application of the Caesar cipher.
pip install flask
pip install psycopg2
pip install -U flask-cors
create table login(
id varchar(20),
username varchar(30),
password varchar(30),
email varchar(50)
primary key(id)
);
cerate table person(
id varchar(20),
name varchar(40),
email varchar(50),
primary key(id)
);
create table client(
client_id varchar(20),
company varchar(30),
primary key(client_id)
);
create table employee(
emp_id varchar(20),
experience int,
emp_join_date date,
role varchar(30)
primary key(emp_id)
);
create table project(
project_id varchar(20),
client_id varchar(20),
project_name varchar(20),
project_log varchar(1000),
domain varchar(20),
project_leader varchar(20),
primary key(project_id)
);
create table project_team(
project_id varchar(20),
project_leader varchar(20),
members varchar(500)
);