Module 4

Created by

Llance Salo

Cards (23)

Data - raw facts.
2 types of Data:
Qualitative Data
Quantitative Data
Quantitative Data - is numeric, result of a measurement, count, or other mathematical calculation.
Qualitative Data - data that is descriptive.
Information - is a processed data that possess context, relevance, and purpose.
Database:
Data > Information > Knowledge > Wisdom
Big Data - refers to a massive large data set that conventional data processing technologies do not have sufficient power to analyze them.
Database - a system that can take data, allows user to put data into context, and provide tools for aggregation and analysis.
Primary key - a special field or a combination of fields that determines the unique record. Usually the unique identification number of the record.
Data Types of Database:
Text
Numbers
Boolean
Date/Time
Currency
Paragraph Text
Object
Text - a data type for storing non-numeric data that is brief, generally under 256 characters.
Numbers - a data type for storing numbers.
Boolean - a data type with only two possible values, such as 0 or 1, true or false, and yes or no.
Date/Time - data type that can interpreted as a number of a time.
Currency - a data type that formats all values with a currency indicator and two decimal places.
Paragraph Text - a data type that allows for text to be longer than 256 characters.
Object - data type that allows storage of data that cannot be entered via keyboard, such as an image or a music file.
Database Management System - a software program that allows data in the database to be stored, read, changed, added, or removed.
DBMS Packages - it provides an interface to view and change the design of the database, create queries, and develop reports.
SQL - Structured Query Language
Structured Query Language - it is the primary way to work with a relational database.
Metadata - it can be understood as "data about data".
Data Dictionary - it is created to hold the metadata, defining the fields and structure of the database.