BCIS 4610 exam 2 study guide
conceptual - correct answer ✔The entity-relationship model is a ______ data
modeling used to capture the overall structure of data in an organization.
entity - correct answer ✔In the ER model, a person, place, object, event or
concept in the user environment about which data is to be maintained is called
a(n)
attribute - correct answer ✔In the ER model, a named property or
characteristic of an entity that is of interest to the organization is referred to as
degree - correct answer ✔The number of entity types that participate in a
relationship is referred to as the
relational type - correct answer ✔In a data model for a hospital, a patient is
described either as an outpatient or a resident patient. In this model the
patient represents a
indexed - correct answer ✔File organization method, rows are stored non-
sequentially but the address for each row is determined using an algorithm
The sequence of the rows from the same set of values - correct answer
✔Which of the following is not a property of relations in the relational database
model?
Normalization - correct answer ✔is the process of converting complex data
structures into simple, stable data structures
,third normal form (3 NF) - correct answer ✔A relation is in _____ when there
are no partical and transitive functional dependencies.
foreign key - correct answer ✔A _______ is an attribute that appears as a
nonprimary key attribute in one relation and as the primary key attribute in
another relation
the primary key is composed of multiple attributes - correct answer ✔The
criteria for a relation to be in the 2nd normal form applies only when _______.
Referential integrity - correct answer ✔is an integrity constraint specifying
that the value of an attribute in one relation depends on the value of the same
attribute in another relation.
the value of the key must uniquely identify every row in the relation - correct
answer ✔The primary key in a relation must satisfy that _______.
Calculated - correct answer ✔field is a field that can be derived from other
database fields.
Denormalization - correct answer ✔is the process of splitting or combining
normalized relations int physical tables based on affinity of use of rows and
fields
hashed - correct answer ✔In _______ file organization method, rows are
stored non-sequentially but the address for each row is determined using an
algorithm
key-indicator - correct answer ✔A ________ report provides summary of
critical information on regular basis.
, True - correct answer ✔The process of designing forms and reports must be
a user-focused activity and follows a prototyping approach.
How many copies of the report are needed? - correct answer ✔All of the
following are requirements that need to be considered when you design forms
and reports except:
Use of colors may suppress emotional reactions. - correct answer ✔All of the
following are potential problems of using colors in forms and reports except:
Use full justification so that text is aligned all around. - correct answer
✔Which of the following is not advised when displaying text in forms and
reports?
All of the following are measures of usability of a system except: - correct
answer ✔Ease of programming
Which of the following is not one of the ten user interface design
fundamentals? - correct answer ✔keep it clever
________ is a method by which users interact with an information system. -
correct answer ✔An interface
In ________ method, users enter explicit statements into a system to invoke
operations. - correct answer ✔a command language interaction
Natural language interaction method is based on research in ________. -
correct answer ✔artificial intelligence
conceptual - correct answer ✔The entity-relationship model is a ______ data
modeling used to capture the overall structure of data in an organization.
entity - correct answer ✔In the ER model, a person, place, object, event or
concept in the user environment about which data is to be maintained is called
a(n)
attribute - correct answer ✔In the ER model, a named property or
characteristic of an entity that is of interest to the organization is referred to as
degree - correct answer ✔The number of entity types that participate in a
relationship is referred to as the
relational type - correct answer ✔In a data model for a hospital, a patient is
described either as an outpatient or a resident patient. In this model the
patient represents a
indexed - correct answer ✔File organization method, rows are stored non-
sequentially but the address for each row is determined using an algorithm
The sequence of the rows from the same set of values - correct answer
✔Which of the following is not a property of relations in the relational database
model?
Normalization - correct answer ✔is the process of converting complex data
structures into simple, stable data structures
,third normal form (3 NF) - correct answer ✔A relation is in _____ when there
are no partical and transitive functional dependencies.
foreign key - correct answer ✔A _______ is an attribute that appears as a
nonprimary key attribute in one relation and as the primary key attribute in
another relation
the primary key is composed of multiple attributes - correct answer ✔The
criteria for a relation to be in the 2nd normal form applies only when _______.
Referential integrity - correct answer ✔is an integrity constraint specifying
that the value of an attribute in one relation depends on the value of the same
attribute in another relation.
the value of the key must uniquely identify every row in the relation - correct
answer ✔The primary key in a relation must satisfy that _______.
Calculated - correct answer ✔field is a field that can be derived from other
database fields.
Denormalization - correct answer ✔is the process of splitting or combining
normalized relations int physical tables based on affinity of use of rows and
fields
hashed - correct answer ✔In _______ file organization method, rows are
stored non-sequentially but the address for each row is determined using an
algorithm
key-indicator - correct answer ✔A ________ report provides summary of
critical information on regular basis.
, True - correct answer ✔The process of designing forms and reports must be
a user-focused activity and follows a prototyping approach.
How many copies of the report are needed? - correct answer ✔All of the
following are requirements that need to be considered when you design forms
and reports except:
Use of colors may suppress emotional reactions. - correct answer ✔All of the
following are potential problems of using colors in forms and reports except:
Use full justification so that text is aligned all around. - correct answer
✔Which of the following is not advised when displaying text in forms and
reports?
All of the following are measures of usability of a system except: - correct
answer ✔Ease of programming
Which of the following is not one of the ten user interface design
fundamentals? - correct answer ✔keep it clever
________ is a method by which users interact with an information system. -
correct answer ✔An interface
In ________ method, users enter explicit statements into a system to invoke
operations. - correct answer ✔a command language interaction
Natural language interaction method is based on research in ________. -
correct answer ✔artificial intelligence
