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 Daniel Fernandes. Visit their profile to learn more about the creator.

By: Daniel Fernandes
Start Studying

Decks in this class (15)

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

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