代写BUS2206 INFORMATION SYSTEMS MANAGEMENT SECOND TERM EXAMINATION 2022-23代写Java编程

SECOND TERM EXAMINATION 2022-23

BUS2206 INFORMATION SYSTEMS MANAGEMENT

TIME ALLOWED: 2 HOURS

INSTRUCTIONS

•   This examination paper contains 10 questions. Attempt all questions in this paper.

•   Full marks are 100.

•   Write the answers to the long questions in the  space provided in this examination paper.

•   Answers must be given in English.

•   Calculators can be used.

•   You are reminded of the necessity for clear and orderly presentation in your answers.

•   Return this question paper at the end of the examination.

Question 1 (10 marks)

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)

The Internet and e-commerce technologies are much more powerful than previous technologies, such as radio, television, and the line phone. To explain why e-commerce is so different from  previous  technologies, name FIVE unique features of the e-commerce  technologies  and  provide a brief description of each unique feature.                                                     (10 marks)

Question 9 (15 marks)

a)   Consider the database shown in Figures 1(a) and 1(b), what is the output of executing the query in Figure 2. Depict the output of the query in Figure 3.                            (5 marks)

Figure 1(a)

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)

C9	Tax Exemption
C10	Tax Rate
C20	Income Tax Expense after Tax Refund
C23	Line of credit borrowing from bank
C24	Line of credit repayments to bank