Question1. (TCO B) Maximum cardinality refers to _____.the most instances of one entity class that can be involved in a relationship with one instance of another entity classthe maximum number of entity classes involved in a relationshipwhether or not an instance of one entity class is required to be related to an instance of another entity classwhether or not an entity is a weak entityNone of the aboveQuestion 2. (TCO B) The characteristics of a thing are described by its _____.identifiersentitiesobjectsattributesrelationshipsQuestion 3. (TCO C) The identifier of the entity becomes the _____ of the corresponding table.A. primary keyB. foreign keyC. supertypeD. subtypeBoth A and BQuestion 4. (TCO C) In a relational database design, all relationships are expressed by _____.creating a primary keycreating a foreign keycreating a supertypecreating a subtypecreating a line between entitiesQuestion 5. (TCO C) In relational database design, ID-dependent entities are used to _____.represent N:M relationshipshandle associative relationshipshandle multivalued attributeshandle archetype/instance relationshipsAll of the aboveQuestion 6. (TCO B) Match the following terms to their definitions.Potential Matches:1 : something that the users want to track in their environment2 : an entity whose identifier includes the identifier of another entity3 : describes characteristic of an entity4 : an entity whose existence depends on the presence of another entity but whose identifier does not include the identifier of the other entity5 : an entity that holds specialized attributes that distinguish it from one or more other similar entitiesAnswer: ID-dependent entity: Subtype: Weak entity: Attribute: EntityQuestion 7. (TCO C) How would you represent a one-to-many strong entity relationship in a physical relational database design?
Academicgurus.net is meant to assist students throughout their academic life by providing educational and sample writing materials. All products created by academicgurus.net are model assignments that can be used to prepare one’s own individual research. If customers opt to pass any of our products as their own, they do it at their own risk.
Payment & Security
+1 (940) 905-5542