This class was created by Brainscape user Cloud Kanou. Visit their profile to learn more about the creator.
By:
Cloud Kanou
- decks
- flashcards
- learners
Decks in this class (16)
Introduction
A database is a _____ of data ite...,
What does dbms stand for,
A dbms ______ and manages databases
12
cards
DB History and Intro to Relational Data Model
In a ______ ______ system the str...,
In _____ codd introduced the rela...,
In 1970 ______ introduced 2 db qu...
38
cards
Entity Relationship Model
The _______ ________ model is a n...,
The er model is a high level ______,
A db design is called a er ______
27
cards
Relational Algebra
Relational algebra strikes a good...,
The 3 standard set theoretic bina...,
2 unary operations on relations i...
27
cards
Relational Calculus
First order logic is propositiona...,
A _____ variable is a variable no...,
________ queries are queries with...
25
cards
Multisets and aggregation
The multiplicity of an element de...,
______ on bags keeps duplicates,
Cartesian product on bags concate...
17
cards
Recursion and Datalog
_______ languages extend query la...,
The _______ in a datalog rule con...,
The _______ in a datalog rule con...
34
cards
Constrainsts in Databases
A ________ is a relationship amon...,
What are 5 types of constraints,
Db instances that satisfy all con...
30
cards
Normal Forms
Redundancy in a bad db means many...,
Update anomalies in a bad db mean...,
In a good db every ____ defines a...
7
cards
SQL Contraints and Triggers
What does the keyword unique do,
What do the keywords not null do,
What do the keywords primary key do
14
cards
Transactions
A __________ is a sequence of ope...,
All operation in a transaction fo...,
What are 5 states in the life cyc...
38
cards
Nulls
What is a null,
Null are the main source of _____...,
What are four meanings of null
11
cards
Certain Answers
In a codd table all nulls are rep...,
An incomplete database is a set o...,
An incomplete database represents...
13
cards
Storage and Indexing
Each table is stored on disk in a...,
A record is a memory area logical...,
What 3 things does a record display
30
cards
Query Processing
A system catalog stores _________,
What is metadata,
Metadata and statistics about the...
19
cards
Query Optimization
Query optimization is conducted b...,
What is a query plan,
The annotations in a query plan t...
7
cards
More about
CMPT 354
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Cloud Kanou's CMPT 354 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?
PSYC 354
- 7 decks
- 155 flashcards
- 2 learners
Decks:
Chapter 9 Homeostasis, Chapter 10 Biological Rhythms And Sleep, Chapter 11 Emotions Aggression And Stres, And more!
NRSG 354 - Pathophysiology
- 11 decks
- 177 flashcards
- 4 learners
Decks:
Week One Cellular Injury And Reversible, Week One Irreversible Changes Necrosis T, Week One Neoplasms Cancer Aine, And more!
