Data Management Foundation C175 WGU
Associative Entity - Answer - An associative entity is an element of the entity-relationship model. All relationships for the associative entity should be many. Attribute - Answer - An attribute is a property or characteristic of an entity. Binary relationship - Answer - A binary relationship is a relationship between two entity types. Candidate Key - Answer - Is any column or a combination of columns that can qualify as unique key in database. Cardinality - Answer - Cardinality represents the maximum number of entities that can be involved in a particular relationship. Cartesian product - Answer - 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 - Answer - Will delete all records that reference the primary key column subquery - Answer - Returns a single column of one or more values. data encryption - Answer - 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 i
Document information
- Uploaded on
- November 11, 2022
- Number of pages
- 6
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
