Quiz 4 Database Management Systems(100% Verified)
An entity-relationship (E-R) modeling is an approach to representing data as entities, attributes
and relationships in a database structure. correct answers true
Cardinality refers to the number of entity occurrences that must be included in a relationship.
correct answers true
One way to indicate a one-to-many relationship is to place a crow's foot at the "one" side of the
relationship. correct answers false
The bottom-up design method begins with a general database design that models the overall
enterprise and repeatedly refines the model to achieve a design that supports all necessary
applications. correct answers false
In the top-down design method, specific user requirements are synthesized into a design. correct
answers false
During the conceptual-level design, designers must consider the characteristics of the particular
DBMS that the organization will use. correct answers false
Logical design is DBMS dependent. correct answers true
Physical design is hardware independent. correct answers false
Base on the database project scope, there are two types of design: centralized design and
decentralized design. correct answers true
An E-R model is made of entities, attributes and relationships. correct answers true
After the information-level design is completed, ____ is the next step. correct answers the
physical level design
When designing a database, you might find it helpful to design a(n) ____ to obtain the required
information from users. correct answers survey form
The type of information collected on the survey form that describes how data is updated is ____.
correct answers processing information
On a Crow's Foot Notation E-R diagram, the number closer to the rectangle represents ____
cardinality. correct answers maximum
____ means that an entity has a minimum cardinality of zero. correct answers the entity is not
required in the relationship
An entity-relationship (E-R) modeling is an approach to representing data as entities, attributes
and relationships in a database structure. correct answers true
Cardinality refers to the number of entity occurrences that must be included in a relationship.
correct answers true
One way to indicate a one-to-many relationship is to place a crow's foot at the "one" side of the
relationship. correct answers false
The bottom-up design method begins with a general database design that models the overall
enterprise and repeatedly refines the model to achieve a design that supports all necessary
applications. correct answers false
In the top-down design method, specific user requirements are synthesized into a design. correct
answers false
During the conceptual-level design, designers must consider the characteristics of the particular
DBMS that the organization will use. correct answers false
Logical design is DBMS dependent. correct answers true
Physical design is hardware independent. correct answers false
Base on the database project scope, there are two types of design: centralized design and
decentralized design. correct answers true
An E-R model is made of entities, attributes and relationships. correct answers true
After the information-level design is completed, ____ is the next step. correct answers the
physical level design
When designing a database, you might find it helpful to design a(n) ____ to obtain the required
information from users. correct answers survey form
The type of information collected on the survey form that describes how data is updated is ____.
correct answers processing information
On a Crow's Foot Notation E-R diagram, the number closer to the rectangle represents ____
cardinality. correct answers maximum
____ means that an entity has a minimum cardinality of zero. correct answers the entity is not
required in the relationship
