WGU C170 ER-Modeling
RATED A+
Unary relationships are common in manufacturing industries. - ✔✔TRUE
_________________ not only helps database designers to stay on track during the design process, it
also enables them to pick up the design thread when the time comes to modify the design. -
✔✔Documentation
Ideally, an entity identifier is composed of _____ attribute(s). - ✔✔one
The first step in building an entity-relationship diagram (ERD) is
___________________________________________________________. - ✔✔creating a detailed
narrative of the organization's description of operations
A ________ entity has a primary key that is partially or totally derived from the parent entity in the
relationship. - ✔✔weak
The decision to store ____________ attributes in database tables depends on the processing
requirements and the constraints placed on a particular application. - ✔✔derived
In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side
must be loaded first. - ✔✔TRUE
To implement a small database, a database designer must know the "1" and the "M" sides of each
relationship and whether the relationships are mandatory or optional. - ✔✔TRUE
A _________ attribute is one that cannot be subdivided. - ✔✔simple
Complex ____________ requirements may dictate data transformations, and they may expand the
number of entities and attributes within the design. - ✔✔information
, A weak entity must be ______________ dependent. - ✔✔existence
The entity relationship diagram (ERD) represents the ______________ database as viewed by the
end user. - ✔✔conceptual
In the original Chen notation, each attribute is represented by an oval with the attribute name
connected to an entity rectangle with a line. - ✔✔TRUE
In Crow's Foot notation, an optional relationship between entities is shown by drawing a
__________________ on the side of the optional entity. - ✔✔small circle
An entity is said to be ______________-dependent if it can exist in the database only when it is
associated with another related entity occurrence. - ✔✔existence
A(n) ___________ is the set of possible values for a given attribute. - ✔✔domain
The Crow's Foot notation easily identifies multivalued attributes. - ✔✔FALSE
In Chen notation, there is no way to represent cardinality. - ✔✔FALSE
Knowing the minimum and maximum number of ___________ occurrences is very helpful at the
application software level. - ✔✔entity
Connectivities and cardinalities are established by concise statements known as business rules. -
✔✔TRUE
A composite identifier is a primary key composed of more than one attribute. - ✔✔TRUE
An entity in the entity relationship model corresponds to a table in the relational environment. -
✔✔TRUE
In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the
entity's name. - ✔✔TRUE
RATED A+
Unary relationships are common in manufacturing industries. - ✔✔TRUE
_________________ not only helps database designers to stay on track during the design process, it
also enables them to pick up the design thread when the time comes to modify the design. -
✔✔Documentation
Ideally, an entity identifier is composed of _____ attribute(s). - ✔✔one
The first step in building an entity-relationship diagram (ERD) is
___________________________________________________________. - ✔✔creating a detailed
narrative of the organization's description of operations
A ________ entity has a primary key that is partially or totally derived from the parent entity in the
relationship. - ✔✔weak
The decision to store ____________ attributes in database tables depends on the processing
requirements and the constraints placed on a particular application. - ✔✔derived
In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side
must be loaded first. - ✔✔TRUE
To implement a small database, a database designer must know the "1" and the "M" sides of each
relationship and whether the relationships are mandatory or optional. - ✔✔TRUE
A _________ attribute is one that cannot be subdivided. - ✔✔simple
Complex ____________ requirements may dictate data transformations, and they may expand the
number of entities and attributes within the design. - ✔✔information
, A weak entity must be ______________ dependent. - ✔✔existence
The entity relationship diagram (ERD) represents the ______________ database as viewed by the
end user. - ✔✔conceptual
In the original Chen notation, each attribute is represented by an oval with the attribute name
connected to an entity rectangle with a line. - ✔✔TRUE
In Crow's Foot notation, an optional relationship between entities is shown by drawing a
__________________ on the side of the optional entity. - ✔✔small circle
An entity is said to be ______________-dependent if it can exist in the database only when it is
associated with another related entity occurrence. - ✔✔existence
A(n) ___________ is the set of possible values for a given attribute. - ✔✔domain
The Crow's Foot notation easily identifies multivalued attributes. - ✔✔FALSE
In Chen notation, there is no way to represent cardinality. - ✔✔FALSE
Knowing the minimum and maximum number of ___________ occurrences is very helpful at the
application software level. - ✔✔entity
Connectivities and cardinalities are established by concise statements known as business rules. -
✔✔TRUE
A composite identifier is a primary key composed of more than one attribute. - ✔✔TRUE
An entity in the entity relationship model corresponds to a table in the relational environment. -
✔✔TRUE
In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the
entity's name. - ✔✔TRUE
