C175 Data Management Foundations

This class was created by Brainscape user John Herring. Visit their profile to learn more about the creator.

Decks in this class (29)

PA and OA set
Organization of data for the purp...,
____ is the the result of process...,
______ is the result of revealing...
273  cards
Lesson 1
Database,
Data management,
What are the two types of data in...
135  cards
Lesson 2
Data modeling,
Problem domain,
Data model
124  cards
Lesson 3
Domain,
Key,
What are the types of keys
75  cards
Lesson 4 Database Design
Binary relationship,
Cardinality,
Composite attribute
182  cards
My Addition
What is data,
What are the types of data based ...,
How can data be represented
274  cards
Common operators
4 3,
2,
11 5
16  cards
Common MySQL data types.
Category characterexample strings...,
Category characterexample strings...,
Category characterexample strings...
14  cards
My Addition
In refernce of alter table statem...,
In refernce of alter table statem...,
In refernce of alter table statem...
97  cards
Lesson 2.8 To 3
What is the update syntax,
What is the update syntax,
What would the result be update e...
97  cards
Section 2.12 Constraints
What is a constraint in the conte...,
What is the syntax for creating a...,
How do you define a foreign key c...
25  cards
3.1: Special operators and clauses
What is the purpose of the in ope...,
Give an example of a query using ...,
What does the between operator do...
34  cards
3 Complex Queries
What sql command is used to retri...,
How can you filter records in a s...,
What does the percentage symbol r...
60  cards
3.3 Aggregate functions
What is an aggregate function,
How does a select statement use a...,
What does the count function do
26  cards
3.4 Join queries
What is a join in relational data...,
When writing a join query how are...,
In a join where duplicates exist ...
32  cards
3.5 Equijoins, self-joins, and cross-joins
What is the result of the followi...,
What is the result of the followi...,
Which join type is the following ...
48  cards
3.6 Sub Queries
What can be said about this subquery,
Which query executes first,
What would this result in
40  cards
3.8 View
Refer to the following create vie...,
Refer to the following create vie...,
Refer to the following create vie...
30  cards
3.9 Relational Algebra
What is the equivalent of a relat...,
What operation does the symbol re...,
What operation does the symbol re...
81  cards
Lesson 6
Alias,
Alter table,
And
86  cards
Chapter 4 Database Design
What is the purpose of the entity...,
In an airline reservation system ...,
What would 1 2 represent
144  cards
Lesson 5
Atomic attribute,
Atomicity,
Boyce codd normal form bcnf
127  cards
Chapter 5 Data Storage
What is transfer rate,
What is cost in terms of storage ...,
What does capacity refer to
45  cards
Chapter 6 Database Architecture
What are the components of mysql ...,
What are the four layers of mysql...,
What is the tools layer in mysql ...
215  cards
Chapter 8 MySQL Workbench
What do the terms crud operations...,
Fill in the blank dcl focuses on ...,
What is the relationship between ...
43  cards
Chapter 9 Data Modeling
What is a binary relationship,
What is an example of a database ...,
What does cardinality refer to in...
35  cards
Lesson 7
Business intelligence bi,
Cube cache,
Dashboards
46  cards
MySQL
What connection method is used fo...,
What is the default host name for...,
What is the default port number f...
80  cards
ZY Labs
The horse table has the following...,
The database has three tables for...,
Write a select statement to creat...
3  cards

More about
C175 Data Management Foundations

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study John Herring's C175 Data Management Foundations flashcards for their WGU class now!

How studying works.

Brainscape's adaptive web mobile flashcards system will drill you on your weaknesses, using a pattern guaranteed to help you learn more in less time.

Add your own flashcards.

Either request "Edit" access from the author, or make a copy of the class to edit as your own. And you can always create a totally new class of your own too!

What's Brainscape anyway?

Brainscape is a digital flashcards platform where you can find, create, share, and study any subject on the planet.

We use an adaptive study algorithm that is proven to help you learn faster and remember longer....

Looking for something else?

Data Management & Business Intelligence
  • 30 decks
  • 570 flashcards
  • 85 learners
Decks: Rob Coronell Chapter 1, Rob Coronell Chapter 2, Rob Coronell Chapter 31 32, And more!
Data Management Foundations C175
  • 7 decks
  • 613 flashcards
  • 30 learners
Decks: Lesson 1, Lesson 2, Lesson 3, And more!
IJ DATA 2
  • 13 decks
  • 2305 flashcards
  • 36 learners
Decks: Written 2, Written 6, Written 5, And more!
Foundations of Nursing
  • 22 decks
  • 1684 flashcards
  • 149 learners
Decks: Lab, Professional Nursing, Asepsis And Infection Control, And more!
Make Flashcards