WGU C175 Data Management Foundation Questions and Answers 100% Pass

Document Content and Description Below

WGU C175 Data Management Foundation Questions and Answers 100% Pass Associative Entity ✔✔An associative entity is an element of the entity-relationship model. All relationships for the associa... tive 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. Data Volume Assessment ✔✔Understanding of how much data will be in a database or a table within a database Database ✔✔A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. DCL ✔✔Data control language is used to control access to data stored in a database. DDL ✔✔Data definition language - involves instructing the DBMS software on what tables will be in the database, what attributes will be in the tables, which attributes will be indexed, and so forth. Definer ✔✔Definer is a MySQL term where AuthID i [Show More]

Last updated: 2 years ago

Preview 1 out of 8 pages

Buy Now

Instant download

We Accept: