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 ident...
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller dennisgathiru. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $9.99. You're not tied to anything after your purchase.
