Skip to content

rv2442/Employee_database_app_py

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

40 Commits
 
 
 
 

Repository files navigation

[GUI] Employee Database App Using Python

This is a GUI Employee Database Application using Python and SQLite having basic functionalities:

  1. create
  2. modify
  3. delete individuals
  4. delete all
  5. import, and export CSV formatted data

Technologies used:

  1. Python (Tkinter, Easygui)
  2. SQlite

Dependencies

pip install -r requirements.txt in cmd / terminal(pip3)
You need to install sqlite browser on your system and create a table using the query:

CREATE TABLE "employee_database" (
	"id"	INTEGER,
	"employeeid"	VARCHAR(255) NOT NULL UNIQUE,
	"name"	VARCHAR(255) NOT NULL UNIQUE,
	"email"	VARCHAR(255) NOT NULL UNIQUE,
	"number"	INTEGER NOT NULL UNIQUE,
	"branch"	VARCHAR(255) NOT NULL,
	"salary"	INTEGER NOT NULL,
	PRIMARY KEY("id")
);

Demonstration

1st Start

image

Add Employee

image


image

Modify Employee Details

image


image

Selective Delete

image

Import Data from csv

image


image

Export Data in csv

image


image

Delete All

image


image