MODERN DATABASE MANAGEMENT
QUESTIONS AND VERIFIED ANSWERS WELL
GRADED (NEW 2025/2026
UPDATE)QUESTIONS WITH VERIFIED
ANSWERS 100% CORRECT /A+ GRADE
List five costs or risks associated with the database approach -
CORRECT ANSWER-1. New, specialized personnel
2. Installation and management cost and complexity
3. Conversion costs
4. Need for explicit backup and recovery
5. Organizational conflict
Define a three-tiered database architecture - CORRECT ANSWER-
Although any number of tiers may exist (from one to many),
three tiers of computers relate
to the client/server architecture for database processing: (1) the
client tier, where database
contents are presented to the user; (2) the application/Web
server tier, where analyses on
database contents are made and user sessions are managed;
and (3) the enterprise server
tier, where the data from across the organization are merged
into an organizational asset.
,Name the five phases of the traditional systems development
life cycles and explain the purpose and deliverables of each
phase - CORRECT ANSWER-...
In which of the five phases of the SDLC do database
development activities occur? - CORRECT ANSWER-Database
development activities occur in each of these overlapping
phases, and feedback
may occur that causes a project to return to a prior phase.
Explain the differences between user views, a conceptual
schema, and an internal schema as different perspectives of the
same database - CORRECT ANSWER-(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 ANSWER---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 ANSWER-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 ANSWER-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 ANSWER-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 ANSWER-Degree of a relationship is
the number of entity types that participate in that relationship.
QUESTIONS AND VERIFIED ANSWERS WELL
GRADED (NEW 2025/2026
UPDATE)QUESTIONS WITH VERIFIED
ANSWERS 100% CORRECT /A+ GRADE
List five costs or risks associated with the database approach -
CORRECT ANSWER-1. New, specialized personnel
2. Installation and management cost and complexity
3. Conversion costs
4. Need for explicit backup and recovery
5. Organizational conflict
Define a three-tiered database architecture - CORRECT ANSWER-
Although any number of tiers may exist (from one to many),
three tiers of computers relate
to the client/server architecture for database processing: (1) the
client tier, where database
contents are presented to the user; (2) the application/Web
server tier, where analyses on
database contents are made and user sessions are managed;
and (3) the enterprise server
tier, where the data from across the organization are merged
into an organizational asset.
,Name the five phases of the traditional systems development
life cycles and explain the purpose and deliverables of each
phase - CORRECT ANSWER-...
In which of the five phases of the SDLC do database
development activities occur? - CORRECT ANSWER-Database
development activities occur in each of these overlapping
phases, and feedback
may occur that causes a project to return to a prior phase.
Explain the differences between user views, a conceptual
schema, and an internal schema as different perspectives of the
same database - CORRECT ANSWER-(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 ANSWER---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 ANSWER-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 ANSWER-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 ANSWER-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 ANSWER-Degree of a relationship is
the number of entity types that participate in that relationship.
