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:
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.
Log in to save your progress and obtain a certificate in Alison’s free Introduction to Information Systems and Management online course
Sign up to save your progress and obtain a certificate in Alison’s free Introduction to Information Systems and Management online course
Please enter you email address and we will mail you a link to reset your password.