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 description Debit/Credit Amount Bank Debit R5130 (R5700*0.9) Trade receivables (Lilies and Lace) Credit R5700 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 5.6 =IF($G16="B",2,1) 6 6.1 =ROUND(B$12-(B$12*B$9),0) 6.2 =($B$3*B$13)*$B$4*B$14 6.3 =IF(B$11,B$19*0.115,B$19*0.09) 6.4 =($B$5*B$12*B$14)*-1 6.5 – a password required for opening or reading workbooks – a password required to make changes to the workbook structure – a password required for changing the content in a sheet or cell MJ 2014 Question 3 3.1 The quality of information is directly linked to the quality of raw data entered – in other words, inaccurate data will lead to inaccurate information and incomplete data will lead to incomplete information, which in turn will result in ineffective decisions. 3.2 A database can be defined as an organised collection of related data that is managed and stored electronically and can provide data to different application software in the organisation. 3.3 Advantages: – Data can be accessed, inserted and/or deleted without changing the database structure. – The database structure can be easily customised for most types of data storage. – Data does not need to be duplicated. – Most users easily understand the structure. – It is easy to search for and extract data from the database 3.4 Logical. The CoA must have a logical flow in the major categories, subcategories and the related account number blocks and individual account numbers. For example, the balance sheet accounts will be first, followed by the income statement accounts. The categories, subcategories and the related GL accounts will not be mixed, but follow each other logically. • Consistent. The account number structure and format must be consistent between the accounts used. • Account description. The account description should clearly but briefly explain the nature of the GL account.