Advanced Computer Applications In Business
St. Joseph’s College of Commerce M.I.B. 2015 III Sem Advanced Computer Applications In Business Question Paper PDF Download
| ST. JOSEPH’S COLLEGE OF COMMERCE (AUTONOMOUS) | ||
| END SEMESTER EXAMINATION –SEPT/OCT.2015 | ||
| M.I.B. – III SEMESTER | ||
| P2 11304: ADVANCED COMPUTER APPLICATIONS IN BUSINESS | ||
| Duration: 3 Hours Max. Marks: 100 | ||
| SECTION – A | ||
| I. | Answer any SEVEN questions. Each carries 5 marks. (7×5=35) | |
| 1. | Explain the difference between Data processing and Data interpretation with an example. | |
| 2. | ‘The IS Audit creates a significant impact on Data Integrity’. Justify the statement with a proper example. | |
| 3. | What are the different Applications of Watermarking? Take a scenario which can replicate this concept. | |
| 4. | Prepare a flow chart to explain the steps involved in SDLC? During which phase will the company take more time in development of a product? | |
| 5. | Are Expert systems or Strategic Information Systems more beneficial to a company when they are progressing towards the long term? | |
| 6. | Enumerate the different steps involved in Information Systems Development with proper examples. | |
| 7. | Distinguish between HTML and DHTML. How can XML be more effective when it comes to retrieval of data? | |
| 8. | Is ERP a technology or a concept. What is the advantage for a firm when it implements ERP? | |
| 9. | What is the difference between BPO and KPO? Mention one Industrial example that can justify their processes. | |
| 10. | Explain five financial functions of EXCEL which can play a significant role in analyzing data. | |
| SECTION – B | ||
| II. | Answer any THREE questions. Each carries 15 marks. (3×15=45) | |
| 11. | Explain the significance of data processing in businesses with elaborate examples. | |
| 12. | What is the difference between
-Database Administration and Database Programming -System Analysis and System Maintenance -Authentication and Authorization |
|
| 13. | BCP aims at advancements in technologies without work uninteruption. Explain the above statement with the help of an example. | |
| 14. | Software Engineering Process stresses on overall process improvement in terms of deliverables to the client. Elucidate this statement. | |
| 15. | PWC provides different services to Unilever. Explain the different services provided by PWC and its significance in real time. | |
| SECTION – C | ||
| III. | Case Study (1×20=20) | |
| 16. | National Australia Bank (NAB) is a financial services organization employing more than 40,000 people, operating more than 1,800 branches and service centers, and responsible to more than 460,000 shareholders. The company provides more than 10.93 million customers worldwide with retail, business, and institutional banking services. NAB wanted to eliminate inconsistencies arising from storing data in 34 different financial and operational systems. The organization lacked consistency in how it maintained data about cost centers, branches, and general ledgers for various business units. To remedy this situation, the bank wanted to establish a master data repository underlying all of its information systems so that changes to data elements in one system would be applied universally across all other systems. In addition, by establishing a standard change-control process, bank officers would be able to prevent ad hoc, unjustified and erroneous data updates that could result in financial misrepresentations or inaccurate data in regulatory reports. They wanted to ensure that all finance systems stored data and produced results in a consistent manner.
To achieve these goals, the bank decided to replace an aging, inflexible mainframe system used as a pseudo master data management tool with a more sophisticated, true master data management solution from Oracle. Working with Oracle Consulting, the bank implemented Oracle Hyperion Data Relationship Management to manage master data assets in 34 applications including human resources, general ledger, planning, and finance. To prepare for the Oracle implementation, NAB spent weeks gathering system requirements for interface designs. An Oracle consultant provided initial training on Oracle Hyperion Data Relationship Management. The bank opted for a centralized maintenance and governance approach, where one team looks after the master data. The implementation team included one project manager, two NAB team members, and a consultant from Oracle Consulting. It took three months to deploy Oracle Hyperion Data Relationship Management and the results have been exceptional. The new system ensures data consistency by establishing a formal, automated change control process where updates to the master data system are fed into or applied to all the other finance and operational systems. When master data was migrated from the bank’s mainframe and other systems to Oracle Hyperion Data Relationship Management, NAB improved data quality from 90 percent to 99 percent by cleansing the source data and reducing the number of duplicate records. In addition, improving data quality has improved data accuracy in regulatory reports designed to improve supervision, transparency, and disclosure while enhancing risk management and governance practices in the Australian banking sector. Managers have greater insight into the state of the bank’s worldwide financial operations thanks to having a single, master view of financial data. a) What are the different inconsistencies experienced by NAB? b) Examine in detail the measures adopted by the bank to eliminate these inconsistencies. |
|