AIN2601 PAST EXAM PAPERS, BEST FOR REVISION

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 t