This class was created by Brainscape user Jennifer Petrie. Visit their profile to learn more about the creator.
By:
Jennifer Petrie
- decks
- flashcards
- learners
Decks in this class (16)
Lecture 1- Introduction to Database
What is a database,
What are the two parts of databases,
What is a database management sys...
26
cards
Lecture 2- Relational Data Model
Why do you need a data model,
What are the three layers in a da...,
What is the physical level of a d...
31
cards
Lesson 3- Relational Model Key Constraints
What are keys used for,
Keys help,
What is a super key
21
cards
Lecture 4- Entity Relations Model
Describe the database design process,
What are the three things that de...,
What is an entity
32
cards
Lecture 5- Relational Algebra
What are the three variants of re...,
What is algebra,
What are two parts of relational ...
38
cards
Lecture 6- SQL Basics
What are some features of sql,
What is part of the data definiti...,
What is part of the data update c...
47
cards
Lecture 7- Aggregation and Grouping
What is an aggregate,
What are the five standard built ...,
Describe these operations on sets...
21
cards
Lecture 9- Other Features and Commands
What type of query is this,
What type of query is this,
What type of query is this r a1 an
51
cards
Lecture 10- Physical Storage
What is the external level,
Storage classification based on,
What is primary secondary and ter...
18
cards
Lecture 11- Intro to NoSQL
What do nosql databases provide,
Nosql capabilities support,
What are the four main types cate...
7
cards
Lecture 12- MongoDB
What is a non relational database,
Describe the document model,
What is a document
47
cards
Lecture 13- Data Organization on Files
Magnetic disks and ssds are,
What are some assumptions of file...,
What are the different types of f...
4
cards
Lecture 14- Tree Structured Indexes
0
cards
Lecture 15- Hashing
0
cards
Lecture 16- Schema Refinement and Normalization
0
cards
More about
CMPUT 291
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Jennifer Petrie's CMPUT 291 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....
