This class was created by Brainscape user Jason Swift. Visit their profile to learn more about the creator.
By:
Jason Swift
- decks
- flashcards
- learners
Decks in this class (15)
Introduction
Define a database,
Define a dbms,
Database application
14
cards
DBMS
What is the role of the dbms,
What are the 7 advantages of the ...,
What are the 10 functions of the ...
4
cards
3 Level Architecture
What are the 2 main reasons for t...,
Define data abstraction,
Define data independence
13
cards
Entity Relationship Model
What is the er model,
Why do we need an er model,
What are the 2 categories of enti...
18
cards
Converting ER to Relational Model
How to we transform a 1 relationship,
Convert 1 1 mandatory mandatory t...,
Convert 1 1 optional mandatory to...
12
cards
Relational Model
When is the relational model created,
What do the columns and rows defi...,
What is the cardinality and degre...
12
cards
Normalisation and Functional Dependancies
Define normalisation,
List some benefits that normalisa...,
What are the 3 main characteristi...
9
cards
Relational Algebra
What is relational algebra,
How does relational algebra enabl...,
What are the 3 main types of rela...
6
cards
Physical Databases
Define the purpose of the physica...,
What is meant by physical databas...,
What are the pre requesites for t...
8
cards
Transaction Management
What is a transaction,
What is the purpose of transactio...,
What is the acronym for the 4 tra...
9
cards
Backup and Recovery
What are the 3 storage structures...,
What is a checkpoint what operati...,
What happens when a failure occurs
13
cards
Concurrency Control Protocols
What is a concurrency control pro...,
What are the 2 techniques of conc...,
What is mean by locking which con...
12
cards
Database Security
Define database security,
Who has most control in enforcing...,
What are the 2 types of access co...
7
cards
Distributed Databases
What is a distributed dataase,
What are the 2 desirable properti...,
What are the 2 types of distribut...
5
cards
Data Warehouse
Define a data warehouse,
What are the 4 key features of a ...,
Define the architecture of the da...
3
cards
More about
Databases
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Jason Swift's Databases 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?
DATABASE SYSTEMS
- 14 decks
- 231 flashcards
- 4 learners
Decks:
Introduction To Databases, Introduction To Databases Ansi Sparc, Introduction To The Relational Model, And more!
Database
- 8 decks
- 78 flashcards
- 7 learners
Decks:
T Sql Denormalisering Og Redundans, Terminologi, Performance, And more!
