Laynetworks  
Web laynetworks.com Google
Home | Site Map | Tell a friends
Journal of Management
Management Tutorials
Download
Tutorials
History
Computer Science
Networking
OS - Linux and Unix
Source Code
Script & Languages
Protocols
Glossary
IGNOU
Quiz
About Us
Contact Us
Feedback
 
Sign up for our Email Newsletter
 
Get Paid for Your Tech Turorials / Tips

 

 

Home > Computer Science > DBMS
 
CS 01 CS 02 CS 03 CS 04 CS 05 CS 06 CS 07 CS 08 CS 09 CS 10 CS 11 CS 12 CS 13 CS 14 CS 15 CS 16 CS 17
Page : 1 2
DBMS
 
Produce an E-R diagram, which documents the entities and relationships involved in the Employee information and Payroll system. Create a relational schema to held information and perform normalization to the tables and fully implement the code using MS-Acess/FOXPRO/DBASE/ or any similar package. Provide necessary documentation for the project.

Note: Assumptions can be made where ever necessary.

Introduction

Pay is the key to work. It is very important from the organization’s as well as employee’s prints of view. It is with this system an organization maintains its good will among its employees. This important calculation cannot be error-prone or mistimed. So, matter of importance. Computerization of the systems does this to a large extent. This prime aim calls for the Computerized Employee Payroll System.

E-R Diagram

Without understanding the relationship between an employee with his organization we cannot build the payroll system. The below E-R Diagram illustrates the relationship between an employee and an organization, only then we would be able to design the process that needs to be computerized to build the system.

The diagram documents the entities and relationships involved in the employee information and payroll system. It depicts the fundamental relations like recording personnel information, paying salary and getting a loan.

The E-R Diagram for a Employee Payroll system can be simple as well as complex

It can be as simple as below:

Or it can be more complex then above:
Or It can much more complex then above
TOP
Page : 1 2