WGU C170 ER-Modeling Questions Guaranteed A+

WGU C170 ER-Modeling Questions Guaranteed 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 Brainpower Read More Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:12 / 0:15 Full screen 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 In implementation terms, an entity is existence-dependent if it has a mandatory primary key. FALSE _________________ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. Cardinality The _______ notation of entity-relationship modelling can be used for both conceptual and implementation modelling. UML A derived attribute is indicated in the Chen notation by a _______________ that connects the attribute and an entity. dashed line The concept of relationship strength is based on how the ___________________ of a related entity is defined. primary key A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity. FALSE To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent __________ relationships whenever possible. binary When indicating cardinality, the first value represents the ____________ number of associated entities. minimum