Free Tutorials, Linux Command, Source Code Architecture,  Software Engineering, Intelligent Systems, RDBMS, Computer Accounting,  Operations Research, Discrete Mathematics, Network, SAD Lay Networks Lay Networks
Computer Science Networking Operating Systems Linux and Unix Source Code Script & Languages Protocols Glossary
Web laynetworks.com
Google
 


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

Archive (E-R Diagram for Hospital)       Question 2: TMA Dec2000      TMA JAN 2001
Back
Next
FDDI Frequently Asked Questions (FAQ), The function and frame format of FDDI,Aloha,Comparative analysis between two types of ATM Switches,Knockout Switch,Barcher-Banyan Switch,Various popular standards for compressing multimedia data,Distributed Multimedia Survey: Standards, ASCII to hex value chart,Comparative analysis - TCP - UDP, Addressing Formats and QoS parameters, Bellman Ford's Algorithm Lay networks, free, java, java script, asp, vb, linux, ignou, tutorial, Unix commands, System Analysis, System Design, Ipv6, quiz, download, free, Computer Architecture, Object Oriented System, Relational Database Management Systems, Object Oriented System, Operating Systems, Software Engineering, Communications and Networks, Discrete Mathematics, Intelligent Systems, Operations Research, Accounting and Finance on Computersmca, networking, protocols, glossary, assignment, project, tma, programming source code, programming, source code, unix, free
 
Book Mark/Share this site at BlinkBits BlinkList Blogmarks co.mments Delicious Digg Fark Furl it! Google Ma.gnolia Netvouz NewsVine RawSugar Reddit Shadows Simpy Stumble Technorati YahooMyWeb

Copyright © 2000- 2007 Lay Networks All rights reserved. 
This website is best viewed in Firefox 1.0.1 above.

Web Hosting sponsored by Customized Software Company India
Web Site Designed by Web Designing, Flash Animation, Multimedia Presentations, Broacher/catalogue designing, Web Promotion 
Refer to your freind About Us Legal IGNOU Contact Us Feedback Donate to laynetworks.com Download Management Tutorials Tutorials History Search here