- decks
- flashcards
- learners
Decks in this class (18)
ER modeling review
The process of creating a good da...,
Data models 2,
Data models are useful in 3
56
cards
EER modeling
Taking a ________ to modeling dat...,
Enhanced er diagram 2,
Supertype 3
34
cards
Converting EER to DB
Relational data model 1,
3 components of relational data m...,
Main data structure used in relat...
54
cards
normalization
The er model provided a common la...,
T f all database tables qualify a...,
Normalization is the solution to 3
33
cards
intro to databases
Decision support system 1,
Structured problems 2,
Structured problems are not inclu...
30
cards
relational db model
Types of db models 1,
Hierarchical db model 2,
Network db model 3
16
cards
SQL part 1
Sql is a database language for 1,
T f sql is a nonprocedural langua...,
What does sql is a nonprocedural ...
34
cards
SQL part 2
2 primary command types for data ...,
Example of data retrieval query i...,
Example of dml action queries 3
30
cards
SQL part 3
Order by clause can order by 1,
T f with order by you can use col...,
Column aliases 3
25
cards
SQL part 4
Different ways to join tables 1,
Inner join aka and types 2,
Outer join types 3
21
cards
SQL part 5
Three types of outer join 1,
Outer join returns 2,
Outer join basically provides an ...
11
cards
parameterized queries
Effective decision support system...,
Decision makers may not always kn...,
B c decision makers may not know ...
19
cards
stored procedures and triggers
Stored procedure 1,
A stored procedure sproc is actua...,
Stored procedures can receive 3
21
cards
database transactions
Database transaction 1,
A database transaction may consis...,
Successful transaction 3
27
cards
concurrency control
Concurrency control 1,
Concurrency control prevents 2,
Although two transactions may be ...
36
cards
BI & Data warehouses
Business intelligence bi 1,
Bi process chain 2,
Bi term coined by 3
31
cards
data mining
T f data mining has one definition 1,
Data mining 2,
Origins of data mining 3
19
cards
Big Data and NoSQL
Assumptions of traditional bi pla...,
Predictable frequency 2,
Static sources 3
33
cards
More about
3524
- School Unspecified
- Program type Unspecified
- Course Unspecified
- Instructor Unspecified
- Standards Unspecified
The creator of this class did not yet add a description for what is included in this class.
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....
