AIN2601 PAST
EXAM PAPERS,
BEST FOR
REVISION LATEST
COMPILATION
2021
,October/November 2014
3.1. Disadvantages
Start-up and operating costs. (Hardware, software and personnel)
Database systems are complex to design and use.
Because databases are complex, it is very time-consuming to design a proper
database.
Database or database management software failure will affect all application
software linked to that specific database.
3.2
Type of MIS output report Example of report
Financial MIS payment summaries
Manufacturing MIS inventory information
Marketing MIS sales information
HR MIS payroll administration
3.3 XBRL stands for Extensible Business Reporting Language and is used when
financial information is exchanged in XML format. XBRL can broadly be defined as
the electronic communication of financial and business information to all
stakeholders.
3.4
3.4.1 Data mining: Data mining software is used to analyse data sets in order to
uncover previously unknown trends, patterns and relationships between data.
Online analytical processing (OLAP): Online analytical processing (OLAP)
software enables users to interactively and rapidly analyse large data sets from
various viewpoints.
OLAP is mainly used to summarise data, say, per month and per region, the number
of smart phones sold to persons aged 20 to 30 years. Data mining is used to break
down data in order to uncover trends, patterns and relationships.
3.4.2 Multidimensional model
Page 1 of 17
, 3.5 DBMS enables users to
design, create and maintain the database structure and the database
control the organisation, storage and retrieval of data in the database
capture, maintain (delete, insert and amend) and manipulate the data in the
database
share data between multiple users simultaneously
execute queries and generate outputs
control the movement of the data between authorised users and the database
control and monitor access to the database
analyse and monitor database performance
Question Four
4.1 The customer account for Lilies and Lace is setup incorrectly on the early terms.
The early terms should be 10% within 10 days from period end but in the screenshot
it shows as setup for 10% within 10 days from invoice date which is incorrect.
4.2 .
General ledger account Debit/Credit Amount
description
Bank Debit R5130 (R5700*0.9)
Trade receivables (Lilies and Credit R5700
Lace)
VAT Debit R70
Settlement discount granted Debit R500
4.3 Foreign key: When a primary data field of a database file is entered into another
database file to create a relation between the two database files, the primary data
field in the other database file is known as a foreign key.
A foreign key does not uniquely identify a record and may have duplicates in a
database file. The use of foreign keys prevents the duplication of data.
4.4 Account
4.5 The customer is not required to be a registered VAT vendor to purchase from Polka Mazurka.
Polka is a registered VAT vendor – all customers will be required to pay VAT on purchases and all
payments will be captured in the Bank inclusive column and this raise output on VAT on all sales.
4.6
4.6.1 Setup
4.6.2 Edit
4.6.3 Process
Page 2 of 17
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Examhub. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.86. You're not tied to anything after your purchase.
