MNREGA(The Mahatma Gandhi National Rural Employment Guarantee Act ) is a scheme by which unskilled people of rural India are guaranteed to have 100 days of paid work. Main objective of this project is to manage employments offered through this scheme. There are two users of this system :

1. Block Development Officer (BDO)
2. Gram Panchayat Member (GPM)

A project is created by BDO. A project is where people are assigned to. Before assigning anybody to a project(done by Gram Panchayat member) his/her data must be inserted into the system.

1. BDO table
2. GPM table
3. Project table
4. Employee table

create table BDO
(
id int primary key,
name varchar(12),
email varchar(25),
username varchar(12),
password varchar(16)
);

create table GPM
(
id int primary key,
name varchar(12),
email varchar(25),
username varchar(12),
password varchar(16)
);


or

create table GPM as select * from BDO;
alter table GPM add primary key(id);

create table Projects
(
projId int primary key,
projName varchar(20)
);

create table Employees
(
emp_id int primary key,
emp_name varchar(12),
proj_id int,
work_days int,
wage_perday int,
foreign key (proj_id) references Projects(projId)
); 

1. Login into their account.
2. Create a project.
3. View the List Of Projects.
4. Create a new Gram Panchayat Member(GPM).
5. View all the GPM.
6. Allocate the Project to GPM
7. See the List of Employees working on that Project and their wages.

1. Login into their Account.
2. Create Employee.
3. View the Details of the Employee.
4. Assign Employee to a Project.
5. View the total number of days Employees worked on a project and also their wages.