回到网站

The University of Queensland BISM1201 Final Examination 2020

BISM1201 Semester Two Final Examination 2020

· 案例展示
QUESTION 1 The Entity Relationship Diagram below shows the logical design of a database for books and authors

Based on the Entity Relationship Diagram answer the following questions:

1a. How many Entities are there?

1b. In the current structure which table requires a Composite Primary Key/Foreign Key?

1c. A Genre can have a maximum of how many Books?

1d. Which table is a Linking Entity?

1e. Where is a Linking Entity needed?

1f. A Book can have a maximum of how many Genres

QUESTION 2 The database table structure below captures Student details and the membership to a Running Club. It shows a ‘Student table’ and a ‘Running club table’. A student can only be a member of one running club, but a running club can have many student members. What is the most appropriate Foreign Key and where should we place the Foreign Key in this table structure so that we can link the two tables?(30 words maximum)
Add paragraph text here.
QUESTION 4
  1. The Customer table below includes details of customers including their names and email addresses and phone numbers.

    (a) What is the problem with the table design below (50 words maximum); and,

    (b) What is the most appropriate way to resolve the problem with the table design below? (50 words maximum)

Cust_id (PK)

First_name

Last_name

Email1

Email2

Phone1

Phone2

002

Marcos

Pa

m.pa@gmail.com

macros@yahoo.com

07798989

07789876

003

Michio

Inaros

-

-

-

-

004

Lucy

Xi

lucy.xi@hotmail.com

-

09765432

-

005

Phillip

Chao

chao@outlook.com

chao@gmail.com

-

-

006

Billy

Cavani

-

-

09876431

09765431

QUESTION 5
  1. Business intelligence (BI) is an important benefit of databases and part of modern businesses. How does BI add value to a business?

    (100 words maximum)

QUESTION 6
  1. Select one of the following Business intelligence (BI) approaches, briefly describe it and give an example to demonstrate how it delivers BI.

    A. OLAP Cube,

    B. Recency Frequency Monetary analysis,

    C. Market Basket analysis, or

    D. Decision Tree

    (100 words maximum)

QUESTION 7
  1. Explain the difference between a Recency, Frequency, Monetary (RFM) analysis and a Market Basket analysis.

    (100 words maximum)

QUESTION 8
  1. A Brisbane based firm called Sport-Cycles manufactures and sells premium bikes through its website and 40 outlets. It only collects basic information about its customers. The information it does collect is stored in a basic Microsoft Access database but this is not used to generate value for the firm, it is only a store of customer information that is updated manually.

    At the moment its 40 outlets provide inconsistent customer data to the company. For instance, some outlets provide customer feedback data, some provide full details of all customer touchpoints and some provide no data. Likewise, Sport-Cycles capture few details about its customers via online sales.

    Business is thriving and there are many repeat and new customers but also significant customer churn. The owner is finding it difficult to keep track of high value customers, the problems customers face, manage customer relationships, etc. Some customers have complained about the poor quality service they receive when dealing with the firm via email or telephone. At the same time customers are demanding a very personalised service. Because of these issues the firm is concerned that customer retention is not as high as it could be, and there is an impact on operating costs. In addition, because of the growth of customers the firm would like to know more about patterns in customer behaviour and purchases and use this to inform decision making.

    Using this example, how would you explain to the owner of the business the benefits of a CRM system to address these business issues?

    (300 words maximum)

QUESTION 9
  1. Match the type of information system with the appropriate statement (use the drop down box to select either A, B, C or D for each type of information system).

         -           A.           B.           C.           D.      

Supply chain management system

         -           A.           B.           C.           D.      

Enterprise resource planning system

         -           A.           B.           C.           D.      

Customer relationship management system

         -           A.           B.           C.           D.      

Transaction Processing System

A.

Is used to understand and anticipate the needs of current and potential customers to increase customer retention and loyalty.

B.

Supports business operations and processes by integrating processes and activities throughout a business.

C.

Used to help a range of different ‘upstream’ and ‘downstream’ firms so that they can source, produce, and deliver goods and services efficiently.

D.

An example is a point-of-sale system for a large retailer.

QUESTION 10
  1. In the image below, we have a list of employees in rows 1-5 and a Job Salary Table in cells A8-C13

    In F2-F5 the salary for each employee is derived from the Job Salary Table using the VLOOKUP function.

    Replicate the formula used in the cell F2 using VLOOKUP, CONCATENANTE/CONCAT, LEFT, RIGHT. That is, produce the formula used to produce the salary value in F2 (this will be copied down to cells F3-F5).

    You need to join the left three characters from C2, the last character from D2 (e.g. for Hillary it is “ConA”) and use this in your lookup. For instance, Hillary is a Consultant Level A (“ConA”), and therefore her salary is $90,000.

    Write the formula in the text box.

QUESTION 11
  1. Consider the following image and scenario.

    You are involved in an election. You need 70% of votes to win the election. The population of voters is 980. You want to determine how many ‘yes’ votes you need to win the election. Use Goal Seek to determine the number of ‘yes’ votes you need.

QUESTION 12
  1. Consider the following image and scenario.

    A tyre manufacturer needs to make a monthly delivery of its tyres.

    It would like to determine the right mix of tyres to load onto its truck in order to maximise its profit. It must transport 100 tyres (the total capacity of the truck). The following conditions must be fulfilled when loading the truck.

    1. A minimum of 40 ‘Roadster Tyres’ must be loaded because a specific order has been made for them.
    2. A special order for 2 ‘Show Tyres’ has been made. ‘Show Tyres’ are only delivered when a special order is made. In other words, we do not need to deliver more than 2.
    3. Because it is the dry season there is no demand for ‘Wet Tyres’, so no ‘Wet Tyres’ are to be loaded.
    4. For the remainder of the tyres the minimum that must be loaded is 10.

An image for the Solver Parameters is shown below with the necessary four parts for completion A, B, C, and D. What values should we enter in the fields A, B, C, D as highlighted in the figure below?

For your answer, you must write the details of what you would enter into these four parts of the solver window.

You must ensure that you make clear what data goes into what part of the Solver Parameter window (for example “A contains $D$6” or “D contains $D$6 >=5” etc.).

A, B and C are worth 1 mark each, D is worth 3 marks.

所有文章
×

快要完成了!

我们刚刚发给你了一封邮件。 请点击邮件中的链接确认你的订阅。

好的