CIS 464 Midterm

Data modeling may be the most important part of the systems development process because: A.data are less stable than processes. B.data characteristics are important in the design of programs and other systems components. C.the data in a system are generally less complex than processes and play a central role in development. D.it is the easiest.

B.data characteristics are important in the design of programs and other systems components.

Business policies and rules govern all of the following EXCEPT: A.creating data. B.managing employees. C.removing data. D.updating data.

B.managing employees.

A well structured database establishes the entities between relationships in order to derive the desired information T or F

False

An enterprise data model describes the scope of data for only one information system T or F

False

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process. T or F

False

Data redundancy is used to establish relationships between data but is never used to improve database performance T or F

False

Database development begins with the design of the database T or F

False

Database development projects are never done in a bottom up fashion T or F

False

Repositories are always used in file processing systems T or F

False

Systems analysts work directly with both management and users to analyze the business situation and develop detailed project specifications. T or F

False

The data that you are interested in capturing about an entity is called an instance T or F

False

The physical structure and storage organization of the database is decided upon during the implementation phase of the systems development life cycle T or F

False

The relational data model is no longer popular in the 21st century. T or F

False

The steps of the systems development life cycle can only be viewed as a linear process T or F

False

With the traditional file processing approach, each application shares data files, thus enabling much data sharing T or F

False

the term legacy system refers to a newly installed database management system T or F

False

Data from prior systems is converted to the new systems during the implementation phase of the systems development life cycle T or F

True

Data management technologies are also increasing often used as information systems, as a foundation for analytics or the systematic analysis of data to understand a real world problem better T or F

True

Database maintenance is typically the longest step of the database development process T or F

True

Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program T or F

True

E. F. Codd developed the relational data model during the 1970s. T or F

True

File processing systems have been replaced by database systems in most critical business applications today T or F

True

In prototyping, implementation and maintenance activities are repeated as necessary until the product is correct. T or F

True

Information is processed data T or F

True

Many of the disadvantages of file processing systems can also be limitations of databases T or F

True

Metadata are data that describe the properties of other data T or F

True

One reason for improved application development productivity with the database approach is that file design and low level implementation details do not need to be handled by the application programmer T or F

True

Prototyping is a type of rapid application development. T or F

True

Redundancy increases the risk of inconsistent data T or F

True

Separation of metadata form application programs that use the data is called data independence T or F

True

The data repository assists database administrators in enforcing standards. T or F

True

The failure to implement a strong database administrative function is the most common source of database failures in organizations T or F

True

The most common way to support a group of individuals who work together on a project or group of similar projects is with a multi-tier client/server database. T or F

True

The systems development life cycle is the traditional methodology used to develop, maintain and replace information systems T or F

True

The user interface includes languages, menus, and other facilities by which users interact with various system components T or F

True

Unplanned duplicate data files are the rule rather than the exception in file processing systems T or F

True

The need for consensus on data definitions is an example of which type of risk in the database environment? a. Organizational conflict b. Specialized personnel needs c. Legacy systems d. Conversions costs

a. Organizational conflict

Which of the following is NOT an objective that drove the development and evolution of database technology? a. the desire to require programmers to write all file handling functionality b. the desire to manage increasing complex data types and structures c. the need to provide greater independence between programs and data d. the need to provide ever more powerful platforms for decision support applications

a. The desire to require programmers to write all file handling functionality

A graphical system used to capture the nature and relationships among data is called a(n): a. data model b. relational database c. hypertext graphic d. XML data model

a. data model

________ do NOT concentrate on determining the requirements for the database component of an information system a. end users b. database analysts c. systems analysts d. programmers

a. end users

Database development begins with ________, which establishes the range and general contents of organizational databases. a. enterprises data modeling b. database design c. cross functional analysis d. departmental data modeling

a. enterprise data modeling

Which of the following is NOT a cost and/or risk of the database approach? a. improved responsiveness b. Organizational conflict c. Cost of conversion d. Specialized personnel

a. improved responsiveness

All of the following are primary purposes of a database management system (DBMS) EXCEPT: A. providing an integrated development environment b. storing data c. updating data d. creating data

a. providing an integrated development environment b. storing data c. updating data d. creating data

which of the following is NOT an advantage of database systems? a. redundant data b. Reduced program maintenance c. better data quality d. program data independce

a. redundant data

A knowledge base of information or facts about an enterprise is called a: a. repository b. database process c. enterprise information system d. systems information unit

a. repository

With the database approach, data descriptions are stored in a central location known as a: a. repository b. mainframe c. server d. PC

a. repository

The traditional methodology used to develop, maintain, and replace information systems is called the: a. systems development life cycle b. enterprise resource model c. systems development life cycle d. unified model

a. systems development life cycle

A major difference between data warehouses and transactional systems as compared to big data is a. the data is unstructured in big data systems b. the size of the CPU used c. the programming required to access data d. All of these

a. the data is unstructured in big data systems

Which of the following is software used to create, maintain, and provide controlled access to database? a. Attribute b. Database management system c. Network operating system d. User view

b. Database management system

An iterative methodology that rapidly repeats the analysis, design, and implementation phases of the SDLC is called: a. MST b. RAD c. CAD d. CASE

b. RAD

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): a. object b. entity c. attribute d. relationship

b. entity

The most common source of database failures in organizations is: a. lack of planning b. failure to implement a strong database administration function c. inadequate hardware d. inadequate budget

b. failure to implement a strong database administration function

Data that describes the properties of other data are: a. physical b. metadata c. relationships d. logical

b. metadata

________ is a tool even non programmers can use to access information from a database a. Data manipulation query language b. ASP c. Structured query language d. ODBC

c. structured query language (SQL)

Languages, menus, and other facilities by which users interact with the database are collectively called a: a. development environement b. client c. user interface d. icon

c. user interface

A data warehouse derives its data from a. a data mart b. reports c. various operation data sources d. on-line transactions

c. various operational data sources

A user view is: a. a procedure stored on the server b. a table or set of tables c. what a user sees when he or she looks out the window d. a logical description of some portion of the database

d. a logical description of some portion of the database

Database management involves all of the following EXCEPT: a. organizing data b. collecting data c. managing data d. design web pages

d. design web pages

The SDLC phase in which database processing programs are created is the ________ phase. a. planning b. design c. analysis d. implementation

d. implementation

Metadata typically describes all of the following EXCEPT: a. allowable values b. data definitions c. length d. location on disk

d. location on disk

A database is an organized collection of ________ related data a. loosely b. physically c. badly d. logically

d. logically

Legacy systems often contain data of ________ quality and are generally hosted on ________ a. excellent; workgroup computers b. poor; personal computers c. excellent; mainframes d. poor; mainframes

d. poor; mainframes

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a: a. index b. data warehouse c. database management system d. repository

d. repository

________ specify computer systems requirements a. users b. database analysts c. programmers d. systems analysts

d. systems analysts

Because applications are often developed independently in file processing systems: A. unplanned duplicate data files are the rule rather than the exception. B. the data is always non-redundant. C. data can always be shared with others. D. there is a large volume of file I/O.

A. unplanned duplicate data files are the rule rather than the exception.

The logical representation of an organization's data is called a(n): A.entity-relationship model. B.database model. C.database entity diagram. D.relationship systems design.

A.entity-relationship model.

A fact is an association between two or more: A.nuggets. B.terms. C.words. D.facts.

B. Terms

A ________ defines or constrains some aspect of the business. A.business constraint B.business rule C.business control D.business structure

B.business rule

In an E-R diagram, there are/is ________ business rule(s) for every relationship. A.zero B.two C.one D.three

B.two

Which of the following is NOT a characteristic of a good business rule? A.Atomic B.Expressible C.Inconsistent D.Declarative

C.Inconsistent

Program-data dependence is caused by: A. data descriptions being stored on a server. B. data descriptions being written into programming code. C. data cohabiting with programs. D. file descriptions being stored in each database application.

D. file descriptions being stored in each database application.

The most common types of entities are: A.associative entities. B.smush entities. C.weak entities. D.strong entities.

D.strong entities.

A constraint is a rule in a database system that can be violated by users T or F

False

A user view is how the user sees the data when it is produced T or F

False

Database processing programs are coded and tested during the design stage of the systems development life cycle T or F

False

Databases were developed as the first application of computers to data processing T or F

False

Organizational commitment to a database project is not necessary for its success T or F

False

Organizations that utilize the file processing approach spend only 20% of development time on maintenance T of F

False

Personal databases are designed to support a small group of individuals working together on a project T or F

False

Reduced program maintenance is an advantage of file processing systems T or F

False

A data model is a graphical system used to capture the nature and relationships among data T or F

True

A data warehouse contains summarized and historical information. T or F

True

A modern database management system automates more of the backup and recovery tasks than a file system T or F

True

A person is an example of an entity T or F

True

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory. T or F

True

A relational database establishes the relationships between entities by means of a common field T or F

True

An enterprise resource planning system integrates all functions of the enterprise T or F

True

Cost and complexity are just two of the disadvantages of database processing T or F

True

Database architects establish standards for data in business units. True or False

True

Multi-tier client/server database applications contain a business logic layer. T or F

True

According to a McKinsey Global Institute Report, in 2010 alone, global enterprises stored more than: a. at least 100 petabytes of data b. more than 7 billion exabytes of data c. 3 gigabytes of data d. 1 terabyte of data

b. more than 7 billion exabytes of data

A departmental multi-tiered client/server database is stored on a central device called a: a. client b. server c. network d. remote pc

b. server

Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance. a. 40% b. 60% c. 80% d. 25%

c. 80%

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase. a. planning b. design c. analysis d. implementation

c. analysis

The SDLC phase in which the detailed conceptual data model is created is the ________ phase a. planning b. design c. anlaysis d. implementation

c. analysis

In a file processing environment, descriptions for data and the logic for accessing the data are built into: a. records b. database descriptors c. application programs d. fields

c. application programs

A rule that cannot be violated by database users is called a : a. password b. program c. constraint d. view

c. constraint

Specifying how data from a logical schema are stored in secondary memory is part of the: A) design B) maintenance C) analysis D) implementation

c. design

One of the most popular RAD methods is: a. crafting b. automated design c. prototyping d. structured walkthrough

c. prototyping

________ are established between entities in a well-structured database so that the desired information can be retrieved. a. lines b. entities c. relationships d. ties

c. relationships