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

Decks in this class (15)

Module 01a - History
What is data processing 1,
What is data 2,
What is attribute 3
12  cards
Module 01b - Components of a Database System
What are the components of a data...,
What are applications as a db com...,
What is a dbms 3
9  cards
Module 02a - Introduction to SQL
What is business intelligence 1,
What s a ad hoc query 2,
How the sql statements are divided 3
8  cards
Module 02b - Basic SQL - Part I/II
Select statement 1,
How to eliminate duplicates 2,
Which are the the characteristics...
13  cards
Module 02b - Basic SQL - Part II/II
What are subqueries 1,
What is the syntax of a subquery ...,
How to connect two or more tables 3
11  cards
Test 1 - Module 1
What s the definition of database 1,
What s the purpose of database 2,
Who s the creator of relational m...
15  cards
Test 1 - Module 2
Ad hoc queries 1,
Components of a data warehouse 2,
Sql 3
22  cards
Module 03a - Dependencies
Define entity 1,
Define relation 2,
Define functional dependency 3
17  cards
Module 03b - Normalization
Insertion anomalies 1,
Update anomaly 2,
Deletion anomaly 3
12  cards
Module 04 - Data Modeling
Accessing table structures 1,
Count rows 2,
Examing columns acessing table st...
13  cards
Module 05a - Relationship and Cardinality
Data model vs db design 1,
Data model conceptual design 2,
Er model 3
21  cards
Module 05b - Relationships and Patterns in ER Model
Solid line vs dashed line 1,
Strong entity vs weak entity 2,
Weak entities 3
11  cards
Module 06a - Creating Tables
Database design 1,
Three design stages 2,
Steps for transforming a 3
13  cards
Module 06b - Creating Relationships
1 1 strong entity relationships 1,
1 n strong entity relationships 2,
N m strong entity relationships 3
7  cards
Module 06c - More Constraints
Representing ternary and higher o...,
Design for minimum cardinality 2,
O o minimum cardinality 3
14  cards

More about
Database Systems

  • Class purpose General learning

Learn faster with Brainscape on your web, iPhone, or Android device. Study Daniel Fernandes's Database Systems flashcards for their Stockton University 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?

Database Systems
  • 18 decks
  • 453 flashcards
  • 25 learners
Decks: L1 Principles Of Database Systems, L2 Entity Relationship Model, L3 Sql Basics, And more!
6. Databases
  • 11 decks
  • 1138 flashcards
  • 511 learners
Decks: Cis275 Chapter 1 Introduction To Databas, Cis275 Chapter 2 Relational Databases, Cis275 Chapter 3 Database Design, And more!
Make Flashcards