WGU C175 Data Management Foundation Complete Questions And Answers 2023

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 column of one or more values. data encryption When data is encrypted, it is changed, bit by bit or character by character, into a form that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to be of use. Data normalization Is a methodology for organizing attributes into tables so that redundancy among the non-key attributes is eliminated. Data volatility Describes how often stored data is updated