ACCOUNT MANAGEMENT SYSTEM PROJECT REPORT

PROJECT SOURCE CODE

ACCOUNT MANAGEMENT SYSTEM PROJECT SOURCE CODE

BANK ACCOUNT MANAGEMENT SYSTEM PROJECT REPORT

BANK MANAGEMENT SYSTEM PROJECT SOURCE CODE FREE DOWNLOAD

ONLINE BANK MANAGEMENT SYSTEM PROJECT DOCUMENTATION

ONLINE BANK MANAGEMENT SYSTEM PROJECT SOURCE CODE

DataBase ONLINE BANK MANAGEMENT SYSTEM PROJECT

SPONSORED LINKS

5000 DAILY USE ENGLISH SENTENCES IN HINDI

ABSTRACT ACCOUNT MANAGEMENT

Department has been experiencing a lot of problem especially data track and error in retrieved information there fore it is of great importance to them to take advantage over the accounting application this system with the personal account ability to store , process and gives out information with a lot of accuracy.

The student management system is an improved Student Management System. It can handle all details about a student. The details include lecture, subject details, student personal details e.t.c.

In case of current system they need a lot of time, manpower e.t.c here almost all work is computerized. So the balance sheet accuracy is maintained. Student management system is managed by an administrator. It is the share account management system project report free download job of the Business account management administrator to insert update and monitor the accounting application whole process .The system has four modules. They are

student details

subject details

lecturer details.

1.2 BACKGROUND OF CURENT SYSTEM.

The school of social sciences is a school which track the personal data of student registered in the to manage account department each and every year and keeps the share account management system project report free download record.

Currently they use Microsoft exel to track their data but due to increasing population the to manage account excel has become slow in data retrievement and therefore after preliminary investigation I realize that there is a need for a better system.

The current system is a semi computerized system where the data are printed out at the tally the accountant balance sheet end of every semester to allow new entry of data. The current system they are using Is Microsoft exell which still can not compute complex questions which can be handled by Microsoft access.

1.3 Problem statement

The data in this system are kept manually especially after the accounting application end of every semester which makes it difficult to search data after a good number of years when a student need to know some of his details. It takes time to search on the to manage account pile of files. Also there are some questions which the personal account system can not answer which has to be done manually like if asked to find subjects which were done by phanuel in 2006. You will have to search manually and write down which actually takes a lot of time.

1.3 Objectives

1.3 .1 General objective.

To develop a database system which can easily store, retrieve and update data.

1.3.2 Specific objectives

• The system is to eliminate their manual counting of student taking a particular subject to a computerized system which can query.

• The system is to shorten the to manage account time of retrieving data when required.

1.4 Justification

The current system is unreliable it is likely to deteriorate when the to manage account number of students increase in the to manage account department. After proposed system every tasks will take short time and no more wastage of files to keep some data which can stay within the to manage account system for over years.

1.5 Scope

The system will capture information about student’s personal details lectures and the bank account management courses. Storing updating and retrieving in a fast and accurate way.

Access database comes over the accounting application rest of the Business account management databases due to a number of reasons. Being one of the Business account management database pioneers, Access has became more easy to use as well as learning because of this it make developing a new database system much quicker compared to others such as Oracle, My sql etc. Microsoft access has been considered because of its ability to support and enhance the appearance and navigation of html generated. (Carry N Prague,micheal R. Irwin,and jennifer Reardon access 2003 bible pg952) The fact that access is always upgraded makes it easier and compatible with new systems. For example Access 2003 uses ASP technology which also complies with new technologies such as XML. (Cary N Prague, Micheal R. Irwin, and Jennifer Reardon access 2003 bible)

Access was most preferred because of its ability to create dynamic data and html pages and they can be displayed in Microsoft Explorer 5.0. Cary N Prague, Micheal R. Irwin, and Jennifer Reardon access 2003 bible Access has the share account management system project report free download ability to export and import data through ADODB which is a common connector among most web application. MySql Though MySql is well known for being capable of handling very powerful and large data bases it also has a couple of setbacks that the tally the accountant balance sheet developer could not take chances with it. MySql does not support transactions or concurrent update of complex table which if used would have become a huge hindrance to the balance sheet development of the Business account management system project report free download in the to manage account making. Oracle Oracle is very well known for the accounting application use of SQL statements. It is one of the Business account management most expensive databases on the to manage account market. There is no graphical interface for creation or modification of tables. This implies that the tally the accountant balance sheet use of this database is very time consuming.

2.2 Justification for the accounting application use of SQL

This is also another data retrieving language that is used by most databases i.e. Microsoft Access, Oracle and MySql. There are quite a number of reasons for the accounting application use of SQL. One of the Business account management most common reasons why most web developers’ use this language is because it is easy to use and a standard query language that can be used for both database and web pages. Because of the Business account management fact that SQL is can be used to manipulate data in all ways, it can be used to retrieve, create, store or even update records.

2.3 Feedback- for every action on a system:

A feedback is necessary in order to confirm that the tally the accountant balance sheet action been executed or accomplished for without feedback it becomes difficult to continue or to move to the balance sheet next level. On designing the company account interaction design the to manage account designer require design principle guiding tool. Feedback is one of the Business account management guiding principles, this is very essential for both the personal account user and the bank account management designer because it is an aspect that can lead them to the balance sheet next step of their task. These principle are based on common sense, experience as well as theory based knowledge. In order to have a well designed interface the most common principles one ought to observe are consistency that is the share account management system project report free download ability to observe uniformity, visibility, affordance and constraint. In the to manage account simplest terms these principles could be defined as:

Uniformity:

Consistency is very vital and this refers to the balance sheet ability to maintain uniformity in the to manage account system interaction design. This implies the share account management system project report free download system follows a certain criteria for example: The use of certain operations to log on to a system. All in all, consistence makes learning very easy and quick for the accounting application new users as well as the share account management system project report free download existing ones. April 13, 2009 BSC(HONS) BUSINESS INFORMATION SYSTEM 21

Visibility:

The visibility of functions enable the user to know how to manipulate or use the system, for that matter it’s very important to mind where and how functions are placed, as for the accounting application case of the Business account management system project report free download, the making of links and icons are very important because they have to be visible enough.

2.4 Affordance:

Affordance is another principle that could refer to clues that enable the user to know how to use the system it is also defined as “an attribute of an object that allows the share account management system project report free download people to know how to use it” (interaction design beyond human-computer interaction 2nd edition by John Wiley & sons, ltd page 33) though affordance is categorised into two and that is real and perceived affordance.

Constraint can be referred to as controls or limitations that are within a system allowing what actions to be done during the company account interaction the to manage account common constraint use is the share account management system project report free download deactivation of some menus while another action still executes. This is very important because if graphical representations that are used to constraint the tally the accountant balance sheet users’ interpretation of a problem or information. (Interaction design beyond human-computer interaction 2nd edition by John Wiley &sons,ltd page 31) As for the accounting application case of the Business account management patients’ online booking system, it could be referred to as perceived affordance because it is web base which means it is virtual. Therefore all the library account mentioned principle should be present in a well designed system and all these can be witnessed in the to manage account finished product of the Business account management patients booking system. There are quite a number of problems that might a result from the college account need to apply all design principles. The attempt to recreate physical objects into a virtual form in order to achieve affordance may result into absolute difficulty to be used. In that case such a principle could be ignored. Visibility of information may be compromised if constraint is over emphasised within an interface. All in all these design interaction principles are all applies trade-offs may occur. (Interaction design beyond human-computer interaction 2nd edition by John Wiley&Sons Ltd page34)

CHAPTER 3

3.0 Methodology

After the accounting application feasibility studies it was decision time to decide what methodology will suit the tally the accountant balance sheet development of the Business account management required system. The system to be developed for the accounting application project will be done by applying software engineering tools and techniques. The analysis and design is concerned with understanding the company account current and the bank account management proposed system requirements. In other to do this systematically, a methodology will be applied so as to go through the personal account systems development life cycle.

The life cycle is the share account management system project report free download process of development which is to be followed in stages in order to develop a computerized information system. These stages are to be developed in sequence and one stage has to be completed before going on to the balance sheet next stage.

It is a bit difficult to define the term methodology but still there are many definitions from different authors. Here are some few of them

[Check land, 1981]: “a methodology is a set of principles which in any particular situation have to be reduced to a method uniquely suitable to that particular situation.”

[Avision & Wood-Harper, 1995 Pg. 20]: “a coherent collection of concepts, beliefs, values and principles supported by resources to help a problem-solving group to perceive, generate assess and carry out in a non-random way changes to the balance sheet Information situation.”

[Vision & Fitzgerald, 1988]: “a methodology is a collection of procedures, Techniques, tools and documentation aid which consists of phases...but a Methodology is more than merely a collection of these things. It is usually based on some philosophical view, otherwise it is merely a method, like a recipe.”

After analysis and design here are some of the Business account management methodologies which I considered before coming up with the personal account final methodologies I used in order to achieve the development of a system which will meet the tally the accountant balance sheet specification of the Business account management users with bounds specified by the accountant business. be working and reliable meet the tally the accountant balance sheet requirements of the Business account management users, i.e. meet the tally the accountant balance sheet business objectives of the Business account management users.

This is Yourdon Structured Method (YSM) and Soft Systems

Yourdon Structured Method (YSM) was derived from the college account works of Edward Yourdon, Tom DeMarco and Larry Constantine. This methodology was considered for the accounting application project development. Reasons for considering the company account methodology are:

It has been updated on a regular basis since its appearance on the to manage account system development scene so it is hoped it will meet a modern day system development demands.

It also have a good modeling tool which is expected will suit the tally the accountant balance sheet system developed.

Though the personal account methodology was considered I found it will not be suitable for the accounting application

Development of the Business account management proposed system. The reasons for its rejection are:

It stages are not precisely defined and it is not well documented

It does not lay much emphasis on modeling current system. It advocates going straight to the balance sheet modeling of the Business account management required logical system. This is not advisable for the accounting application current project as the share account management system project report free download current system needs to be understood to be able to propose a required system.

Soft Systems Method which was derived from the college account work of Check land (1981, 1990) was also considered for the accounting application project. The reasons behind the bank account management consideration were:

The methodology approach concentrates on the to manage account human aspects of a problem area it finds way of improving human activities mainly business objectives which may or may not be associated with automation i.e. computerization.

Despite these attributes the share account management system project report free download methodology was not deemed right for the accounting application development of this system.

The reasons being: the methodology does not believe in breaking down complex problems into smaller fragments.

Breaking down of the Business account management problem is needed for this project as this will help in understanding of the Business account management problem domain very well.

It does not operate in a tightly defined and more prescriptive manner, i.e. it is not well structured. It is flexible, which can lead to confusion in system development to a junior analyst like me.

It identifies a problem but does not really suggest ways of solving the company account problem, leaving the company account analyst to provide options for solving the company account problems themselves. One of the Business account management main reasons for using a methodology is to tackle the problems associated with lack of control and non-standard of methods in system development which is compromised by Soft Systems Methodology.

After consideration of several methodologies there are two methodologies are used for the accounting application development of the Business account management system project report free download. They are Structured Systems Analysis and Design Method (SSADM4) Version 4

Prototyping For the accounting application design, Structured Systems Analysis and Design Method (SSADM) will be used while Prototyping will be used for the accounting application implemented process. The type of prototyping to be used will be incremental prototyping.

Structured System Analysis and Design Methods, SSADM is a systematic approach to the balance sheet analysis and design of Information Technology, IT applications designed by Central Computer and Telecommunication Agency, CCTA. It is a collection of activities which exploit a collection of techniques. These techniques include Data Flow Modeling, Logical Data Modeling, Relational Data Analysis and many more.

The reasons behind using the company account methodology, Structured System Analysis and Design Methods are very many. They are:

The methodology suits both large and small system development because it fits their needs. It is designed to be customized and can be tailored by using only those elements which are useful to the balance sheet system been developed. This makes it a methodology which is focused and effective

It advocates user involvement which gives a better understanding of the Business account management business activities and user needs.

The methodology is well supported by documentation.

The methodology is widely known and taught, because of this there is an extensive skill base available which helps in system maintenance of the Business account management system project report free download

Prototyping was chosen as the share account management system project report free download methodology to be used in the to manage account later phase of the Business account management Development life cycle of the Business account management proposed system. This is due to the balance sheet fact that SSADM does not cover all part of the Business account management life cycle the other reasons why this

Methodology was chosen are listed below:

it involves a lot of user involvement in the to manage account new system development which will guarantees a system of high quality.

It helps to work out the tally the accountant balance sheet details of the Business account management design and to test them in a way that can not be done on paper

It allows users and operators of the Business account management new system to see how the system may look and feel and decide if there are new features to be added to it

By implementing a prototype, the users can see the inputs and outputs from the college account new system and can decide on what format they want which can be changed until the library account user requirements are met, before the final system is built.

It enable me and the bank account management user of the Business account management new system to make sure that the tally the accountant balance sheet right system is been built before too much time is and effort has been put in It enable the aspect of the Business account management system project report free download which is of interest to be built and tried out

By spending time on the to manage account development and testing of prototypes first, rather than going straight ahead to build the bank account management real thing, the finished version should be produced early.

It is a way of reducing risk, since any error noticed during development can be corrected immediately because the cost of correcting these errors at a later stage can be quite expensive.

Software package considered

The main software package considered here is Microsoft access and the bank account management reasons why it was considered are:

It enhances quick information retrieval. It can be used on-line by the accountant firm to be able to answer clients’ queries quickly and efficiently regarding their cases.

It reduces data redundancy and duplication. With the personal account Database Manager System,

DBMS duplication of files is avoided. This reduces wastage of space.

Consistency of data is maintained in a database system. The same data will appear throughout the tally the accountant balance sheet system when added or updated.

CHAPTER 4

4.0 System design.

4.1 Data Catalogue

Below are the data field to be used in the to manage account required system and the bank account management description of each of the Business account management fields.

4.1.1 STUDENT TABLE.

Studentno - student number is a proper identification of students in the to manage account table students. The primary key for the accounting application database table STUDENT

Studentname - it is the share account management system project report free download name of the Business account management STUDENT

Studentgender-it is the share account management system project report free download sex of the Business account management student(Male,Female)

Studentresidentialstatus - it indicates whether the accounting application student is a border or a dayscoler

Studentphonenumber - it indicates the share account management system project report free download student contact phone number.

Studentyear – it indicates each year a student is registering in the to manage account campus

studentsemester - indicates the share account management system project report free download semester registered in the to manage account year above.

4.1.2 SUBJECT TABLE.

Coursetitle – It indicates the share account management system project report free download name given to a particular course e.g. Basic Mathematics.

Courseno – it uniquely identifies the share account management system project report free download Course with the personal account table.

Coursecode – It shows the share account management system project report free download school code given to identify the accountant course (e.g. DMCT 098)

Coursecredithours- it indicates the share account management system project report free download hours for which the personal account course is taught in a week.

Courseroom- it indicates the share account management system project report free download room where the course is taught.

Course days- indicates the share account management system project report free download days in which a given course is taught e.g. MTW(Monday, Tuesday, Wednesday)

4.3 Sample structured query language and the bank account management out put on the to manage account display screen.

1. To find the bank account management subjects which were done by Assimwe Julius and the bank account management credit hours in the to manage account year 2005? This is the share account management system project report free download query format.

SELECT COURSE.ctitle, COURSE.ccredithours

FROM STUDENT INNER JOIN (COURSE INNER JOIN ASSOCIATIVE ON COURSE.cnumber = ASSOCIATIVE.cnumber) ON STUDENT.snumber = ASSOCIATIVE.snumber

WHERE (((STUDENT.sname)="ASIIMWE JULIUS") AND ((STUDENT.syearofstudy)=2005));

2. To find which subjects are tought by Dr Tabitha Sigue. This is the share account management system project report free download format.

SELECT

2. To find which lecturer is teaching the company account subject with the personal account title “social defense”. This is the share account management system project report free download query format.

SELECT

3. This is the share account management system project report free download same as sample number 1 but different year.

SELECT 2008;

3. To know the name of student coming from Zambia.

CHAPTER 5

5.0 Challenges, Recommendations and conclusions.

5.1 Challenges

1. The major challenge I encounter during the company account system development is the share account management system project report free download time box.

2. Lack of free access to computer to any time you wanted because of the Business account management classes which was sometimes going on in the to manage account computer labs.

3. Data access was sometimes difficult because secretaries we were suppose to receive data from were not willing to give full data thinking that if the Business account management system project report free download is developed they may loose their job.

5.2 Recommendation

I’ve successfully applied what I have learnt in our institution. Also, I can enhance my skills and abilities that can make me boost in my technical skills. And also I became understandable and gained many experiences how to negotiate relationship between users and clients. Problem solving is my major achievements in this period of application project. Therefore, we fully understand the bank account management whole SDLC.

5.3 Conclusion

Great skills have been achieved during the company account development of this project, time management being one of them, research in various areas of web and database development and at the tally the accountant balance sheet end of the Business account management day it can be said that the tally the accountant balance sheet task has been a great success incorporated with extraordinary challenges. All in all the library account sleepless nights, stressful days and hard work have paid off and besides some good moments were also experienced. These experiences will be used for ever.

References

Books

Cary N prague, micheal R. Irwin,and jennifer Reardon access 2003 bible

Entity relationship diagrams [online]MDM Summit Europe(20-22/04/09)London

http://searchcrm.techtarget.com/sDefinition/0,,sid11_gci333128,00.html accessed on (17/03/09)

Pressman, Roger S., Software Engineering: A Practitioner’s Approach. McGraw-Hill, 2001.

Bergner, Terry; Steiny, Julia and Armstrong, Jane. (2007). Benefits of and Lessons Learned from Linking Teacher and Student Data. National Center for Educational Accountability, Data Quality Campaign.www.DataQualityCampaign.org

Berry, Barnett. (2007). Connecting Teacher and Student Data: Benefits, Challenges and Lessons Learned.Center for Teaching Quality. www.teachingquality.org

Borden, Victor M.H. (1995). Harnessing New Technologies for Student Tracking. In P.T. Ewell (ed), Student Tracking: New Techniques, New Demands (New Directions in Institutional Research #87, pp.55-67. San Francisco: Jossey-Bass.

Cunningham, A. F., and Milam, J. (2005). Feasibility of a Student Unit Record System Within the to manage account Integrated Postsecondary Education Data System (NCES 2005-160). U.S. Department of Education, National Center for Education Statistics, Washington, DC: U.S. Government Printing Office.