This class was created by Brainscape user Chered Herry. Visit their profile to learn more about the creator.
By:
Chered Herry
- decks
- flashcards
- learners
Decks in this class (14)
Lecture 1: Introduction
What is a database,
Explain what a file based limitat...,
So list advantages of using db
22
cards
Lecture 2: Entity Relationship Modelling
List four concepts of the er model,
Why is conceptual design important,
What are the types of er represen...
21
cards
Lecture 3: Relational Model
Explain what a relational model is,
So what is a relation,
What is an attribute
14
cards
Lecture 4: Normalisation
What is normalisation,
Quick revision what is a relation...,
Before considering normalisation ...
15
cards
Lecture 0: Introduction to Database
What is a metadata,
What is a dbms,
What is a database application pr...
31
cards
Lecture 3B: Relational Model
What is another name for relation...,
Describe facts for the relational...,
Quickly list the db design from t...
26
cards
Lecture 4B: Normalisation
What is normalisation,
List relational keys,
Quickly describe each relational key
24
cards
Lecture 5: Database Design Review
List the three database design,
Quick explanation of conceptual d...,
Quick explanation of logical data...
10
cards
Lecture 6: SQL - DDL, DML
What is sql,
Ddl,
Dml
19
cards
Lecture 7: SQL + RA
Explain the use of the select com...,
Write recite the select command g...,
What is the purpose of distinct
24
cards
Lecture 8: SQL Select Part 2 and RA
Explain aggregate functions,
List the aggregate functions,
Which two aggregate functions are...
24
cards
Lecture 9: SQL SELECT PART 3 & RA
Example of cartesian product query,
What are multi table queries,
Eg of three table join
11
cards
Lecture 10: SQL Data Control Language Commands Revision
What is data control language com...,
List all object privileges,
Why are insert and update special
15
cards
Introduction, Transactions, Concurrency Control and Recovery
What are database transactions,
What is a query,
What is a update
29
cards
More about
IAB130
- Class purpose General learning
Learn faster with Brainscape on your web, iPhone, or Android device. Study Chered Herry's IAB130 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....
