Database Final Exam study guide

The period that can be considered a proof of concept time was the

1960

E.F. Codd developed the relational model in the

1970

Organizations that utilize the file processing approach spend as much as ____ of their IS development budget on maintenance

80%

_____ concentrate on determining the requirements for the database component of an information system

Database analyst

An iterative methodology that rapidly repeats the analyisis design and implemntaiton phases of the SDLC is called

RAD

___ is a tool even non programers can use to access information from a database

Structured query language

A user is

a logical description of some portion of the database

The SDLC phase in which the detailed conceptual data model is created is the _____ phase

analysis

The SDLC phrase in which every data attribute is defined every category of data is listed and every bussiness relationship between data entries is defined is called the _____ phase

analysis

In a file processing enviornment descrptions for data and the logic for accessing the data are built into

application programs

CASE is a class of tools that

automates the design of databases and application programs

a rule that cannot be violated by database users is called

constraint

A graphical system used to capture the nature and relationships among data is

data model

which of the following is anintegrated decision support database with content derived from various operational databases

data warehouse

which of the ofllowing is software used to create maintain and provide controlled access to a database

database management system

One application of data warehouse is

decision support

organizing the database in computer disk storage is done in the ____ phase

design

Database development begins with _____ which establishes the range and general contents of organizational datbases

enterprise data modeling

A person place an object an event or concept about which the organization wishes to maintain data is called

entity

the most common source of database failures in organization is

failure to implement a strong database administration function

A user view is how the user sees the data when it is produced

false

Characteristics of the structure of the database are generally changed during the implementation phase of the database development process

false

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

false

a constraint is a rule in a database system tthat can be violated by users

false

a well structured database establishes the entities between relationships in order to derive the desired information

false

all projects move from the planning conceptural data modeling step of the systems development life cycle

false

an enterprise data model describes the scope of data for only one information system

false

data redundancy is used to establish relationships between data but is never used to improve database performance

false

database development begins with the design of the database

false

database development projects are never done in a bottom up fashion

false

database procesing programs are coded and tested during the design stage of the systems development life cycle

false

databases were developed as the first application of computers to do data processing

false

organizations that utilize the file processing approach spend only 20 percent of development time on maintenance

false

organizzational commitment to a databse project is not necessary for its success

false

personal databases are designed to support a small group of individuals working together on a project

false

reduced program maintenance is an advantage of file processing systems

false

repositories are always used in file processing systems

false

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

false

the steps of the system development life cycle can only be viewed as a lintear process

false

the term legacy system refers to newly installed database management system

false

visual programming tools such as visual basics have made prototyping more difficult

false

with the traditional file processing approach each application shares data files thus enabling much data sharing

false

program data dependence is caused by

file descriptors being stored in each application

The SDLC phas in which database processing programs are created is the ____ phase

implementation

which of the following is not a cost and risk of the database approach A) specialized personnel B) cost of conversion C) improved responsiveness D) organizational conflict

improved responsiveness

Data processed in a way that increases a users knowledge is

information

The three schema approach includes which of the following schemas

internal

Older systems that often contain data of poor quality are called _________ systems

legacy

one disadvantage of file processing system is

limited data sharing

A database that is an organized collection _____ related data

logically

Data that describe the properties of other data are A) relationships B) logical C)physical D) none of the above

none of the above

which organizational function should set database standards A) management B) Application development C) technical services D) none of the above

none of the above

the need for consensus of data definitions is an example of which type of risk in the database environment

organizational conflict

All of the following are properties of metadata except A) data definitions B) processing logic C) rules or contraints D) Data structures

processing logic

One of the most popular RAD methods is

prototyping

All of the follwoing are primary purposes of database management system except

providing an integrated development environment

Which of the following is not an advantage of a database system

redundant data

Relational databases establish the relationships between entities by means of common fields included in a file called

relation

______ are established between entities in a well structured database so that the desired information can be retrieved

relationships

A knowledge base of information on fact about an enterprise is called

repository

With the database approach, data description are stored in a central location known as

repository

a contralized knowledge base of all data definitions, data relationships, screen and report formats and other systems components

repository

A workgroup database is stored on a central device called

server

______ analyze the business situation and identif the need for information and information services to meet the problems or opportunities of the business

system analyst

The traditional methodology used to develop maintian and replace information systesm is called the

systems development life cylce

not an objective that drove the development and evolution of database technology

the desire to require programmers to write all file handling functionality

databases may be more expensive to maintain than files because of

the need for specialized personnel the complexity of the database environment backup and reovery needs

a data model is a grpahical system used to capture the nature and relationships among data

true

a modern daetabase management system automates more of the backup and recovery tasks than a file system

true

a person is an example of an entity

true

a relational database establishes the relationships between entities by means of a common field

true

cost and complexity are just two of the disadvantages of database processing

true

data from prior systems is converted to the new system during the implemnetation phase of the systems development life cycle

true

database maintenance is typically the longest step of the database development process

true

development starts from scratch with the traditional file processing approach because new file format descriptions and file access logic must be designed for each new program

true

end users can often retrieve and display data easily with a relational database

true

enterprise modeling sets the range and general contents of organizational databases

true

file processing systems have been replaced by database systems in most critical business applications today

true

in practice databases today may contain either data or information

true

in prototyping implemnetation and maintenance activities are repeated as necessary until the product is correct

true

information is processed data

true

many of the disadvantages of the file processing systems can also be limitations of database

true

metadata are data that describe the properties of other data

true

one reason for improved application development productivity with the database approach is that file design and low level implemnetation details do not need to be handeled by the application programmer

true

prototyping is a type if rapid application development

true

redundancy increases the risk of inconsistent data

true

searation of metadata from application programs that use the data is called data independence

true

the data repository assists database administrators in enforcing standards

true

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

true

the repository is populated during the analysis pahse of the sytems development life cycle

true

the systems development life cycle is the traditional methodology used to develop maintain and replace information systems

true

the user interface inclues languages menus and other facilities by which user interact with various system components

true

unplanned duplicate data files are the rule rather than the exception in file processing systems

true

because applications are often developed independently in file processing systems

unpanned duplicate data files are the rule rather than the exception

which of the following will interfere with access to operational database

unstructured and unpredictable use of data

Languages menus and other facilities by which users interact with the database are collectively called

user interface

An ____ is developed by identifying a form or report that a user needs on a regular basis

user view

a data warehouse derives its data from

various operational data sources

Which of the following types of data can be stored in a database

voice, letters, numbers

A relatively small team of people who collaborate on the same project is called

workgroup