Design of Database Systems Exam 1- Chapters 1 & 2 Multiple Choice

A database is an organized collection of _________ related data

logically

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

legacy

Program-data dependence is caused by:

file descriptors being stored in each application

Because applications are often developed independently in file processing systems:

unplanned duplicate data files are the rule rather than the exception

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

relation

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

user view

A graphical system used to capture the nature and relationships among data is called a(n):

data model

Data that describe the properties of other data are:

metadata

All of the following are properties of metadata EXCEPT

processing logic

A person, place, object, event, or concept about which the organization wishes to maintain

entity

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

relationships

All of the following are primary purposes of a database management system (DBMS) EXCEPT:

providing an integrated development environment

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

repository

A user view is:

a logical description of some portion of the database

Which organizational function should set database standards?

database administrator

Which of the following is NOT an advantage of database systems?

redundant data

The most common source of database failures in organizations is:

failure to implement a strong database administrator function

A rule that CANNOT be violated by database users is called a:

constraint

The three-schema approach includes which of the following schemas?

internal

One of the most popular RAD methods is:

prototyping

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

analysis

The traditional methodology used to develop, maintain and replace information systems is called the:

SDLC

Database development begins with ________, which establishes the range and general contents of organizational databases.

data enterprise modeling

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):

repository

A knowledge base of information or facts about an enterprise is called a(n):

repository

Which of the following is NOT a cost and/or risk of the database approach?

improved responsiveness

A workgroup database is stored on a central device called a:

server

Which of the following is NOT an objective that drove the development and evolution of database technology?

the desire to require programmers to write all file handling functionality

E. F. Codd developed the relational model in the:

1970s

In a file processing environment, descriptions for data and the logic for accessing the data are built into:

application programs

The logical representation of an organization's data is called a(n):

entity-relationship model

A good data definition will describe all of the characteristics of a data object EXCEPT:

who can delete the data

A fact is an association between two or more:

terms

Data modeling may be the most important part of the systems development process because:

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

The most common types of entities are:

strong entities

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

two

Business policies and rules govern all of the following EXCEPT:

managing employees

A ________ defines or constrains some aspect of the business.

business rule

Which of the following is NOT a characteristic of a good business rule?

inconsistent

Which of the following is NOT a good characteristic of a data name?

relates to a technical characteristic of the system

Customers, cars, and parts are examples of:

entities

Which of the following is an entity that exists independently of other entity types?

strong

An entity type whose existence depends on another entity type is called a ________ entity.

weak

A(n) ________ is the relationship between a weak entity type and its owner.

identifying relationship

An entity type name should be all of the following EXCEPT:

as short as possible

A property or characteristic of an entity type that is of interest to the organization is called a(n):

attribute

An attribute that must have a value for every entity (or relationship) instance is a(n):

required attribute

A person's name, birthday, and social security number are all examples of:

attributes

An attribute that can be broken down into smaller parts is called a(n) ________ attribute.

composite

The number of entity types that participate in a Unary relationship is:

one

The number of entity types that participate in a relationship is called the:

degree

A relationship between the instances of a single entity type is called a ________ relationship.

unary

Write out: CASE tool

Computer-Aided Software Engineering tool

Write out: DBMS

Database Management System

Write out: ERP

Enterprise Resource Planning

Write out: SDLC

Systems Development Life Cycle

Write out: ERD

Entity-Relationship Diagram

Write out: ERM

Entity-Relationship Model

Write out: RAD

Rapid Application Development

Write out: SQL

Structured Query Language

Write out: LAN

Local Area Network