BUS2206 INFORMATION SYSTEMS MANAGEMENT

Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

BUS2206 INFORMATION SYSTEMS MANAGEMENT

TIME ALLOWED: 2 HOURS

An information system turns data into information to help decision making at various organizational levels. Based on your understanding of information systems, answer the following three questions:

a)  What is the difference between data and information?                                            (2 marks)

b) What are the main functions of an information system?                                           (4 marks)

c) An information system contains three dimensions: organization, management, and technology. Describe FOUR factors in the Technology dimension that we typically consider when implementing an information system.               (4 marks)

Question 2 (15 marks)

Suppose you were an IT consultant hired by the ParknShop, one of the largest supermarket chains in Hong Kong, to help the company improve its customer relationship. A brief introduction of ParknShop is provided below.

Answer the following three questions:

a)  What are enterprise applications?                                (2 marks)

b) What are the FOUR major types of enterprise applications?     (4 marks)

c)  Describe with THREE exampleshow ParknShop could use information systems to optimize customer relationship in HongKong.     (9 marks)

Question 3 (11 marks)

a)  What are the three basic operations used to manipulate data tables in relational database? (9 marks)

b) Please explain the rule of referential integrity in relational database.      (2 marks)

Question 4 (8 marks)

a) In relational database, data analysis is performed based on two-dimensional data tables. However, OLAP (Online Analytical Processing) extends data analysis to multi-dimensional. Please give one example of multiple information that may involve in OLAP.   (3 marks)

b) Data mining is another data analysis tool providing insights into data that cannot be discovered through OLAP. Data mining uses inferring rules to discover patterns in data. Please describe the FIVE types of information obtainable from data mining. (5 marks)

Question 5 (6 marks)

a)   Please explain what the term big data refers to.         (2 marks)

b) Name two opportunities and two challenges that big data creates.   (4 marks)

Question 6 (5 marks)

a)   Given the following enterprise system (ERP) with centralized database connecting various departments. Please give an example to illustrate how the ERP facilities business process. You need to replace A,B, C, and D with real business departments.                     (4 marks)

b) What is the benefit of having centralized database connecting various departments? (1 mark)

Question 7 (10 marks)

There are two categories of supply chain management systems, which are supply chain planning systems and supply chain execution systems.

a)  Please name THREE main functions of supply chain planning system. (3 marks)

b) What is the main function of a supply chain execution system?    (1 mark)

c)  What is the name of the supply chain model shown in the following diagram?     (2 marks)

d) What should be filled in the rectangles A, B, C, and D?   (4 marks)

Question 8 (10 marks)

Figure 1(b)

Figure 2

Figure 3

b)  Consider the database shown in Figures 1(a) and  1(b), design a query that finds the total monetary amount (including only products with price > 2.5) of all order(s) made in February of 2022. The query should display the result (Figure 4) in descending order of the Total Payment of the orders. Depict the design of your query in Figure 5. (10 marks)

Figure 4

Figure 5

Question 10 (10 marks)

Consider the following incomplete Microsoft Excel worksheet that models an Income and Cash Flow Statement for a company, the worksheet has the known components:

•   C2: It is the tax rate of Type A companies

•   C3: It is the tax rate of Type B companies

•   C4: It is the tax rate of Type C companies

•   C5: It contains the Maximum Tax Refund.

•   C8: It is the type of the company. The value can be either “A”, “B”, or “C” .

•   B9: It is the Tax Exemption of Year 2021.

•   C11: The Minimum Cash on Hand.

•   C14: It contains a formula to find the Beginning-of-year Cash on Hand

•   C15: It contains the Sales of this year.

•   C16: It contains the Cost of Goods Sold

•   C18: It contains the formula to find Income before Taxes

•   C19: It contains the formula to find the Income Tax Expense before Tax Refund. If the Income before Taxes is smaller than or equal to the Tax Exemption, it is zero. Otherwise it depends on the Tax Rate and the Income before Taxes.

•   C21: It contains the formula to find Net Income after Taxes

•   C22: It contains the formula to find NCP.

•   C25: It contains the formula to find End-of-year Cash on Hand

•   C28: It contains the Beginning-of-year debt owed.

Complete the above worksheet by entering formulae in the spaces provided below.

1. C9: It is the Tax Exemption of Year 2022. It depends on the type of the company and the Tax Exemption of Year 2021. If the type is “A”, the Tax Exemption is increased by 25%. If the type is “B”, the Tax Exemption is increased by  15%,  otherwise  it  is increased by 5%.     (2 marks)

2. C10: It is the Tax Rate of Year 2022. It depends on the type of the company and the corresponding Tax Rates in C2, C3, and C4.      (1 mark)

3. C20:  It  finds  the  Income  Tax  Expense  after  Tax  Refund. Tax Refund is only applicable if the type of the company is “A” or “C” . If the Income Tax Expense before Tax Refund is smaller than or equal to the Maximum Tax Refund, it is zero. Otherwise it is the difference between the Income Tax Expense before Tax Refund and the Maximum Tax Refund.             (2 marks)

4. C23: It contains the formula to find the Line of Credit Borrowing from bank – Amount borrowed from bank to maintain minimum cash required (if needed). (2 marks)

5. C24: It is Line of Credit Repayment to bank – Amount of debt repaid to bank out of excess cash (above the required Minimum Cash on Hand).                              (3 marks)