Final Examination IDE424 Information Systems PDF

Colegio de San Juan de Letran Intramuros, Manila College of Engineering and Information Technology Industrial Engineering Program...

Colegio de San Juan de Letran Intramuros, Manila College of Engineering and Information Technology Industrial Engineering Program FINAL EXAMINATION IDE424 – Information System 1st Semester, AY 2024 - 2025 Inst. Eunice Y. Gayoma, CIE Score: ____________ Name: _______________________________________ Section: ____________ Student No.: _______________________________________ Date: ____________ GENERAL DIRECTIONS / INSTRUCTIONS: ▪ Strictly no erasures. Write legibly. Use a black pen only. Place your bag in a designated area. LEARNING OUTCOMES: To demonstrate students' understanding of concepts related to the following topics: information systems, organizations, and strategy, ethical and social issues, foundations of business intelligence including databases and information, and e-commerce encompassing digital markets and goods. I. TRUE OR FALSE (1 point each) Write T if the statement is true. Otherwise, write F. Write your answer in the blank space provided. 1. Operations of a Relational D B M S are JOIN, SELECT, PROJECT. 2. OLAP stands for Online Analytical Processing. 3. Web mining is called Discovery and analysis of useful patterns and information from the web. 4. Typical configuration includes a Web server, Application server/middleware/C G I scripts, and Database server (hosting D B M S). 5. Advantages of using the web for database access: Ease of use of browser software, Web interface requires few or no changes to the database, and Inexpensive to add a web interface to the system. 6. Online Analytical Processing supports multidimensional data analysis such as viewing data using multiple dimensions and in different sizes. 7. Web Mining Extracts key elements from large unstructured data sets 8. Before a new database is in place, a firm must: Identify and correct faulty data Page 1 of 5  Colegio de San Juan de Letran Intramuros, Manila College of Engineering and Information Technology Industrial Engineering Program 9. Before a new database is in place, a firm must: Establish better routines for editing data once the database is in operation. 10. Extracting key elements from large unstructured data is called Test Mining. 11. An example of Data mining is customer buying patterns. 12. OLAP supports multidimensional data analysis 13. In–memory- computing can reduce hours/days of processing to seconds. 14. A correct data model is essential for a system serving the business well. 15. Many D B M S have report-generation capabilities for creating polished reports. II. IDENTIFICATION (1 point each) Write your answer in the blank space provided. Do not abbreviate your answer. 1. Collects data from many divisions of the firm for use in nearly all the firm’s internal business activities 2. Built around thousands of predefined business processes that reflect best practices. 3. Network of organizations and processes for Procuring materials, transforming materials into products and distributing the products. 4. Components arrive as they are needed. 5. Information about product demand gets distorted as it passes from one entity to the next across the supply chain. 6. Build-to-Stock 7. Demand-driven 8. C R M stands for. 9. Kind of CRM that is Customer-facing applications. 10. Based on data warehouses populated by operational C R M systems and customer touch points. 11. Number of customers who stop using or purchasing products or services from a company Page 2 of 5  Colegio de San Juan de Letran Intramuros, Manila College of Engineering and Information Technology Industrial Engineering Program 12. Flexible reporting, ad hoc analysis, “what-if” scenarios, digital dashboards, data visualization 13. ERP stands for 14. Center of How Enterprise Systems Work. 15. Buffer for lack of flexibility in the supply chain. III. MULTIPLE CHOICE (1 POINT EACH) Encircle the correct answer. 1. Transactions cross cultural and national boundaries. a. Ubiquity b. Global reach c. Universal Standards d. Richness 2. One set of technology standards: Internet standards a. Ubiquity b. Global reach c. Universal Standards d. Richness 3. Supports video, audio, and text messages a. Ubiquity b. Global reach c. Universal Standards d. Richness 4. Marketspace is virtual. a. Ubiquity b. Global reach c. Universal Standards d. Richness 5. Technology permits the modification of messages and goods. a. Interactivity b. Information density c. Personalization/Customization d. Social Technology Page 3 of 5  Colegio de San Juan de Letran Intramuros, Manila College of Engineering and Information Technology Industrial Engineering Program 6. Greater price and cost transparency a. Interactivity b. Information density c. Personalization/Customization d. Social Technology 7. Promotes user content generation and social networking. a. Interactivity b. Information density c. Personalization/Customization d. Social Technology 8. Single digital marketplace for many buyers and sellers. a. Net marketplaces b. Private industrial networks c. Exchanges d. B2B 9. Large firm using a secure website to link to suppliers and partners. a. Net marketplaces b. Private industrial networks c. Exchanges d. B2B 10. Independently owned third-party Net marketplaces for spot purchasing. a. Net marketplaces b. Private industrial networks c. Exchanges d. B2B IV. DRAWING (1 POINT EACH) Draw the SYSTEMS DEVELOPMENT PROCESS. V. FILL IN THE BLANKS (1 point each) Put the specific process in the shape that is needed in the Redesigned Process for Purchasing a Book Online. Page 4 of 5  Colegio de San Juan de Letran Intramuros, Manila College of Engineering and Information Technology Industrial Engineering Program YES Access online Book bookstore Available? NO -End- Prepared by: Checked by Approved by: Inst. Eunice Y. Gayoma, Asst. Prof. Katrina L. Lee Assoc. Prof. Jacqueline D. Reynoso, PhD CIE Faculty Chairperson Dean Name: _______________________________________ Section: ____________ Student No.: _______________________________________ Date: ____________ Page 5 of 5