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 item...,
What does dbms stand for 2,
A dbms ______ and manages databas...
12
cards
DB History and Intro to Relational Data Model
In a _____ _____ system the struc...,
In _____ codd introduced the rela...,
In 1970 _____ introduced 2 db que...
38
cards
Entity Relationship Model
The ______ _______ model is a not...,
The er model is a high level ____...,
A db design is called a er ______ 3
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 2,
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 2,
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 1,
What do the keywords not null do 2,
What do the keywords primary key ...
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 1,
Null are the main source of _____...,
What are four meanings of null 3
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 displ...
30
cards
Query Processing
A system catalog stores _________ 1,
What is metadata 2,
Metadata and statistics about the...
19
cards
Query Optimization
Query optimization is conducted b...,
What is a query plan 2,
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?
AT 354
- 12 decks
- 763 flashcards
- 6 learners
Decks:
At 354 General Limitations, Electrical Systems, Mws Ox Lights, And more!
MRKT 354
- 12 decks
- 406 flashcards
- 3 learners
Decks:
Markstrat Quiz, Chapter 1 Customer Focus Customer Perfor, Chapter 2 15 Marketing Metrics And Marke, And more!
HS 354
- 8 decks
- 567 flashcards
- 16 learners
Decks:
Competency 8 Knowledge Check, Competency 9 Knowledge Check, Competency 10 Knowledge Check, And more!
BU 354
- 11 decks
- 1102 flashcards
- 5 learners
Decks:
Chp 3 Hr Planning, Chp 1 Strategic Hrm, Job Offer Negotiation, And more!
