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
, 4.6.4 View
4.6.5 File
4.7
4.7.1 Balance forward processing
4.7.2 They pay regularly and on time.
They only buy once a month (low number of transactions).
4.8
4.8.1 Quotation
4.8.2 Sales order
4.8.3 Delivery note
4.8.4 Sales invoice
4.9
4.9.1 outstanding quotation report
4.9.2 outstanding/open sales order report
4.9.3 credit note analysis reports
4.10
4.10.1 Decrease
4.10.2 Increase
4.10.3 Increase
4.10.4 Decrease
Question 5
5.1 =PMT((B$4/12),(B$5*12),$B16,$C16,0)*-1
5.2 =$D16*(1/1.14)
5.3 =MID($A16,7,3)
5.4 =RIGHT($A16,1)
5.5 =VLOOKUP(F16,A$9:C$13,3,TRUE)
Page 3 of 17
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
, 4.6.4 View
4.6.5 File
4.7
4.7.1 Balance forward processing
4.7.2 They pay regularly and on time.
They only buy once a month (low number of transactions).
4.8
4.8.1 Quotation
4.8.2 Sales order
4.8.3 Delivery note
4.8.4 Sales invoice
4.9
4.9.1 outstanding quotation report
4.9.2 outstanding/open sales order report
4.9.3 credit note analysis reports
4.10
4.10.1 Decrease
4.10.2 Increase
4.10.3 Increase
4.10.4 Decrease
Question 5
5.1 =PMT((B$4/12),(B$5*12),$B16,$C16,0)*-1
5.2 =$D16*(1/1.14)
5.3 =MID($A16,7,3)
5.4 =RIGHT($A16,1)
5.5 =VLOOKUP(F16,A$9:C$13,3,TRUE)
Page 3 of 17
