a)Explain the difference between an ERP and an AIS?

b)A small business operates from home, producing children's clothing. They currently sell their product through local retail shops in the same city only. As well as continuing to sell in local shops, they decide to start selling their product online in an e-commerce solution, what implications will this have for the pricing of the product and profit margins per sale?

c)Describe in your own words and in simple terms how the Blockchain prevents fraud. Do not copy and paste definitions (or you will get no marks) but use your own language to describe how it prevents fraud. Do not use detailed analysis but just give a simple overview.

d)AIS (accounting information systems) use both data and information. What is an example of data and an example of information in an accounting context.

Q2.4 marks (1 mark each)

Given the table of data below:

DOGS

DogID

DogName

MicrochipNumber

BreedID

1

Rusty

1234567890

3

2

Max

8877665544

1

3

Chadwick

2233445566

3

Primary key = DogID

BREEDS

BreedID

BreedName

1

Tenterfield terrier

2

Labrador

3

Mini fox terrier

Primary key = BreedID

a)If I delete the row in the Breeds table for the Tenterfield terrier, what are the implications of that?

b)Using the example of the Dogs and Breeds tables above, describe what Referential Integrity is and what it would prevent?

c)Why is the BreedName in a separate table and not simply in the Dogs table instead of the BreedID?

d)What are 2 advantages of a 3-tier architecture scheme for software?

Q3.4 marks in total

a)(3 marks)

A mining company keeps a database on its train journeys. Each train has recorded its engine number and engine capacity. The engine number is different for every engine. The mining company only does certain trips with its trains from the mines out to the ports. Each trip route has a source and destination as well as an estimated amount of time the trip should take. Trains complete the trips as required. When a train does a trip the date and actual duration for the trip by that train is recorded.

Draw an ER diagram to represent the above scenario. Make sure to indicate primary keys on the diagram as well the cardinalities (the one to many, many to many etc) of the relationships.

Insert your ER diagram in here

or

upload it to Learning @ Griffith as a separate file

b)(1 mark)

Determine the resulting tables for the train trips database and list each table name along with the columns that make up that table and indicate each of the primary keys.

Q4.4 marks (1 mark each)

a)What is data analytics useful for in a business context?

b)Give 2 reasons why a business might want to introduce a data warehouse?

c)The Dominoes Pizza Checker:

i.From each pizza going under the Dominoes Pizza Checker, what sort/type of data is collected by the machine for comparison with the data in its database?

ii.For what purpose is it checking this data?

iii.Which one is this an example of - Machine Learning or Artificial Intelligence?

d)If your business was to collect data for monitoring a person's health condition through data collected from wearables (i.e. people wearing a device on them and this data is collected over time and stored in your company database):

i.Would this most likely be structured or unstructured data you would be collecting?

ii.What responsibilities would your company have in regards to that data from a data governance point of view?

Q5.4 marks

Draw a BPMN diagram for the credit approval process for a bank for its loan application process.The below narrative description is available: The credit approval process begins with a company submitting a loan application. A bank officer enters the application data in the database. Then the loan decision process starts. Firstly, a credit history is requested from an external credit reporting body.In the next step, the bank decides on the loan approval.Credit history and the application data are considered and if either is not satisfactory the loan is rejected, and a notification is sent to the company.Otherwise, the loan is approved, and the decision is sent to the company.

Insert your BPMN diagram in here

or

upload it to Learning @ Griffith as a separate file

Q6.4 marks (1 mark each)

A cashier created a fictitious invoice so it would appear to have genuinely come from his brother-in-law's company. The cashier then made a payment for the invoice to his brother-in-law's company.

a)Explain how the principle of separation of duties is violated.

b)You run a small retail shop. List 2 things/processes you could put in place to help prevent theft by staff.

c)At a trailer rental business, replacing the wheel bearings for each trailer would cost $600 each. Using the standard product version of the wheel bearings means they have a 40% risk of failure per year.

By buying a premium product wheel bearing kit, the risk of a failure for a year is reduced to 25%. The extra cost of the premium wheel bearings is $160 extra per trailer.

Is it worth the business moving to the premium wheel bearing product?

d)What is the cost difference (show your working)?

Q7.4 marks (1 mark each)

a)You have started work at Bell Financials where they offer financial advice to their clients. Bell keeps a database of their clients and their financial records. They have just read about the ransomware attacks on Spotless Inc and ask you for your advice on ways to protect themselves. List 5 things Bell should be doing to help protect their core database of client information from ransomware attacks.

b)Because of your valuable responses around ransomware, Bell management ask for your opinion about whether they should consider moving their existing accounting software into the cloud (as their accounting software they have installed in the offices is now available as a cloud based option). You decide to just tell them the advantages and disadvantages of having a cloud based system and let them make the decision. What would you tell them?

c)Explain a fraud technique in relation to the revenue cycle.

d)In the revenue cycle as discussed in the lectures, who does the Shipping Department notify when they process a shipment?

Q8.4 marks (1 mark each)

a)Explain the concept of three-way matching within the expenditure cycle.

b)The coronavirus has shown the short comings of just-in-time (JIT) inventory systems. Explain why the JIT system is unsuitable in such an environment as the current Covid19 pandemic.

c)What is the difference between the Purchasing process and the Accounts Payable/Cash Disbursements process i.e. overall, what are they about (don't overthink it - this is a simple question)?

d)In the expenditure cycle as discussed in the lectures, when the goods are received, the Vendor's account is credited. Which chart of account's account is debited?

Q9.4 marks (1 mark each)

a)Give an example of financial statement fraud.

b)What could be the motivation for the person to commit this fraud you specified in the previous question (a).

c)Explain why a balanced scorecard is a better view of a company for an investor than the Financial Records alone?

d)Explain how you could use the IoT in a business to prevent problems before they occur?

Q10.4 marks (1 mark each)

a)What is the effect in the Operation phase of the SDLC (System Development Life Cycle) if you make mistakes during the Analysis phase of the SDLC?

b)

i.What is the riskiest implementation strategy for implementing a software change?

ii.Why is doing it this way risky?

c)You are at the start of the process of looking for a new software system to replace the current system you use. What is a strategy you could employ to help reduce user resistance of the new software?

d)In the current coronavirus pandemic, many businesses were stopped from operating in their normal way. Some businesses re-invented themselves with completely new ways to service their customer base. These businesses could be said to have implemented what sort of business process improvement methodology?

Q11.4 marks (1 mark each)

a)In your own words, briefly explain what PayID is, and give an example of what would constitute a valid PayID.

b)What has the New Payments Platform enabled that was not possible before it existed i.e. what is its massive advantage now for a business?

c)Give an example of a digital twin.

d)The Australian government is considering making XBRL reporting mandatory for various business reporting options. To a potential investor, what is one advantage of companies using XBRL for financial reporting, than if they were using traditional PDF's and printed documents?