Refers to the organization of data as a blueprint of

______________ refers to the organization of data as a blueprint
of how the database is constructed.
________________ are ordered lists of values and are used for
grouping and organizing data. They are used in relational database
models and can be used to represent related data that belong
together, such as student records.
Cohort Modules
C724
Data Resource Management -
Module 4
relational database
OLTP
tuple
OLAP
primary key
data warehouse
diversity
database
data
schema
records
attribute
foreign key

words below
Feedback
Please Answer
Please Answer
Please Answer
Please Answer
Please Answer
Please Answer
Please Answer
Please Answer
Please Answer
BACK TO
FASTSTART TAB

Term Description
Database
Entity
Attributes
Field
Record
Table
Relationships
Primary Key
Foreign Key
Schema
Ad Hoc Reporting
Query
Type Description
Relational Database
Object-oriented Database
OLTP
Cloud-based Database
Clickstream
Levels or Tools Description
Conceptual data models
Logical data models
Physical data models
Tool: Decision Tree
Relationship Description of the visual
One and only one
None to many
One to many
Concepts Description
Purpose of Normalization
1. Key Database Terms
3. Types of Databases
OLAP & Analytical
Database
4. Principles of Database Design Entity Relationship Diagram (ERD)
5. Crow’s Foot
Line perpendicular to the line connecting the tables and a crow’s foot
(3 lines radiating from the line connecting the tables)
6. Normalization

1NF
2NF All fields in a record must be connected with a primary key.
3NF
Factors Description
Volume
Variety
Velocity
Concept Description (What makes each of the following unique?)
Data warehouse
Data mart
Primary Components Description
Source Systems
Data Quality
Data Governance
Metadata
ETL Step Description
Extract
Transform
Load
Static Data
Concept Description
Forecasting
Associations
Classifications
There is no repeating data or group of data. For example, having a
person's name in the database in two different tables. Using Primary
and Foreign keys to link the tables is the means why which you
eliminate the need to list someone's name in two different tables.
All fields in a table must be connected by and associated with a
primary key.
7. Referential Integrity
Define Referential
Integrity
Why is Referential
Integrity Important?
8. Big Data
9. Data warehouse & Data Mart?
10. Components of a data warehouse
11. Transferring Data to a Data Warehouse
12. Data Mining Concepts

Clustering
Sequences
Concept Description
Data Mining
Predictive Analytics
Business Intelligence
Concept Description
Data Dictionary
Data Management
Data Retrieval
Data Administration
Component Description
Integrity
Confidentiality
Availability
Methods of Maintaining Description
Data Integrity
Limit Risk of Destruction
Formatting Rules
Principle of Least Privilege
Activity Description
Data Properly Recorded
Data Properly Stored
Data Properly Retrieved
13. Analytics & Business Intelligence Concepts
Sentiment Analysis
14. DBMS
15. CIA Triad
16. Maintaining Quality Data/Data Integrity
Access
Policies/Authorization
17. Data Governance
Data Properly Retained &
Destroyed
18. What is the purpose of a data warehouse?