Database Management: Exam 1 (Ch. 1 & 2)
E. F. Codd developed the relational model in the:
1970's
Database development begins with ________, which establishes the range and general contents of organizational databases
Enterprise Data Modeling
(T/F) A business rule is a statement of how a policy is enforced or conducted
FALSE
(T/F) An example of a term would be the following sentence: "A student registers for a course."
FALSE
(T/F) Most systems developers believe that data modeling is the least important part of the systems development process.
FALSE
(T/F) The intent of a business rule is to break down business structure
FALSE
(T/F) When systems are automatically generated and maintained, quality is diminished.
FALSE
Which of the following is NOT a cost and/or risk of the database approach
Improved responsiveness
Which of the following is NOT a good characteristic of a data name?
Relates to a technical characteristic of the system
The traditional methodology used to develop, maintain and replace information systems is called the
Systems Development Life Cycle (SDLC)
(T/F) A business rule is a statement that defines or constrains some aspect of the business.
TRUE
(T/F) A business rule should be internally consistent.
TRUE
(T/F) A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.
TRUE
(T/F) A single occurrence of an entity is called an entity instance.
TRUE
(T/F) An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data
TRUE
(T/F) Data names should always relate to business characteristics.
TRUE
(T/F) Enforcement of business rules can be automated through the use of software tools that can interpret the rules and enforce them.
TRUE
(T/F) One of the roles of a database analyst is to identify and understand rules that govern data.
TRUE
(T/F) The E-R model is used to construct a conceptual model.
TRUE
(T/F) When choosing an identifier, choose one that will not change its value often.
TRUE
(T/F) While business rules are not redundant, a business rule can refer to another business rule.
TRUE
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
The SDLC phase in which the detailed conceptual data model is created is the ________ phase.
analysis
In a file processing environment, descriptions for data and the logic for accessing the data are built into:
application programs
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
A person's name, birthday, and social security number are all examples of:
attributes
A ________ defines or constrains some aspect of the business
business rule
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
composite
A rule that CANNOT be violated by database users is called a:
constraint
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.
A graphical system used to capture the nature and relationships among data is called a(n):
data model
The number of entity types that participate in a relationship is called the:
degree
Customers, cars, and parts are examples of:
entities
A person, place, object, event, or concept about which the organization wishes to maintain
entity
The logical representation of an organization's data is called a(n):
entity-relationship model
The most common source of database failures in organizations is
failure to implement a strong database administration function.
Program-data dependence is caused by:
file descriptors being stored in each application.
A(n) ________ is the relationship between a weak entity type and its owner.
identifying relationship
Which of the following is NOT a characteristic of a good business rule?
inconsistent
The three-schema approach includes which of the following schemas?
internal
Older systems that often contain data of poor quality are called ________ systems.
legacy
A database is an organized collection of ________ related data
logically
Business policies and rules govern all of the following EXCEPT
managing employees
Data that describe the properties of other data are:
metadata
Which organizational function should set database standards?
none
All of the following are properties of metadata EXCEPT
processing logic
One of the most popular RAD methods is:
prototyping
All of the following are primary purposes of a database management system (DBMS) EXCEPT:
providing an integrated development environment.
Which of the following is NOT an advantage of database systems
redundant data
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
relation
________ are established between entities in a well-structured database so that the desired information can be retrieved.
relationships
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
With the database approach, data descriptions are stored in a central location known as a:
repository
An attribute of an entity that must have a value for each entity instance is a(n):
required attribute
An attribute that must have a value for every entity (or relationship) instance is a(n):
required attribute
A workgroup database is stored on a central device called a:
server
The most common types of entities are:
strong
Which of the following is an entity that exists independently of other entity types?
strong entity
A fact is an association between two or more:
terms
A simultaneous relationship among the instances of three entity types is called a ________ relationship.
ternary
In an E-R diagram, there are/is ________ business rule(s) for every relationship
two
A relationship between the instances of a single entity type is called a ________ relationship
unary
Because applications are often developed independently in file processing systems:
unplanned duplicate data files are the rule rather than the exception.
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
An entity type whose existence depends on another entity type is called a ________ entity
weak entity
A good data definition will describe all of the characteristics of a data object EXCEPT:
who can delete the data