QAA ON DATABASE SYSTEMS
Data modeling may be the most important part of the systems development process
because: - CORRECT ANSWER-data characteristics are important in the design of
programs and other systems components.
The logical representation of an organization's data is called a(n): - CORRECT
ANSWER-entity-relationship model.
The common types of entities are: - CORRECT ANSWER-strong entities, weak entities,
and associative entities(all of the above)
In an E-R diagram, there are ________ business rule(s) for every relationship. -
CORRECT ANSWER-two
Business policies and rules govern all of the following EXCEPT - CORRECT ANSWER-
managing employees
A business rule: - CORRECT ANSWER-defines or constrains some aspect of the
business.
asserts business structure.
controls or influences the behavior of the business.
(all of the above)
Which of the following is NOT a characteristic of a good business rule? - CORRECT
ANSWER-Inconsistent
Which of the following is NOT a good characteristic of a data name? - CORRECT
ANSWER-Relates to a technical characteristic of the system
A fact is an association between two or more: - CORRECT ANSWER-terms
A good data definition will describe all of the characteristics of a data object EXCEPT: -
CORRECT ANSWER-who can delete the data
Customers, cars, and parts are examples of - CORRECT ANSWER-entities
Which of the following is an entity type on which a strong entity depends? - CORRECT
ANSWER-Owner
Member
Attribute
D) None of the above is the answer
,An entity type whose existence depends on another entity type is called a ________
entity. - CORRECT ANSWER-weak
a strong entity and its associated weak entity - CORRECT ANSWER-
A(n) ________ is the relationship between a weak entity type and its owner. -
CORRECT ANSWER-identifying relationship
An entity type name should be all of the following EXCEPT - CORRECT ANSWER-as
short as possible
A property or characteristic of an entity type that is of interest to the organization is
called a(n): - CORRECT ANSWER-attribute
An attribute that must have a value for every entity (or relationship) instance is a(n): -
CORRECT ANSWER-required attribute
A person's name, birthday, and social security number are all examples of - CORRECT
ANSWER-attributes
An attribute of an entity that must have a value for each entity instance is a(n): -
CORRECT ANSWER-required attribute
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
- CORRECT ANSWER-composite
a composite attribute - CORRECT ANSWER-The address attribute is
multivalued attribute - CORRECT ANSWER-The skill attribute is
derived - CORRECT ANSWER-The years employed attribute is
An attribute that can be calculated from related attribute values is called a(n) ________
attribute. - CORRECT ANSWER-derived
The total quiz points for a student for an entire semester is a(n) ________ attribute -
CORRECT ANSWER-derived
Which of the following criteria should be considered when selecting an identifier? -
CORRECT ANSWER-Choose an identifier that is stable.
Choose an identifier that will not be null.
Choose an identifier that doesn't have large composite attributes. (All of the above)
An attribute that uniquely identifies an entity and consists of a composite attribute is
called a(n): - CORRECT ANSWER-composite identifier
,An entity that associates the instances of one or more entity types and contains
attributes specific to the relationships is called a(n): - CORRECT ANSWER-associative
entity
Which of the following conditions should exist if an associative entity is to be created? -
CORRECT ANSWER-All the relationships for the participating entities are many-to-
many.
The new associative entity has independent meaning.
The new associative entity participates in independent relationships. (all of the above)
The number of entity types that participate in a relationship is called the: - CORRECT
ANSWER-degree
A relationship between the instances of a single entity type is called a(n) ________
relationship - CORRECT ANSWER-unary
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. -
CORRECT ANSWER-many-to-many
Ternary - CORRECT ANSWER-In the following diagram, what type of relationship is
depicted?
It depicts a unary relationship.
It depicts a many-to-many relationship.
There is an associative entity.
(All of the above) - CORRECT ANSWER-In the following diagram, which is true?
A ________ specifies the number of instances of one entity that can be associated with
each instance of another entity. - CORRECT ANSWER-cardinality constraint
A simultaneous relationship among the instances of three entity types is called a(n)
________ relationship. - CORRECT ANSWER-ternary
A person can marry at most one person. - CORRECT ANSWER-In the figure shown
below, which of the following is true?
A relationship where the minimum and maximum cardinality are both one is a(n)
________ relationship. - CORRECT ANSWER-mandatory one
A department can have more than one employee. - CORRECT ANSWER-For the
relationship represented in the figure below, which of the following is true?
Each patient has one or more patient histories.
Each patient history belongs to one and only one patient. (both A and C) - CORRECT
ANSWER-In the following diagram, which of the answers below is true?
, Each vendor can supply many parts to any number of warehouses, but need not supply
any parts. - CORRECT ANSWER-In the figure shown below, which of the following
business rules would apply?
A value that indicates the date or time of a data value is called a(n): - CORRECT
ANSWER-time stamp.
Each employee can supervise one to many employees - CORRECT ANSWER-In the
following diagram, which answer is true?
A mutually exclusive relationship is one in which: - CORRECT ANSWER-an entity
instance can participate in only one of several alternative relationships.
Most systems developers believe that data modeling is the least important part of the
systems development process. - CORRECT ANSWER-FALSE
Data, rather than processes, are the most complex aspects of many modern information
systems - CORRECT ANSWER-TRUE
The E-R model is used to construct a conceptual model. - CORRECT ANSWER-TRUE
In an E-R diagram, strong entities are represented by double-walled rectangles. -
CORRECT ANSWER-FALSE
In an E-R diagram, an associative entity is represented by a rounded rectangle. -
CORRECT ANSWER-TRUE
Data modeling is about documenting rules and policies of an organization that govern
data. - CORRECT ANSWER-TRUE
One of the roles of a database analyst is to identify and understand rules that govern
data. - CORRECT ANSWER-TRUE
The purpose of data modeling is to document business rules about processes. -
CORRECT ANSWER-FALSE
A business rule is a statement that defines or constrains some aspect of the business. -
CORRECT ANSWER-TRUE
The intent of a business rule is to break down business structure - CORRECT
ANSWER-FALSE
Enforcement of business rules can be automated through the use of software tools that
can interpret the rules and enforce them. - CORRECT ANSWER-TRUE
Data modeling may be the most important part of the systems development process
because: - CORRECT ANSWER-data characteristics are important in the design of
programs and other systems components.
The logical representation of an organization's data is called a(n): - CORRECT
ANSWER-entity-relationship model.
The common types of entities are: - CORRECT ANSWER-strong entities, weak entities,
and associative entities(all of the above)
In an E-R diagram, there are ________ business rule(s) for every relationship. -
CORRECT ANSWER-two
Business policies and rules govern all of the following EXCEPT - CORRECT ANSWER-
managing employees
A business rule: - CORRECT ANSWER-defines or constrains some aspect of the
business.
asserts business structure.
controls or influences the behavior of the business.
(all of the above)
Which of the following is NOT a characteristic of a good business rule? - CORRECT
ANSWER-Inconsistent
Which of the following is NOT a good characteristic of a data name? - CORRECT
ANSWER-Relates to a technical characteristic of the system
A fact is an association between two or more: - CORRECT ANSWER-terms
A good data definition will describe all of the characteristics of a data object EXCEPT: -
CORRECT ANSWER-who can delete the data
Customers, cars, and parts are examples of - CORRECT ANSWER-entities
Which of the following is an entity type on which a strong entity depends? - CORRECT
ANSWER-Owner
Member
Attribute
D) None of the above is the answer
,An entity type whose existence depends on another entity type is called a ________
entity. - CORRECT ANSWER-weak
a strong entity and its associated weak entity - CORRECT ANSWER-
A(n) ________ is the relationship between a weak entity type and its owner. -
CORRECT ANSWER-identifying relationship
An entity type name should be all of the following EXCEPT - CORRECT ANSWER-as
short as possible
A property or characteristic of an entity type that is of interest to the organization is
called a(n): - CORRECT ANSWER-attribute
An attribute that must have a value for every entity (or relationship) instance is a(n): -
CORRECT ANSWER-required attribute
A person's name, birthday, and social security number are all examples of - CORRECT
ANSWER-attributes
An attribute of an entity that must have a value for each entity instance is a(n): -
CORRECT ANSWER-required attribute
An attribute that can be broken down into smaller parts is called a(n) ________ attribute
- CORRECT ANSWER-composite
a composite attribute - CORRECT ANSWER-The address attribute is
multivalued attribute - CORRECT ANSWER-The skill attribute is
derived - CORRECT ANSWER-The years employed attribute is
An attribute that can be calculated from related attribute values is called a(n) ________
attribute. - CORRECT ANSWER-derived
The total quiz points for a student for an entire semester is a(n) ________ attribute -
CORRECT ANSWER-derived
Which of the following criteria should be considered when selecting an identifier? -
CORRECT ANSWER-Choose an identifier that is stable.
Choose an identifier that will not be null.
Choose an identifier that doesn't have large composite attributes. (All of the above)
An attribute that uniquely identifies an entity and consists of a composite attribute is
called a(n): - CORRECT ANSWER-composite identifier
,An entity that associates the instances of one or more entity types and contains
attributes specific to the relationships is called a(n): - CORRECT ANSWER-associative
entity
Which of the following conditions should exist if an associative entity is to be created? -
CORRECT ANSWER-All the relationships for the participating entities are many-to-
many.
The new associative entity has independent meaning.
The new associative entity participates in independent relationships. (all of the above)
The number of entity types that participate in a relationship is called the: - CORRECT
ANSWER-degree
A relationship between the instances of a single entity type is called a(n) ________
relationship - CORRECT ANSWER-unary
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. -
CORRECT ANSWER-many-to-many
Ternary - CORRECT ANSWER-In the following diagram, what type of relationship is
depicted?
It depicts a unary relationship.
It depicts a many-to-many relationship.
There is an associative entity.
(All of the above) - CORRECT ANSWER-In the following diagram, which is true?
A ________ specifies the number of instances of one entity that can be associated with
each instance of another entity. - CORRECT ANSWER-cardinality constraint
A simultaneous relationship among the instances of three entity types is called a(n)
________ relationship. - CORRECT ANSWER-ternary
A person can marry at most one person. - CORRECT ANSWER-In the figure shown
below, which of the following is true?
A relationship where the minimum and maximum cardinality are both one is a(n)
________ relationship. - CORRECT ANSWER-mandatory one
A department can have more than one employee. - CORRECT ANSWER-For the
relationship represented in the figure below, which of the following is true?
Each patient has one or more patient histories.
Each patient history belongs to one and only one patient. (both A and C) - CORRECT
ANSWER-In the following diagram, which of the answers below is true?
, Each vendor can supply many parts to any number of warehouses, but need not supply
any parts. - CORRECT ANSWER-In the figure shown below, which of the following
business rules would apply?
A value that indicates the date or time of a data value is called a(n): - CORRECT
ANSWER-time stamp.
Each employee can supervise one to many employees - CORRECT ANSWER-In the
following diagram, which answer is true?
A mutually exclusive relationship is one in which: - CORRECT ANSWER-an entity
instance can participate in only one of several alternative relationships.
Most systems developers believe that data modeling is the least important part of the
systems development process. - CORRECT ANSWER-FALSE
Data, rather than processes, are the most complex aspects of many modern information
systems - CORRECT ANSWER-TRUE
The E-R model is used to construct a conceptual model. - CORRECT ANSWER-TRUE
In an E-R diagram, strong entities are represented by double-walled rectangles. -
CORRECT ANSWER-FALSE
In an E-R diagram, an associative entity is represented by a rounded rectangle. -
CORRECT ANSWER-TRUE
Data modeling is about documenting rules and policies of an organization that govern
data. - CORRECT ANSWER-TRUE
One of the roles of a database analyst is to identify and understand rules that govern
data. - CORRECT ANSWER-TRUE
The purpose of data modeling is to document business rules about processes. -
CORRECT ANSWER-FALSE
A business rule is a statement that defines or constrains some aspect of the business. -
CORRECT ANSWER-TRUE
The intent of a business rule is to break down business structure - CORRECT
ANSWER-FALSE
Enforcement of business rules can be automated through the use of software tools that
can interpret the rules and enforce them. - CORRECT ANSWER-TRUE
