Exam (elaborations)
Data Management Foundations WGU C175|260 Questions and Answers
Data Management Foundations WGU C175|260 Questions and Answers
[Show more]
Content preview
Data Management Foundation C175WGU/84 Complete Questions and
Answers
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.
-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 is the same for another
DBMS
-Denormalization - -The act of duplicating data in a database for
performance or the preservation of historical information
-disaster recovery - -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 - -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 - -An E-R model is a data model for describing a database in an
abstract way.
-embedded mode - -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 - -An entity is an object or event in our environment that we want to
keep track of.
-Foreign Key - -Is a field (or collection of fields) in one table that uniquely
identifies a row of another table.
-Index - -Used to help a DBMS find data quickly
-Inner Join - -Shows row that have matches in both tables
-Intersection Data - -Intersection Data associated with the concatenation of
two segments.
-Join - -Joins 2 tables together
-logical view - -Is a mapping onto a physical table or tables that allows an
end user to access only a specified portion of data.
-Modality - -Modality represents the minimum number of entity occurrences
that can be involved in a relationship.
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 Victorious23. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £10.10. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81113 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