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

Decks in this class (19)

ER Diagram
What does a straight line represe...,
What does a double line signify i...,
What shape represents a relations...
13  cards
Database Definitions
What is a database 1,
What is a database management sys...,
What constitutes a database system 3
21  cards
Relational Algebra
What does the union operator do i...,
What is the purpose of the inters...,
What does the difference operator...
10  cards
SQL Queries
What does the result of an inner ...,
What does a left join return 2,
What does a right join return 3
5  cards
Functional Dependencies
What is a functional dependency 1,
Minimal covers a set of fds is mi...
2  cards
Keys
What is a candidate key 1,
When should you stop searching fo...,
What is the reflexivity rule in a...
16  cards
File Format
What is the fixed length record f...,
What is the variable length recor...,
What is the pointer format 3
6  cards
Indexing
What is a primary index 1,
What is a secondary index 2,
What is the purpose of an index i...
8  cards
Decomposition
What is first normal form 1nf 1,
What are the criteria for a relat...,
What defines a relation schema in...
5  cards
Precedence Graph
What defines a schedule as not co...,
What is a precedence graph 2,
When should an arrow not be drawn...
6  cards
Conflicting Transactions
What does atomicity in acid trans...,
What is meant by consistency in t...,
Define isolation in acid transact...
5  cards
Concurrency Control
What do concurrency control techn...,
What does a lock table describe 2,
What is a deadlock 3
8  cards
2-Phase Locking
What is strict 2pl two phase lock...,
What are the phases of strict 2pl 2,
What is a potential issue with st...
7  cards
Online Analytical Processing
What is relational online analyti...,
What are the characteristics of m...,
What is hybrid online analytical ...
8  cards
Star Schema
What is the star schema suited for 1,
What are the advantages of the st...,
What does the fact table in a sta...
9  cards
Embedded SQL
What is the difference between dy...,
What is sql injection 2,
Why is sql injection considered d...
6  cards
NoSQL
What does nosql stand for 1,
What is nosql an umbrella term for 2,
Name the four main types of nosql...
12  cards
B+ Trees
How does a b tree maintain balance 1,
Why is maintaining balance in a b...,
What is the time complexity for s...
5  cards

More about
FU DBS II

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Jimothy Todd's FU DBS II flashcards 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?

dbs
  • 9 decks
  • 191 flashcards
  • 191 learners
Decks: Ch1, Ch2, Ch3, And more!
DBS
  • 12 decks
  • 148 flashcards
  • 2 learners
Decks: 1 145 Query Evaluation, 146 208 Cost Estimation, 209 293 Query Optimization, And more!
DBS Phase 1
  • 6 decks
  • 208 flashcards
  • 1 learners
Decks: Phase 1 Dbs Training, Neuroanatomy, Procedure Training, And more!
DBS
  • 2 decks
  • 85 flashcards
  • 1 learners
Decks: Dbs1, Dbs 2, And more!