Exam (elaborations)
Data Management Foundation C175 WGU
- Institution
- C175 - Data Management Foundations PA
Data Management Foundation C175 WGU
[Show more]
Seller
Follow
Content preview
Data Management Foundation C175 WGUAssociative Entity - ANS-An associative entity is an element of the entity-relationship
model. All relationships for the associative entity should be many.
Attribute - ANS-An attribute is a property or characteristic of an entity.
Binary relationship - ANS-A binary relationship is a relationship between two entity
types.
Candidate Key - ANS-Is any column or a combination of columns that can qualify as
unique key in database.
Cardinality - ANS-Cardinality represents the maximum number of entities that can be
involved in a particular relationship.
Cartesian product - ANS-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 - ANS-Will delete all records that reference the primary key
column subquery - ANS-Returns a single column of one or more values.
data encryption - ANS-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 - ANS-Is a methodology for organizing attributes into tables so that
redundancy among the non-key attributes is eliminated.
Data volatility - ANS-Describes how often stored data is updated.
Data Volume Assessment - ANS-Understanding of how much data will be in a database
or a table within a database
Database - ANS-A database is a collection of information that is organized so that it can
easily be accessed, managed, and updated.
, DCL - ANS-Data control language is used to control access to data stored in a
database.
DDL - ANS-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 - ANS-Definer is a MySQL term where AuthID is the same for another DBMS
Denormalization - ANS-The act of duplicating data in a database for performance or the
preservation of historical information
disaster recovery - ANS-Involves rebuilding an entire information system or significant
parts of one after a catastrophic natural disaster such as a hurricane, tornado,
earthquake, building collapse, or even a major fire.
DML - ANS-Data manipulation language refers to the four basic operations that can and
must be performed on data stored in any DBMS: data retrieval, data update, insertion of
new records, and deletion of existing records.
E-R model - ANS-An E-R model is a data model for describing a database in an
abstract way.
embedded mode - ANS-The SELECT command is embedded within the lines of a
higher-level language program and functions as an input or "read" statement for the
program.
Entity - ANS-An entity is an object or event in our environment that we want to keep
track of.
Foreign Key - ANS-Is a field (or collection of fields) in one table that uniquely identifies a
row of another table.
Index - ANS-Used to help a DBMS find data quickly
Inner Join - ANS-Shows row that have matches in both tables
Intersection Data - ANS-Intersection Data associated with the concatenation of two
segments.
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller modocko752. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £6.47. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79373 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now
