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

Decks in this class (18)

L1: Principles of Database Systems
Major disadvantages of a traditio...,
Database consistency,
Atomicity
15  cards
L2: Entity-Relationship Model
Benefits of usingsubclasses in e ...,
E r diagram types of constraints,
Converting e r diagramsinto relat...
5  cards
L3: SQL Basics
How to avoidtuple variable ambigu...,
What is tuple variable ambiguity,
Sql joining two tables
42  cards
L4: Entity-Relation Design
Database design process specific ...,
Database design process requireme...,
Database design process conceptua...
22  cards
CH 1: Introduction
Physical data independence,
Definition instance of a database,
Levels of data abstraction
21  cards
Ch 2: Intro to the Relational Model
True or false no two tuples in a ...,
How seperate tablescan be related,
Relation schema
10  cards
Ch 3: Intro to SQL
3 basic integrity constraints tha...,
Important parts featuresof the sq...,
Sql features data definition lang...
17  cards
L5/6: Database Design Theory
What is design theory about,
What arearmstrongs 4 rulesused for,
Armstrongs rules names only
42  cards
L7: Modifying Databases
Database insertions multiple tupl...,
Database insertions general form,
Database deletions general form
23  cards
L8: Relational Algebra
6 basic relational algebra operators,
Why is relational algebra useful,
Considerations inrelational algeb...
19  cards
L9: Transactions
Transactions in sql,
Two schemas for preventing deadlock,
Preventing deadlock wait die scheme
47  cards
UML for Database Design(2019)
Uml for database designoverview,
Uml for database design associations,
Uml for database design associati...
7  cards
Query Processing (2019)
Query processing basic steps,
Query processing diagram of the b...,
Query processing steps query
31  cards
L15:Query Optimization(2019)
Evaluation plan,
Cost based query optimization ste...,
Query costs factors
26  cards
L11: Indexing (2019)
Input output operations costs of ...,
Dbms buffer basic idea,
Dbms buffer buffer manager
17  cards
Physical Storage(2020)
Data storage major topics,
Physical storage storage levels,
Primary storage devices
42  cards
Information Retrieval
Information retrieval systems ove...,
Information retrieval systems dif...,
Information retrieval systems que...
48  cards
Advanced SQL
Advanced sql topics,
Views overview,
Views common uses
19  cards

More about
Database Systems

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Emma Kelley'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?

Database Systems
  • 9 decks
  • 110 flashcards
  • 3 learners
Decks: Lecture 1, Lecture 2, Lecture 3, And more!
Databases
  • 7 decks
  • 250 flashcards
  • 16 learners
Decks: 1 Introduction To Databases Information, 2 Data Modeling, 3 The Realational Database Model, And more!
Make Flashcards