This class was created by Brainscape user Emma Frost. Visit their profile to learn more about the creator.
By:
Emma Frost
- decks
- flashcards
- learners
Decks in this class (18)
L1: Principles of Database Systems
Major disadvantages of a traditio...,
Database consistency 2,
Atomicity 3
15
cards
L2: Entity-Relationship Model
Benefits of using subclasses in e...,
E r diagram types of constraints 2,
Converting e r diagrams 3
5
cards
L3: SQL Basics
How to avoid tuple variable ambig...,
What is tuple variable ambiguity 2,
Sql joining two tables 3
42
cards
L4: Entity-Relation Design
Database design process 1,
Database design process 2,
Database design process 3
22
cards
CH 1: Introduction
Physical data independence 1,
Definition instance of a database 2,
Levels of data abstraction 3
21
cards
Ch 2: Intro to the Relational Model
True or false no two tuples in a ...,
How seperate tables can be related 2,
Relation schema 3
10
cards
Ch 3: Intro to SQL
3 basic integrity constraints tha...,
Important parts features 2,
Sql features data definition lang...
17
cards
L5/6: Database Design Theory
What is design theory about 1,
What are armstrongs 4 rules used ...,
Armstrong s rules 3
42
cards
L7: Modifying Databases
Database insertions insert multip...,
Database insertions general form 2,
Database deletions general form 3
23
cards
L8: Relational Algebra
5 basic relational algebra operat...,
Why is relational algebra useful 2,
Considerations in relational alge...
19
cards
L9: Transactions
Transactions in sql basic structu...,
Two schemes approaches 2,
Preventing deadlock wait die sche...
47
cards
UML for Database Design(2019)
Uml for database design overview 1,
Uml for database design 2,
Uml for database design 3
7
cards
Query Processing (2019)
Query processing basic steps 1,
Query processing diagram of the b...,
Query processing steps 3
31
cards
L15:Query Optimization(2019)
Evaluation plan 1,
Cost based query optimization ste...,
Query costs factors 3
26
cards
L11: Indexing (2019)
Input output operations 1,
Dbms buffer basic idea 2,
Dbms buffer buffer manager 3
17
cards
Physical Storage(2020)
Data storage major topics 1,
Physical storage storage levels 2,
Primary storage devices 3
42
cards
Information Retrieval
Information retrieval systems 1,
Information retrieval systems 2,
Information retrieval systems 3
48
cards
Advanced SQL
Advanced sql topics 1,
Views overview 2,
Views common uses 3
19
cards
More about
Database Systems
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Emma Frost's Database Systems 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?
Intro to Database Systems
- 11 decks
- 569 flashcards
- 555 learners
Decks:
Chapter 1, Chapter 2, Chapter 3, And more!
6. Databases
- 11 decks
- 1138 flashcards
- 500 learners
Decks:
Cis275 Chapter 1 Introduction To Databas, Cis275 Chapter 2 Relational Databases, Cis275 Chapter 3 Database Design, And more!
