Mgts1201 Mid-Sem

Front 1

KoganTechnologies has pursued which type of unmatched competitive advantage?:

Back 1

Offeringproducts at world’s best price.

Front 2

Giventhat The Nook is a bar with a small food menu, what type of data do you thinkthis establishment should collect from a single transaction?:

Back 2

Amount spent by customer, what food and drinkpeople buy, what day and time people buy food and drink.

Front 3

SystemsThinking is best described as the ability to:

Back 3

identify and understand the inputs, outputs andlinkages of processes.

Front 4

EnterpriseResource Planning systems are best described as:

Back 4

Tightlyintegrate functional area IS via a common database, enchance communicationsamong the functional areas of an organisation. Greatly increase organisationalproductivity.

Front 5

ModernTransaction Processing Systems are designed to:

Back 5

collect data in real time, process the everyday, ‘mission-critical’transactions of an enterprise, function primarily within a single organisation.

Front 6

Administration/management, finance managementand procurement are support activites.

Back 6

PrimaryActivities:- Examples: Inbound logistics, operations, outbound logistics, marketingand sales and services.

SupportActivities: - Examples: Infrastructure (Accounting, Finance, Management), humanresources management, research and development, procurement.

Front 7

Porter’sFive Forces/Competitive Forces model describe how the bargaining power ofcustomers is:

Back 7

directly increased by greater buying choice forcustomers.

Front 8

Porter's Five Forces are:

Back 8

Supplier bargaining power, Threat of new entrants, Buyer bargaining power, threat of substitutes, threat of rival organisations.

Front 9

Whichof Porter’s Forces is more powerful for the nook?:

Back 9

The bargainingpower of customers.

Front 10

In the ‘Loyalty New Zealand’ case study, thetype of software used is:

Back 10

SAS

Front 11

TheDatabase management system is characterised best as:

Back 11

software that exclusively manages the stored dataand may be accessed by humans or other software applications.

Front 12

Within the context ofnormalization as required for relational database design, explain the two-stepprocedure that we should follow to commence the normalization of a database design:

Back 12

1st step Answer: We break up the single large table bylooking for the central themes in it – each of these will become a smallertable

2nd step Answer: We look to join the smaller tables so thatthey can be used to answer queries – we do this by the addition of FOREIGN KEYS

Front 13

The overall databasedesign process comprises two stages: the logical design and the physicaldesign. The logical design is performed by the business analyst. What are thetwo stages performed by the business analyst during the logical design of thedatabase?

Back 13

1st stage: Create the data model, that is, construct the ERDwith entities and relationships 2nd stage: Facilitate the joins between the entities via theaddition of primary and foreign keys

Front 14

Define the termrelational database. Explain the simple, single design principle by which the(possibly) multiple tables of a relational database can be used jointly toanswer all possible questions put to the database:

Back 14

Define Relational Database: Data represented as one or moretwo-dimensional tables with columns and rows. **These can be used to recognize therelationship between different strings of data**

Define Singe Design Principle: Forming relationships via theintroduction of foreign keys into the tables of the database.

Front 15

The BusinessIntelligence Dashboards represented in the above graphic routinely provide whattype/category of information to which group of users within the enterprise?:

Back 15

What type/category of information?: High level or highlyabstracted data or performance trend data or performance summary data.Which group of users?: Business analysts or businessmanagers or business executives.

Front 16

How would the levelof complexity and level of importance of the work done by the TransactionProcessing Systems (TPS) be best described?

Back 16

Level of complexity: Simple processing logic. Level of importance: ‘Mission Critical’

Front 17

The BusinessIntelligence Dashboards are shown in the graphic as separated from theTransaction Processing Systems (TPS). What is the reason for this separation?Why is this necessary in terms of the role played by the TPS?

Back 17

Reason for Seperation: The two systems are not directlyintegrated/joined.Why is it necessary? The TPS performs mission criticalprocessing 24/7/ Processing interruptions must be minimized.

Front 18

The KoganTechnologies opening case study (chapter 1) describes the spectacular successof an Australian business. Name one business intelligence software facitityused by Kogan Technologies? Kogan Technologies has pursued which of Porterscompetitive strategy goals? List two forms of digital marketing that issuccessfully used by Kogan Technologies.

Back 18

One business intelligence software facility: Google AdWords.

Which of Porter’s competitive strategy goals? Cost/Priceleadership across a broad geographic area.

1st form of digital marketing: Viral Marketing.2nd form of digital marketing: Email marketing./html>vȻ