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

Decks in this class (12)

Diagram characteristics(custom)
What is this relationship cardina...,
What is this relationship cardina...,
What is this relationship cardina...
11  cards
2. modelling
What is a model in data modeling 1,
What are business rules 2,
What characteristics define a goo...
17  cards
1. intro to DB
What is a database 1,
Define data 2,
Define metadata 3
13  cards
3. Enhanced ERD
What is an enhanced er model 1,
What is a subtype in database mod...,
What is a supertype in database m...
12  cards
4. SQL and DML
What is a relational table 1,
What are the two main operations ...,
What does the distinct keyword do...
20  cards
midterm 2 flashcards
What is a relation in the relatio...,
What are the key properties of a ...,
What is the difference between an...
27  cards
subqueries_flashcards
What is a subquery 1,
Where can subqueries be used 2,
What is a scalar subquery 3
9  cards
triggers_procedures_flashcards
What is a stored procedure 1,
What is a trigger 2,
When do triggers execute 3
8  cards
views_flashcards
What is a view in sql 1,
How do you create a view in sql 2,
Can a view be used in queries lik...
8  cards
transactions_flashcards
What does acid stand for in datab...,
What is atomicity in the context ...,
What is consistency in the contex...
10  cards
weaknesses from midterm 1
The _______ is a constraint on th...,
What are three 3 rules that a dat...,
Fill in the blanks conceptual des...
12  cards
weaknesses from midterm 2
When does an inner join occur 1,
What happens to an inner join whe...,
Do every single table in the rela...
8  cards

More about
COMP 2521

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Rhys Barker's COMP 2521 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?

Comps
  • 24 decks
  • 643 flashcards
  • 99 learners
Decks: Triploidy, Chromosomes, Lysosomal Storage Disorders, And more!
comps
  • 33 decks
  • 1100 flashcards
  • 4 learners
Decks: Part 1 Phonetics And Typical Development, Part 2 Evaluating Speech Sound Disorders, Part 3 Treatment Of Speech Sound Disorde, And more!
Make Flashcards