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?
https://nursewritingservices.com/wp-content/uploads/2021/07/logo-other.png 0 0 Nurse writing services https://nursewritingservices.com/wp-content/uploads/2021/07/logo-other.png Nurse writing services2021-10-29 14:24:562021-10-29 14:24:56MIS582 Week 4 quiz latest 2017 (Score 100%)
Who we are
Find the best expert for your assignment in less than 30 seconds
Our smart matching system will connect you with the perfect expert for your requirements in no time.
+1 (406) 229-6829