TEST BANK MODERN DATABASE MANAGEMENT EXPERT-VERIFIED
QUESTIONS WITH DETAILED ANSWERS – NEWLY RELEASED!
what is an open source dbms? - CORRECT ANSWERS-Free DBMS source code software that
provides the core functionality of an SQL-compliant DBMS.
database administration or data administration?
managing the data repository - CORRECT ANSWERS-data administration
database administration or data administration?
installing and upgrading the dbms - CORRECT ANSWERS-database administration
database administration or data administration?
conceptual data modeling - CORRECT ANSWERS-data administration
database administration or data administration?
managing data security and privacy - CORRECT ANSWERS-database administration
database administration or data administration?
database planning - CORRECT ANSWERS-data administration
database administration or data administration?
,Explain the differences between user views, a conceptual schema, and an internal schema as different
perspectives of the same database - CORRECT ANSWERS-(1) a conceptual schema, which
provides a complete, technology-independent picture of
the database; (2) an internal schema, which specifies the complete database as it will be
stored in computer secondary memory in terms of a logical schema and a physical schema;
and (3) an external schema or user view, which describes the database relevant to a specific
set of users in terms of a set of user views combined with the enterprise data model.
stored attribute vs derived attribute - CORRECT ANSWERS---Stored attribute is an attribute
that is already stored in the database. -ex) calculating a person's age from the person's date of birth and
present date.-stored attribute is the date of birth.
--derived attribute is an attribute whose values can be calculated from related attribute
values (plus possibly data not in the database, such as today's date, the current time, or a security code
provided by a system user).
-Symbolized by square brackets "[ ]"
- Or a forward slash (/) in front of the attribute name
simple attribute vs. composite attribute - CORRECT ANSWERS-Simple (atomic) attribute is an
attribute that cannot be broken down into smaller components that are meaningful for the organization.
-Composite attribute is an attribute such as Address, that has meaningful component parts, which are
more detailed attributes.
entity type vs relationship type - CORRECT ANSWERS-Entity type is a collection of entities that
share common properties, whereas an entity instance is a single occurrence of an entity type.
-Relationship type is a meaningful association between (or among) entity types.
strong entity type vs weak entity type - CORRECT ANSWERS-Strong entity type is an entity
that has its own identifier and can exist without other entities
-Weak entity type is an entity that has its own identifier and can exist without other entities and don't
have their own identifiers but a partial identifier
, degree vs cardinality - CORRECT ANSWERS-Degree of a relationship is the number of entity
types that participate in that relationship.
-Cardinality specifies the number of instances of entity B that can (or must) be associated with each
instance of entity A.
required attribute vs optional attribute - CORRECT ANSWERS-Required attribute is an
attribute that must have a value for every entity (or relationship) instance with which it is associated.
-Symbolized by boldface or " * "
--Optional attribute is an attribute that may not have a value for every entity (or relationship) instance
with which it is associated.
composite attribute vs multivalued attribute - CORRECT ANSWERS-Composite attribute is an
attribute such as Address, that has meaningful component parts, which are more detailed attributes.
--Multivalued attribute is one that can have multiple values for a single instance of an entity
ternary relationship vs three binary relationships - CORRECT ANSWERS-Ternary relationship is
a simultaneous relationship among the instances of three entity types.
--Three binary relationship when an attribute of a relationship cannot be properly associated with any
one of the three possible binary relationships among the three entity types.
give four reasons why a business rules approach is advocated as a new paradigm for specifying
information systems requirements - CORRECT ANSWERS--In the database world, it has been
more common to use the related term integrity constraint when referring to such rules
-A business rules approach is based on the following premises:
1. Business rules are a core concept in an enterprise because they are an expression of
business policy and guide individual and aggregate behavior. Well-structured
business rules can be stated in natural language for end users and in a data model
for systems developers.
2. Business rules can be expressed in terms that are familiar to end users. Thus, users
can define and then maintain their own rules.
3. Business rules can be expressed in terms that are familiar to end users. Thus, users
can define and then maintain their own rules.
QUESTIONS WITH DETAILED ANSWERS – NEWLY RELEASED!
what is an open source dbms? - CORRECT ANSWERS-Free DBMS source code software that
provides the core functionality of an SQL-compliant DBMS.
database administration or data administration?
managing the data repository - CORRECT ANSWERS-data administration
database administration or data administration?
installing and upgrading the dbms - CORRECT ANSWERS-database administration
database administration or data administration?
conceptual data modeling - CORRECT ANSWERS-data administration
database administration or data administration?
managing data security and privacy - CORRECT ANSWERS-database administration
database administration or data administration?
database planning - CORRECT ANSWERS-data administration
database administration or data administration?
,Explain the differences between user views, a conceptual schema, and an internal schema as different
perspectives of the same database - CORRECT ANSWERS-(1) a conceptual schema, which
provides a complete, technology-independent picture of
the database; (2) an internal schema, which specifies the complete database as it will be
stored in computer secondary memory in terms of a logical schema and a physical schema;
and (3) an external schema or user view, which describes the database relevant to a specific
set of users in terms of a set of user views combined with the enterprise data model.
stored attribute vs derived attribute - CORRECT ANSWERS---Stored attribute is an attribute
that is already stored in the database. -ex) calculating a person's age from the person's date of birth and
present date.-stored attribute is the date of birth.
--derived attribute is an attribute whose values can be calculated from related attribute
values (plus possibly data not in the database, such as today's date, the current time, or a security code
provided by a system user).
-Symbolized by square brackets "[ ]"
- Or a forward slash (/) in front of the attribute name
simple attribute vs. composite attribute - CORRECT ANSWERS-Simple (atomic) attribute is an
attribute that cannot be broken down into smaller components that are meaningful for the organization.
-Composite attribute is an attribute such as Address, that has meaningful component parts, which are
more detailed attributes.
entity type vs relationship type - CORRECT ANSWERS-Entity type is a collection of entities that
share common properties, whereas an entity instance is a single occurrence of an entity type.
-Relationship type is a meaningful association between (or among) entity types.
strong entity type vs weak entity type - CORRECT ANSWERS-Strong entity type is an entity
that has its own identifier and can exist without other entities
-Weak entity type is an entity that has its own identifier and can exist without other entities and don't
have their own identifiers but a partial identifier
, degree vs cardinality - CORRECT ANSWERS-Degree of a relationship is the number of entity
types that participate in that relationship.
-Cardinality specifies the number of instances of entity B that can (or must) be associated with each
instance of entity A.
required attribute vs optional attribute - CORRECT ANSWERS-Required attribute is an
attribute that must have a value for every entity (or relationship) instance with which it is associated.
-Symbolized by boldface or " * "
--Optional attribute is an attribute that may not have a value for every entity (or relationship) instance
with which it is associated.
composite attribute vs multivalued attribute - CORRECT ANSWERS-Composite attribute is an
attribute such as Address, that has meaningful component parts, which are more detailed attributes.
--Multivalued attribute is one that can have multiple values for a single instance of an entity
ternary relationship vs three binary relationships - CORRECT ANSWERS-Ternary relationship is
a simultaneous relationship among the instances of three entity types.
--Three binary relationship when an attribute of a relationship cannot be properly associated with any
one of the three possible binary relationships among the three entity types.
give four reasons why a business rules approach is advocated as a new paradigm for specifying
information systems requirements - CORRECT ANSWERS--In the database world, it has been
more common to use the related term integrity constraint when referring to such rules
-A business rules approach is based on the following premises:
1. Business rules are a core concept in an enterprise because they are an expression of
business policy and guide individual and aggregate behavior. Well-structured
business rules can be stated in natural language for end users and in a data model
for systems developers.
2. Business rules can be expressed in terms that are familiar to end users. Thus, users
can define and then maintain their own rules.
3. Business rules can be expressed in terms that are familiar to end users. Thus, users
can define and then maintain their own rules.
