UOFG_DATABASE_SYSTEMS

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

Decks in this class (14)

Lecture 1 - Contextual Database
What does a database hold,
What do we need to be able to do ...,
What is the fundamental functiona...
15  cards
Lecture 1 - Relational Model
Any entity and any relationship a...,
What does a 2d table in a relatio...,
What is a query
12  cards
Lecture 1 - Relational Constraints
What are relational constraints,
How many fundamental constraints ...,
What are the 3 fundamental constr...
13  cards
Lecture 2 - Relational Schema Good Or Bad
What performance metrics may we l...,
Guidelines for good design of a r...,
Explain what is meant by the firs...
7  cards
Lecture 2 - Functional Dependency
What is functional dependency,
What is functional dependency in ...,
Notation for functional dependenc...
13  cards
Lecture 2 - Normalisation Basics
What is another name for normaliz...,
What is the degree of normalization,
What degrees of normalization do ...
18  cards
Lecture 3 - SQL CREATE
What type of language is sql,
Statement for creating a schema i...,
Each statement ends with a what i...
15  cards
Lecture 3 - SQL SELECT
Select statement in sql,
Select statement with join select,
Can tables be treated as variable...
9  cards
Lecture 3 - 3-valued SQL and NULL
What is the three valued logic of...,
What is the principle of null values,
What do we need to adopt to compa...
8  cards
Lecture 3 - Nested Queries
What is a nested inner query,
What are the two types of nested ...,
What is in
12  cards
Lecture 4 - Joins
What is an inner join,
What is equijoin,
Example of inner equi join
11  cards
Lecture 4 - Aggregate Functions
What are aggregate functions,
Examples of aggregate functions,
What is special about count x
5  cards
Lecture 4 - Groupings
The process of grouping is,
What is the statement that can be...,
Example of grouping by departemen...
10  cards
Lecture 4 - Having
What is having,
Example of having show the number...,
What is wrong with this query sel...
4  cards

More about
UOFG_DATABASE_SYSTEMS

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study michal wozniak's UOFG_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?

Make Flashcards