Data Management Foundation C175 WGU Questions and Answers with Verified Solutions

Associative Entity - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - An attribute is a property or characteristic of an entity. Binary relationship - A binary relationship is a relationship between two entity types. Candidate Key - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Cardinality represents the maximum number of entities that can be involved in a particular relationship. Cartesian product - Usually the result of a missing join condition or a method of expanding the data of 1 table by the number of rows in the second table. Cascade Delete - Will delete all records that reference the primary key column subquery - Returns a single