OnlineBus Reservation, Study Guides, Projects, Research of Software Development

Download OnlineBus Reservation and more Study Guides, Projects, Research Software Development in PDF only on Docsity! A PROJECT REPORT ON EMPLOYEE MANAGEMENT SYSTEM Group No.1 SUBMITED BY: 1. Bachani Heena V (1240) 2. Patel Dipti N (1276) GUIDED BY: Mr.Prahlad sharma SUBMITED TO: Shree Siddhivinayak Charitable Trust Sanchalit Shree Gajanad Institute of Management & Computer Studies, Visnagar, Gujarat – 384 315 Project Definition Online Employee Management System For use in Easily take emp info. Developed For Shree Gajanand Institute of Management & Computer Studies, Visnagar External Guide Mr. Rakesh Patel Internal Guide Mr. Prahlad Sharma Team Size 2 Team Members Bachani Heena V, Patel Dipti N Front End ASP.NET 2.0 Back End SQL Server Express Edition (2005) Add. Tools Html ,CSS Project Duration 50 Days  In new system all the draw back of manually system was removed.  To counting the records of the students is very easy and faster.  For view the records of students very easy in this system.  Using computerize system time is saving and it less man power required.  Quick problems or requirement solved through new system. Project Definition ► Visual Studio 2008 with C#.net ► SQL Server 2005 ► Microsoft Office 2003 ► Photoshop 6.0 ► Microsoft Paint 4.0 Leave Application Process 1.0 Login process 2.0 Emp detail Process ADMIN emp info get info emp leave report response response tblLogin tblReg tblLeave u/p response u/p response emp id get info give salary salary desc salary details tblSalary salary desc 3.0 salary Process emp leave A emp report salary report 5.0 Reports 4.0 Leave Application Process 1.0 Login process 2.0 Leave Application Process EMPLOYEE emp info Leave detail add profile tblReg tblLeave response u/p response emp info leave detail emp id get salary info tblSalary salary info 3.0 salary Process u/p emp id update profile details details Table Name :- tblReg Field name Data type Constraint Description Rid Int foreign key Empuserid sur name Varchar(50) Not null Empsurname First name Varchar(50) Not null Empfirstname Password Varchar(50) Not null EmpPassword Bdate Smalldatetime Not null emp birthdate Gender Char(1) Not null Empgender Phone int Not null Empphone Email Varcahr(50) Not null Empcurrentadd Que Varcahr(50) Notnull Empque Ans Varcahr(50) Not null ans Resume Varcahr(50) Not null resume Table Name :- tblLeave Field name Data type Constraint Description id Int Foreign key id Email Varchar(50) Not null Empemail Depart Varchar(50) Not null depart Descr varchar(50) Foreign key Description Type Varchar(50) Not null Leave type End_Date Date time Not null Ending date Table Name :- tblWork_Detail Field name Data type Constraint Description W_id Int foreign key Empworkid Email Varchar(50) Not null Empemail Date Datetime Not null Date of work Dep Varchar(50) Not null Department Descr Varchar(max) Not null Description Entity-Relationship Diagram ADMIN has 1 M Aid Apw SALARYgive 1 M view EMPLOYEE Eid Epw 1 1 1 Sid Sdetail LEAVE provide M MM apply Lid Ldetail PROFILE Pid Pdetail update manage Form Layout + B) Web Slice Gallery ~ | (@ Untitled Page (@ Intranet settings are now turned off by default. Intranet settings are less secure than Internet settings. Click far option: irs 41111990 Than k Yo u