The Database Answers Community
For people interested in Databases
-
Barry Williams
- Male
- London
- United Kingdom
- Share
- Blog Posts (2)
- Discussions (105)
- Groups (7)
- Photos
- Photo Albums
- Videos (2)
Barry Williams's Groups
-
Best Practice in Data ...
26 members
-
Best Practice in SQL S...
20 members
-
Best Practice in Auto-...
5 members
-
Best Practice in Data ...
16 members
-
Best Practice
9 members
Barry Williams's Discussions
Monitoring System
Replied Sep. 17, 2008
Documenting a database
Replied Sep. 13, 2008
help me to create the database schema.
Replied Sep. 13, 2008
Barry Williams's Page
Gifts Received
Barry Williams has not received any gifts yet
Latest Activity
Data Quality is becoming an increasingly important topic.
Look here for advice, tips and hints when your Database is running slowly.
Members in this Group will be able to share experiences, suggestions and gain an understanding about the current Best Practice in Data Modelling
You are invited to join this Group if you are just getting started and are interested in learning about Databases.
Data Quality is becoming an increasingly important topic.
Look here for advice, tips and hints when your Database is running slowly.
Hi Ernest
I have included Data Lineage under Data Governance on my Best Practice Road Map :-
http://www.databaseanswers.org/index.htm
If you click on the top imag ecalled Data Governance it will take you to this page which has a brief discussion...
Barry Williams's Videos
Barry Williams's Blog
Where do our Members live ?
Hi Members,
I created a Google-type map on TripAdvisor showing the 57 Cities around the world where our Members live.
They range from New Caledonia (in the South Pacific), to Los Angeles, Surinam and Moscow, and here 's the map :-
Regards
Barry
Posted on December 8, 2007 at 3:21pm —
My First Monthly Report
Hi Members,
I am pleased to tell you that at the end of the first month, my new Community has members from these countries all around the world :-
Australia, Belgium
… ContinuePosted on November 25, 2007 at 9:24am — 1 Comment
Comment Wall (123 comments)
- At 1:35pm on November 3, 2009,
Hector Sandoval said…
- Would be possible to get the access database for the e-learning data model, I´ll be using it for a project at the university.
Thanks
Hector.
- At 5:02pm on July 21, 2009,
jr said… - thanks Barry, lovely idea, nice site. off exploring now, will post a (better informed I hope) comment soon.
- At 3:05pm on June 12, 2009,
Daniel L. Ford II said…
- Hi Barry,
I would appreciate a copy of the Construction Bid Database when you get a chance.
Thanks,
Dan
- At 9:43am on June 9, 2009,
Robert Duckling said… - Hi Barry,
I think you are a very sexy man, please come visit me on my boat,
or email 06rdudley@jcc.leics.sch.uk
Then we can meet up to talk about databases
- At 9:39am on June 9, 2009,
Robert Duckling said…
- Hi Barry,
I think you are a very sexy man, please come visit me on my boat,
or email 06rdudley@jcc.leics
- At 4:53pm on June 6, 2009,
Guillermo Rodriguez De Leon said… - hi barry, im requesting database Baby-Sitter and Nannies please could you send it?
http://www.databaseanswers.org/data_models/baby_sitters_and_nannies/index.htm
- At 6:42pm on June 3, 2009,
Kumar said…
- hello Barry,
Im requesting databases for Aircraft parts and orders and pizza deliveries.
Thanks in advance,
Kumar
- At 7:14pm on May 22, 2009,
Angy said… - hola!! soy nueva en este espacio...
porfavor podria enviarme la base de datos de "Online Banking Data Model july 28th 2008".
La necesito para una entender mejor el diagrama de esta.. es para una tarea..
Espero su respuesta.. porfavor se lo agradeceria mucho...
- At 12:22pm on April 22, 2009,
Betina said…
- Helloe Barry,
I am 2nd year Student in on of the Higher in stitutions of Learning in Rwanda and My dream is to become a database devoloper, Analyst... and an expert in the world on Technology.Through I am new in this area and Due to fact that we still in the devoloping world, It becomes a challenge for one to meet His/ Her expectations. Its in this regard that I would Wish to Express sincere thanks for your undying commitment to help and Guide pple with the knowledge God gave you.
Futhermore I would kindly request you to Help me fullfil my dreams. There by guiding me in the Below proposed projects of which i Believe will be of a great Challenge for both; My class, Institution,& country at Large.
hellow are the senarios
1. Analysis and Design of a Mobile Application for The Rwanda National Police a case Study of the Anti-Terrorism Unit
Project Objectives
The main objectives of this project are as follows.
• To provide The Rwanda National Police with information in a timely and convenient means.
• To enhance communication between RNP Headquarter and its Departments.
• To reduce costs associated with communicating to Different Departments
• To provide a model that can be adopted by other institutions Such as Ministries, Provincial level etc
Primary deliverable(s)
A mobile application to be hosted within The National Police Head Quarters premises in Kacyiru and an interface accessible in all Police Departments and via any mobile phone.
Tools
• Microsoft Visio or UML (Analysis)
• MySQL or SQL sever (Design/implementation of the database)
• PHP 5 and HTML (development of the application logic and interface)
• Symbian OS (development platform)
• Nokia N series (testing platform)
2 . Development of a Mobile Application for KIST
Project Description
Kigali Institute of science & Technology is a Public institution located in Kigali Rwanda. It has approximately 3000 registered students and still growing exponentially. It offers a number of degree, diploma and certificate programs in Enginering and Science.
Students usually attempt a number of assignments, tests and a final exam in each module KIST to get their exam results. If they want to know their mid semester performance in tests and assessments, the still have to follow up with their lecturers. Additionally, if there is an announcement to be made by the heads of departments or the Rector, a notice has to be put up on the notice boards for the students to read. What happens if a student does not come to the university due to illness or personal reasons?
These problems, among many others have necessitated the need for this project. More than 90% of the student population at KIST has mobile phones. In this project, I will analyze, design and development a mobile application that will be able to provide students with the information they need wherever and whenever they are via their mobile phones. For the students, the system will provide them with tests/assignments/exam results and announcements from the university
Project Objectives
The main objectives of this project are as follows.
• To provide students with information in a timely and convenient means.
• To enhance communication between RTUC and its students.
• To reduce costs associated with communicating to students.
• To provide a model that can be adopted by other institutions of higher learning to deploy similar systems.
Primary deliverable(s)
A mobile application to be hosted within RTUC premises in Kigali and an interface accessible via any mobile phone.
Tools
• Microsoft Visio (Analysis)
• MySQL (Design/implementation of the database)
• PHP 5 and HTML (development of the application logic and interface)
• Symbian OS (development platform)
• Nokia N series (testing platform)
3. PAYROLL MANAGEMENT SYSTEM
This project of payroll management system will focus on developing the software that could make financial records of employee’s salaries, wages, bonuses, net pay and other deductions.
All employees must be registered to the human resource office and will receive a letter explaining how to be paid.the employer deducts taxes and national insurance from their employees’pay and then pay this sum over to the revenue and customs.this can be done monthly or quartely(by the arrangement with revenue and customs) and the various payment methods are explained in the letter.
The payroll officer receive payroll details and print a payslip,execute financial transactions, print a receipt of financial transaction or review,up load the results of work quality audit.
Through literature review and the use of Unified Modeling Language (UML) or MS Visio, VB.Net, SOL Server 2005. This software will help to enables us to input employee’s records to view and print pay lists and pay slip, also this system will compile and keep personal records relevant to payroll, record data for each employee.
Chapiter I: General introduction
1.1.Introduction to payroll
Payroll includes all forms of compesation,such as salaries,sick leave pay,different contribution of taxes of pay.This work focus on answering different problems occuring in the process of payroll management system.
This project of payroll management system will focus on developing the software that could make financial records of employee’s salaries, wages, bonuses, net pay and other deductions.
The payroll officer receive payroll details, print a payslip,execute financial transactions, print a receipt of financial transaction or to review or to up load the results of work quality audit.
Payslip can handle all your company, most demanding payroll requirements whether an employee’s salary is based on time-entrees, wage-rate ,traveled and other things so payslip can show it all. Salaries can be issued semi-monthly or monthly. It also automatically calculates for night differential pay, overtime pay, SSF, health and contribution, with holding tax, loan payment and deductions.
Through literature review and the use of VB, UML, SQL Server. This software will help to enables us to input employee’s records to view and print pay lists and pay slip, also this system will compile and keep personal records relevant to payroll, record data for each employer.
1.2.Problem statement
In many campanies, the work of process payroll quickly and collectely is not easy because the system is not computerized. The existing system takes a long time and high cost due to the big number of employees, so the method used in all these operations is traditional, manual, very low and can cause errors.
But in daily life of human being, he always requires doing his works faster in order to obtain his objectives at time.On the other hand, computer system can perform tasks faster and display results after a short time. From that, this project consists of designing a
database system which can do all those operations quickly and make tasks to be performed with all needed facilities: correctness, speed, with fewer personnel and low cost.
In general payroll exists any where in the world but most of them are build based on foreign country laws and their application of taxes.In our country, some of the companies purchase them at a high price and again more customizations are required depending on companies need. Furthermore the user should need to be trained on how to use accurately that payroll which is always a component of sophisticated software bought for complete management and human resource solution.
Payroll is complex in nature due to involvement of taxation and various laws and by laws for keeping it accurate. Payroll done manually especially in our country requires large employment for maintaining it as well as time consuming leading to late payment and cause document to be lost.
1.3. Criticisms
The actual system used in company to manage payroll is based on deduction ,allowances and classification and the data are recorded into a computer in traditional manner like it is done in classical register books.
The calculation of gross salary is made by using external calculator machines for each employee and for each type of tax.
This system of controlling payment takes a very long time and can cause many errors because as human being it is easy to make mistakes.
1.4.General objective
This project consists of designing a system that can improve the payroll management system of employees quickly and correctly where the records are stored and then accessed easily by the user of the system.
Employee’s attendance days are properly reviewed, approved, processed, documented and accurately coded for accounting and distribution.
Computation for gross pay, deduction and net pay are accurate.
The recording and summarized of payment made are accurate and agree with established account
Classification; tax information derived from payroll activities is accurately and reported collect.
• To prepare the detailed salary record of all the employees in our company
• To generate pay-Slip through the calculation of salary.
1.5. Specific objectives
The specific objectives of this project are as follows:
• Developing a system that can register and store the details about employees
• Developing a system that will help on calculating the employee salary,view the pay slip of a given employee,view the pay sheet and other tasks.
• Developing a system that provides limitations among employees files accessibility.
1.6. Scope of the project
As the title of this project indicates, it is delimited to database that can speed up the operations during the payroll requirement,whether an employee salary is based on time-entries,wage rate or travelled.Salary can be issued semi-monthly or monthly,it also automatically calculate for night differential pay(overtime pay),health and contribution of taxes,also the loan payment and deductions. The research will be conducted in Kabuye sugar works. There are many functions that carried out in management of employee such as:
• Registration of a new employee and perform other related task
• Store different records
• Management of data recorded
• Employee bank account management
To implement all those functions is a very large project that cannot be carried out within the allotted time, reason why this project concerns only with registration, payment and management of employee records and thus net pay is determined by the gross pay,tax deduction.Net pay and all pay and all previous data are finally used to produce a part of pay slip.
1.7. Methodology
The management of payroll system will be realised by using UML,VB and SQL server database containing all tables to be employed in this application and the interface will be created by using an visual programming language which is used to join the database tables and enables insertion, update and generation of report about payroll management system.
- At 6:34pm on March 24, 2009,
Charles R Hubbard said… - Good to be here, will comment soon.
About
Badge
© 2009 Created by Barry Williams on Ning. Create Your Own Social Network
