Lecture 1: Introduction to BI & DM Flashcards
What is data management?
Managing data as a valuable resource.
What is Business Intelligence?
Transforming data into meaningful information/knowledge to support business decision making.
What is data?
Elementary descriptions of things, events and activities.
What is information?
Organized data that has meaning and value.
What is knowledge?
Processed data or information that is applicable to business decision problems.
Which four methods of Business Intelligence are there?
- Prescriptive
- Diagnostic
- Predictive
- Descriptive
What is the objective of Business Intelligence?
To provide historical, current and predictive views of business operations.
What is a database?
Composed of objects and operations.
Where does a database system consist of?
Collection of related tables.
- Data
- Software
- Hardware
- Users
What is a DBMS?
Software that controls the data.
What is a table?
Structured list of data of a specific type.
What does a relational database allow?
Group data into tables.
Set relationships between tables.
What is a primary key?
Unique identifier for each record of a table.
What is a super key?
Potential primary key.
What is a foreign key?
Attribute whose value matches primary key.
