This class was created by Brainscape user Emma Kelley. Visit their profile to learn more about the creator.
By:
Emma Kelley
- decks
- flashcards
- learners
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?
Fundamentals of Database Systems
- 5 decks
- 71 flashcards
- 5 learners
Decks:
Database Systems, Database Models, The Relational Model, And more!
Database
- 9 decks
- 194 flashcards
- 3 learners
Decks:
Intro, Relational Dbms, Designing Databases Relationships, And more!
