Loading
Notes
Study Reminders
Support
Text Version

Database Management Systems - Lesson Summary

Set your study reminders

We will email you at these times to remind you to study.
  • Monday

    -

    7am

    +

    Tuesday

    -

    7am

    +

    Wednesday

    -

    7am

    +

    Thursday

    -

    7am

    +

    Friday

    -

    7am

    +

    Saturday

    -

    7am

    +

    Sunday

    -

    7am

    +

The key points from this module are:
The smallest unit of data a computer can handle is called a bit.
A database is a collection of data organized to serve multiple applications by centralizing data and controlling redundant data.
The Relational Database Management System represents data as two-dimensional tables known as relations.
The three basic operations of a relational DBMS are:
SelectJoinProject
An Entity-Relationship Model consists of data entities, relationships between these entities, and attributes that describe the entities and relationships.
The three steps involved in the creation of a data warehouse are:
Extraction of data from transactional tablesRemoval of un-wanted data typesData loaded into tables in the data warehouse
A Data Mart is a subset of a data warehouse with a summarized or highly focused portion of a firm’s data for use by a specific population of users.
Business Intelligence consists of tools for consolidating, analysing, and providing access to vast amounts of data to help users make better business decisions.
Knowledge Discovery in Databases (KDD) is the non-trivial process of identifying valid, potentially useful, understandable, and actionable patterns in data.