Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database Systems

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

By: Ross Worton
Start Studying

Decks in this class (14)

Mock Exam
What does the having clause do,
What does the select line do,
What does the from clause do
26  cards
The Relational Model
Describe an entity,
Give some examples of entities,
Describe an attribute
18  cards
Lecture 1 - SQL Introduction
What does acid stand for,
What does sql stand for,
What does dml stand for
6  cards
SQL Functions
What is an aggregating function,
Name the aggregating functions,
What does the order by function do
10  cards
ER Diagrams
What does a foreign key correspon...,
What end of a relationship is the...
2  cards
Joins
What does a left join do,
What does an equi join do,
What does a theta join do
5  cards
SQL Summary
What are wildcards
1  cards
Normalisation
State 3 ways redundancies can be ...,
What would insertion anomalies co...,
What would deletion anomalies con...
12  cards
Database Design
What are the purposes of a contro...,
What are the three stages of data...,
What are the results of conceptua...
6  cards
Data Definition Language
What is the purpose of data defin...,
What is the purpose of data manip...,
What is the purpose of data contr...
5  cards
Database Administration
What is the role of a database ad...,
What is an example of a deliberat...,
What is an example of an accident...
21  cards
Transactions and Concurrency
What are transactions in terms of...,
What does rollback do,
What does commit do
15  cards
Optimisation
What is a database index,
What are indexes used for,
What is an ordered binary tree
5  cards
No SQL
What are key value stores,
What are column stores,
What are document stores
12  cards

More about
Database Systems

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Ross Worton's Database Systems flashcards for their Edinburgh Napier class 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.

Learn more about spaced repetition

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?

Database Systems
  • 9 decks
  • 110 flashcards
  • 3 learners
Decks: Lecture 1, Lecture 2, Lecture 3, And more!
DATABASE SYSTEMS
  • 14 decks
  • 231 flashcards
  • 4 learners
Decks: Introduction To Databases, Introduction To Databases Ansi Sparc, Introduction To The Relational Model, And more!
Find Flashcards
Make Flashcards
Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions