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

Decks in this class (13)

Week 1
What are the three components of ...,
What is conceptual design concern...,
What is logical design concerned ...
23  cards
Week 2
What is a relational data model,
What is a table in a relational d...,
What is a tuple in a relational d...
20  cards
Week 1 Revision
What were used before databases,
What were some disadvantages of f...,
What is a database system
67  cards
Week 2 Revision
What is inheritance,
What are some benefits of inherit...,
What does the completeness constr...
59  cards
Week 3
What does a weak entity set reduc...,
How is a many to many relationshi...,
How are many to one and one to ma...
31  cards
Week 4
What does normalisation do,
Describe normalisation,
What does it mean for a decomposi...
20  cards
Week 5
What is an aggregate function,
What are the six aggregate functions,
Are nulls counted in count
31  cards
Week 6
What does date store,
What does time store,
What does datetime store
46  cards
Database Querying
What are the typical steps in the...,
What does a statement represent i...,
What are the three sql statements...
12  cards
Data Storage
Describe features of primary storage,
What does primary storage hold,
Describe features of secondary st...
44  cards
Indexing
What are the two methods for redu...,
Describe the basic overview of in...,
What is the search key
87  cards
Query Processing
What are the three basic steps in...,
What happens at the parser and tr...,
What happens at the optimiser sta...
32  cards
Transactions and Recovery
What does acid stand for,
Describe atomicity,
Describe consistency
97  cards

More about
CS3101

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Megan Briers's CS3101 flashcards for their University of St Andrews 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.

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?

CS3101 - Databases
  • 6 decks
  • 44 flashcards
  • 1 learners
Decks: File Organisation, Transactions, Hashing, And more!
CS3101
  • 4 decks
  • 65 flashcards
  • 1 learners
Decks: 1 Introduction, 2 Introduction To The Relational Model, 3 Formal Relational Query Languages, And more!
CS3101
  • 6 decks
  • 84 flashcards
  • 2 learners
Decks: Functional Dependencies, Normalisation, Transactions, And more!
Make Flashcards