Accounting Information System - Leslee Ltd - System Development Life Cycle (SDLC) - Accounting and Finance Assignment Help

Assignment Task:

An accounting information system is a set of interrelated activities, documents, and technologies designed to collect and process data and report information to a diverse group of internal and external users. The knowledge acquired in the first five weeks of the course is used to design a rent cash collection database system. 

This is an introductory course; accordingly, you are not expected to get a complete understanding and knowledge of Database Management Systems (DBMS). However, you will be scaffolded in every step of the assignment during contact hours (lecture and workshops). It is extremely important that you come to the classes and the workshops to receive information about this assignment.

The assignment 

Each individual will design a simple a rent cash collection database system for an organization (the firm, Leslee Ltd). 

The firm rent out properties throughout Auckland and Leslee has been using an Excel to record the rent money she receives. Leslee comes to you asking if you can help develop a simple database management system to help her maintain her rent cash information. A real example of the receipt she provides is shown. 

Requirement 

Informed by the System Development Life Cycle (SDLC) concept covered in Week 1 each individual should: 

1. design a rent cash collection database system for the firm –rubric will be provided next week. 

2. create a DBMS for the rent cash collection database system- rubric will be provided next week. 

1. An individual report based on the rubric given below (not more than 1,500 words). 

2. A workable DBMS. 

More information about Leslee Ltd. 

There are two departments in Leslee Ltd: 

1. Front office: This is where rent received is recorded into the system. Tenants can only pay their rent in the following manner: 

a. Over the counter with cash or EFTPOS. 

b. Bank transfer 

2. Back office: This is where most of the accounting work takes place. 

This is how you will get marks from this assignment. 

Introduction of the assignment

You are to identify what you intend to achieve and an outline of the write up. 

Step 1: Initiation and planning (part of the written document)

Given the firm’s description, you are to identify three financial information needs. One of those needs is to relate to an external stakeholder’s information need. For each of the financial needs, you are to explain why those needs. 

Step 2: Requirement analysis (part of the written document)

Given the needs described in Step 1, identify what the system requires to collect. Each requirement should closely tie to the information needs identified in Step 1. 

Step 3: Design (part of the written document) 

Given the needs you identified in Step 1, you are to design the DBMS accordingly. In this design, you are to: 

1. Include a flowchart to show the flow of documents. 

2. Describe the tables used (not less than two tables). Two tables will be sufficient. 

3. Identify the forms (for what purpose) and reports (for what purpose) 

4. Identify two risks and two related controls in place 

Step 4: Build (not part of the written document) 

Using MS Access, you are to build a DBMS incorporating your design in Step 2. It is highly advisable that you use MS Access. 

Step 5: Testing the system (part of the written document) 

Describe how you tested the system you developed. 

Step 6: Implementation (not part of the written document) 

You are to enter dummy data into the system. You are to print reports relating to the information needs identified Step 1. 

Step 7: Maintenance (part of the written document)

Describe the kind of maintenance that you will undertake. 

Conclusion

This Accounting and Finance  Assignment has been solved by our Accounting and Finance Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.