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 its original form to be of use.
Data normalization - Answer
- Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility - Answer -
Describes how often stored data is updated.
Data Volume Assessment -
Answer - Understanding of how much data will be in a database or a table within
a database
Database - Answer - A
database is a collection of information that is organized so that it can easily
be accessed, managed, and updated.
DCL - Answer - Data control
language is used to control access to data stored in a database.
DDL - Answer - 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.
Category | WGU EXAM |
Comments | 0 |
Rating | |
Sales | 0 |