Design of DB Ch. 1 & 2
An attribute that can be broken down into smaller parts is called a(n) ________ attribute.
composite
A cardinality constraint tells what kinds of properties are associated with an entity.
f
A customer can order many items, and an item can be ordered by many customers is an example of a recursive relationship.
f
A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.
f
In an E-R diagram, strong entities are represented by double-walled rectangles
f
Participation in a relationship may be optional or mandatory.
t
A fact is an association between two or more:
terms.
An attribute of an entity that is computed is a(n):
derived attribute.
All of the following are properties of metadata EXCEPT:
processing logic.
One of the most popular RAD methods is:
prototyping.
Relational databases establish the relationships between entities by means of common fields included in a file called a(n):
relation.
The most common types of entities are:
strong entities.
A fact is an association between two or more terms.
t
A single occurrence of an entity type is called an entity instance
t
An attribute whose values can be calculated from related attribute values is called a derived attribute.
t
An entity type name should always be a singular noun.
t
Enforcement of business rules can be automated through the use of software that can interpret the rules and enforce them.
t
A relationship between the instances of a single entity type is called a ________ relationship.
unary
Languages, menus, and other facilities by which users interact with the database are collectively called a(n):
user interface
A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.
user view
A good data definition will describe all of the characteristics of a data object EXCEPT
who can delete the data.
The following figure shows an example of:
B) a strong entity and its associated weak entity.
In the following diagram, which is true?
It depicts a many-to-many relationship.
An attribute that uniquely identifies an entity and consists of a composite attribute is called a(n):
composite identifier.
An attribute that can be calculated from related attribute values is called a ________ attribute.
derived
A person, place, an object , an event or concept about which the organization wishes to maintain data is called a(n):
entity.
It is desirable that no two attributes across all entity types have the same name. .
t
Which of the following is NOT a good characteristic of a data name?
Relates to a technical characteristic of the system
A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.
cardinality constraint
E. F. Codd developed the relational model in the:
1970s.
In the figure below, which attribute is derived?
Years_Employed
The following figure shows an example of:
a composite attribute.
A ________ defines or constrains some aspect of the business.
business rule
The SDLC phase in which database processing programs are created is the ________ phase.
implementation
A business rule is a statement that defines or constrains some aspect of the business
t
A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.
t
A multivalued attribute may take on more than one value for a particular entity instance.
t
One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier
t
A simultaneous relationship among the instances of three entity types is called a ________ relationship
ternary
A value that indicates the date or time of a data value is called a:
time stamp.
In an E-R diagram, there are/is ________ business rule(s) for every relationship.
two
The maximum criminality of a relationship is the maximum number of instances of entity B that may be associated with each instance of entity
f
It is not permissible to associate attributes with relationships.
f
The intent of a business rule is to break down business structure
f
Data, rather than processes, are the most complex aspects of many modern information systems. .
t
In the figure below, Name would be an ideal identifier.
f
A(n) ________ is the relationship between a weak entity type and its owner.
identifying relationship
The number of entity types that participate in a Unary relationship is:
one.
Organizing the database in computer disk storage is done in the ________ phase.
design
A time stamp is a time value that is associated with a data value
t
An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data
t
Data names should always relate to business characteristics.
t
The E-R model is used to construct a conceptual model
t
The logical representation of an organization's data is called a(n):
entity-relationship model
A business rule is a statement of how a policy is enforced or conducted
f
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 knowledge base of information on facts about an enterprise is called a(n):
repository.
One of the roles of a database analyst is to identify and understand rules that govern data
t
The relationship among the instances of three entity types is called a unary relationship. .
t
The relationship between a weak entity type and its owner is an identifying relationship.
t
In the following diagram, what type of relationship is depicted?
C) Ternary
Which of the following is an entity that exists independently of other entity types?
Strong
________ is a tool even non-programmers can use to access information from a database.
Structured query language
Program-data dependence is caused by:
file descriptors being stored in each application.
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.
An entity type whose existence depends on another entity type is called a ________ entity.
weak
A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n):
repository.
An attribute that must be present for every entity (or relationship) instance is a(n):
required attribute.
A business rule should be internally consistent.
t
A workgroup database is stored on a central device called a(n):
server.
Data modeling is about documenting rules and policies of an organization that govern data
t
Relationships represent action being taken using a verb phrase
t
The relationship between the instances of two entity types is called a binary relationship.
t
When choosing an identifier, choose one that will not change its value often
t
While business rules are not redundant, a business rule can refer to another business rule.
t
Which of the following is NOT a characteristic of a good business rule?
Inconsistent
Which of the following criteria should be considered when selecting an identifier?
Choose an identifier that doesn't have large composite attributes.
Business rules are formulated from a collection of business ramblings. .
f
A ternary relationship is equivalent to three binary relationships
f
In the figure below, which attribute is multivalued?
C) Skill
Organizations that utilize the file processing approach spend as much as ________ of their IS development budget on maintenance.
80 percent
Which of the following is NOT a cost and/or risk of the database approach?
Improved responsiveness
The traditional methodology used to develop, maintain and replace information systems is called the:
Systems Development Life Cycle.
________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business.
Systems analysts
A mutually exclusive relationship is one in which:
an entity instance can participate in only one of several alternative relationships.
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.
An entity that associates the instances of one or more entity types and contains attributes peculiar to the relationships is called a(n):
associative entity.
One application of data warehouses is:
decision support.
The number of entity types that participate in a relationship is called the:
degree.
The total quiz points for a student for an entire semester is a(n) ________ attribute
derived
Customers, cars, and parts are examples of:
entities.
A simple attribute can be broken down into smaller pieces.
f
An entity type on which a strong entity is dependent is called a covariant entity.
f
An example of a term would be the following sentence: "A student registers for a course."
f
Data names do not have to be unique.
f
In an E-R diagram, an associative entity is represented by a rounded rectangle
f
Most systems developers believe that data modeling is the least important part of the systems development process.
f
Some examples of attributes are: eye_color, weight, student_id, STUDENT. T
f
The degree of a relationship is the number of attributes that are associated with it.
f
The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.
f
The purpose of data modeling is to document business rules about processes.
f
The most common source of database failures in organizations is:
failure to implement a strong database administration function.
Data processed in a way that increases a user's knowledge is:
information.
Business policies and rules govern all of the following EXCEPT
managing employees.
A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.
mandatory one
A student can attend five classes, each with a different professor. Each professor has 30 students. The relationship of students to professors is a ________ relationship.
many-to-many
