ISYS 2263 Test 2

Observational

(also known as non experimental) make no attempt to control the variables of interest. A survey is the most common type. Another example would be that some restaurants use this type of study to obtain data about customer opinions on the quality of food

Advantages of DBMS

-better data integration and less data inconsistency -increased end-user productivity -improved: data sharing, data security, data access, decision making

Role of the DBMS

-serves as the intermediary between the user and the database -enables data to be shared -presents the end user with an integrated view of the data -received and translates application requests into operations required to fulfill the requests -hides database's internal complexity from the application programs and users

Which phase of the system design life cycle includes determining the system requirements and analyzing the information needs of employees?

Analysis

Which of the following questions reflect the strategic goals of project portfolio management?

Are we investing in the right areas?

Data Sources

Can be obtained from existing sources or from surveys and experimental studies designed to collected new data

What are the raw material that an information system transforms to useful information?

Data

computerized file systems

Data processing (DP) specialist was hired to create a computer- based system that would track data and produce required reports

Categorical Data

Data that can be grouped by specific categories

Quantitative

Data that uses numeric values to indicate how much or how many

Determining whether expected cost savings, increased profits and other benefits exceed the cost of developing and operating a system is related to ___________ feasibility.

Economic

Which phase of the system design life cycle includes creating and converting to the new system?

Implementation

What is a schematic display of the logical relationships among project activities?

Network Diagram

Data Warehousing

Organizations obtain large amounts of data on a daily basis by means of magnetic card readers, bar code scanners, point of sale terminals, and touch screen monitors

The role of a ______ is to provide direction and funding for a project.

Project Sponsor

Which of the following is a difference between project management and portfolio management?

Project management focuses on tactical goals whereas portfolio management focuses on strategic goals

Galaxy, a construction company, buys a particular brand of tiles manufactured by Tiles and Floor, and eco- friendly tile manufacturing company. However, Tiles and Floors has declared bankruptcy and closed down. At present, Galaxy is facing a crisis because there are no other manufacturers in the market that supplies eco- friendly tiles. Which of the following constraints is Galaxy currently fixing?

Resources

Which constraint involves defining and managing all the work required to complete the project successfully

Scope

Which category of feasibility study focuses on determining if reliable hardware and software, capable of meeting the needs of a proposed system, can be acquired or developed in the required time?

Technical

Which of the following is true of program managers?

They provide leadership and direction for prefect managers heading the projects within a program

Data Acquisition Consideration

Time Requirement, Cost of Acquisition, Data Error

Field

a character or group of characters alphabetic or numeric that has a specific meaning

distributed database

a database that supports data distributed across several different sites

Experimental

a variable of interest is first identified, then one or more other variables are identified and controlled so that data can be obtained about how they influence the variables of interest

______ are important because they help to ensure data integrity. a) Constraints b) Attributes c) Relationships d) Entities

a) Constraints

ERP is an acronym for a) Enterprise Resource Planning b) Enterprise Requirements Projects c) Excellent Requirements Planning d) Everyone Resource Projects

a) Enterprise Resource Planning

A sequence of tasks or activities that takes a set of inputs and converts them into desired outputs is called: a) a business process b) globalization c) an ERP system d) income statement

a) a business process

The ______ model was developed to allow designers to use a graphical tool to examine structures rather than descending them with text. a) entity relationship b) hierarchical c) network d) object-oriented

a) entity relationship

A _________ is a collection of related records. a) file b) column c) database d) field

a) file

One of the limitations of the ___ model is that there is a lack of standards. a) hierarchical b) network c) relational d) entity relationship

a) hierarchical

A(n) ________ is bidirectional. a)relationship b)entity c)attribute d)constraint

a)relationship

Manual file systems

accomplished through a system of file folders and filing cabinets

Applications in Business and Economics

accounting, finance, marketing, production, economics, and information systems

database design

activities that focus on the design of the database structure that will be used to store and manage end-user data

Data Set

all the data collected in a particular study

In the simulation, which of the following is an allowable product size? a) 250 grams (250g) b) 1 liter (1L) c) 12 ounces (12oz) d) 1 pound (5lb)

b) 1 liter (1L)

Which of the following pattern match selection criteria would return zip codes with the characters 704 in the first three spaces. a) llf(704*) b) Like "704*" c) Like *704* d) find "704*"

b) Like "704*"

________ data are the result of formatting to facilitate storage, use, and generation of information. a) unstructured b) Structured c) Historical d) Semistructured

b) Structured

A(n) _______ model represents a global view of the database as viewed by the entire organization. a) Internal b) conceptual c) external d) physical

b) conceptual

Which of the following is an example of master data? Data about: a) Sales Organizations b) customers c) purchase orders d) company codes

b) customers

The ______ model is the end users' view of the data environment. a) conceptual b) external c) internal d) abstract

b) external

Dates, times, and locations are examples of transaction data in an ES. a) true b) false

b) false

In the simulation, which of the following is not an allowable product? a) carbonated water b) strawberry flavored water c) lemon flavored d) natural water

b) strawberry flavored water

SRM systems link a company with its suppliers. a)False b)true

b) true

_______ is the body of information and facts about a specific subject. a)Data b)Knowledge c)Information d)a database

b)Knowledge

The phrase _____ refers to an organization of components that define and regulate the collection, storage, management and use of database environment. a) management system b)database system c)database management d)database management system

b)database system

A noun in a business rule translates to a(n) _____ in the data model. a)constraint b)entity c)relationship d)attribute

b)entity

The number of occurrences of an expression is determined using the ____ function in a form or report. a) SUM b) AVERAGE c) COUNT d) MAX

c) COUNT

A section that appears once at the beginning of a report and is used for report titles and company logos, among other elements, is the ______ section in Design view. a) Page Header section b) Group Header section c) Report Header section d) Detail section

c) Report Header section

Accurate, relevant, and timely information is the key to ______. a) understanding b) data management c) good decision making d) knowledge

c) good decision making

A workgroup database is a(n) _______ database. a) distributed b) enterprise c) multiuser d) single- user

c) multiuser

The standard naming convention prefix tag for a query used to identify the object type is _____. a) Query b) QURY c) qry d) DRY#

c) qry

A verb associating two nouns in a business rule translates to a (n) _______ in the data model. a) constraint b) attribute c) relationship

c) relationship

business intelligence

captures and processes business data to generate information that support decision making

Variable

characteristic of interest for the element

General-purpose database

contains a wide variety of data used in multiple disciplines

Discipline-specific databases

contains data focused on specific subject areas

Cloud database

created and maintained using cloud data services that provide defined performance measures for the database

To avoid typing errors when creating more advanced expression for a calculated control, it's a good idea to use the Access feature. a) Property Sheet b) Controls group on the ribbon c) From view d) Expression Builder

d) Expression Builder

The ______ comparison operator is used to select records by matching field values to a pattern that includes one or more wildcard characters. a) Between b) More c) In d) Like

d) Like

______ relates to the activities that make the database perform more efficiently in terms of storage and access speed. a) Database management b) Query access c) Database design d) Performance turning

d) Performance tuning

Which of the following is true of business rules? a) They allow the designer to develop processes b) They allow the designer to set company policies with regard to data c) They provide a framework for the company's self actualization d) They can serve as a communication tool between the users and designers

d) They can serve as a communication tool between the users and designers

A(n) _______ might be written by a programmer or it might be created through a DBMS utility program. a) query b) database management system c) operating system d) application program

d) application program

The database structure in a DBMD is stored as a ____. a) file b) collection of queries c) set of key/ value pairs d) collection of files

d) collection of files

In the _______ model, the user perceives the database as a collection of records in 1:M relationships, where each record can have more than one parent. a) object- oriented b) hierarchical c) entity relationship d) network

d) network

A criterion may be negated by using the _____ logical operator. a) And b) Or c) like d) not

d) not

End-user data is _____. a) raw facts about the end user b) accurate, relevant and timely information c) data about data d) raw facts of interest to the end user

d) raw facts of interest to the end user

Which of the following is an example of organizational data? Data about: a)customers b)vendors c)material d)sales organizations

d)sales organizations

Cross-sectional data

data collected at the same time or approximately the same point in time

Time Series Data

data collected over several time periods

unstructured data

data that exist in their original (raw) state- in other words, the format in which they were collected

centralized database

database that supports data located at a single site

Operational database

designed to support a company's day-today operations

Online analytical processing

enable retrieving, processing, and modeling data from the data warehouse

Elements

entities on which data are collected

Which of the following refers to a set of principles that guides decision making based on personal values of what is considered right and wrong?

ethics

Data

facts and figures collected, analyzed, and summarized for presentation and interpretation

Ordinal

if the data exhibit the properties of nominal data and in addition the order or rank of the data is meaningful

Ratio

if the data has all the properties of interval data and the ratio of two values is meaningful

Interval

if the data have all of the properties of ordinal data and the interval between values is expressed in terms of a fixed unit of measure

File system redux: modern end user

includes spreadsheet programs such as Microsoft excel

database management system (DBMS)

is a collection of programs that manages the database structure and controls access to the data stored in the database. For example, it resembles a ver well-organized electronic filing cabinet in which powerful software helps manage the other cabinets content

Statistics

numerical facts such as averages, medians, percentages, and maximums that help us understand a variety of business and economic situations

Semi-structured data

processed to some extent

Sample

smaller group of elements in a particular study; subset of the population

Analytical database

stores historical data and business metrics used exclusively for tactical or strategic decision making

multi user database

supports multiple users at the same time

Single user Database

supports only one user at a time

Population

the larger group of elements in a particular study; set of all elements of interest in a particular study

Median

the number in the middle. If its uneven, add the two in the middle and divide by two

Mode

the number that is most common

sample survey

the process of conducting a survey to collect data for a sample

census

the process of conducting a survey to collect data for the entire population

Data Mining

the process of using procedures from statistics and computer science to extract useful information from extremely large databases

Structured data

the result of formatting unstructured data to facilitate storage, use, and the generation of information

Information

the result of processing raw data to reveal its meaning

Observation

the set of measurements obtained for a particular element

Mean

this is the most common. It is the average

Nominal

when the data for a variable consist of labels or names used to identify an attribute of the element

What is a document that provides the basis for planning and managing project schedules, cost, resources, and changes?

work breakdown structure