Data Management

What are the characteristics of quality data?

Accessible, Accurate, Complete, Economical, Relevant, Reliable, Secure, Timely, Verifiable

How does quality data improve decision making?

Removes guesswork and reduces risk when making business decisions

How does quality data increase customer satisfaction?

Enables personalized service and better understanding of customer needs

How does quality data help increase sales?

Allows accurate targeting and communication with customers

How does quality data support innovation?

Improves processes, product quality, and customer experience

How does quality data raise productivity?

Prevents time wasted correcting errors and lets employees focus on core tasks

How does quality data ensure compliance?

Helps meet data regulations and standards set by authorities

What is data management?

The process of obtaining, storing, securing, and processing data to ensure it is usable

What is data governance?

Policies and roles that ensure data is trusted and used properly by the organization

Role of a DBA (Database Administrator)?

Creates, tests, manages, secures, and improves database performance

Role of a Data Steward?

Ensures accuracy and consistency of specific business data even if not in IT

What is Data Lifecycle Management (DLM)?

Policy-based control of data from creation to deletion when outdated

Why are databases important for businesses?

They provide accurate, timely information to support decisions and operations

What is a DBMS?

Software that manages databases and provides access and security control

What is an entity in a database?

A person, place, or thing that data is stored about

What is an attribute?

A detail or characteristic of an entity

What is database modeling?

Designing how data will be structured and related in the database

Purpose of an ER Diagram?

To visually map relationships between entities and attributes

Correct order: Field, Record, File, Database?

Field → Record → File → Database

What is a primary key?

A field that uniquely identifies a record in a table

What is a foreign key?

A field that links records between two tables

What is SQL?

A language used to manage and query data in relational databases

What is DDL?

Commands used to define database structure

What is DML?

Commands used to modify database data

What is DCL?

Commands used to manage database access permissions

What is TCL?

Commands used to ensure data accuracy through commit and rollback actions

What is data cleansing?

Fixing or removing incorrect or incomplete data from a database

What is data enhancement?

Adding extra useful information to existing data

Key features of a relational database?

Data in tables, use of rows and columns, primary and foreign keys link data

What is SELECT in SQL functions?

Eliminates rows based on conditions

What is PROJECT in SQL functions?

Eliminates columns from a table

What is JOIN in SQL functions?

Combines tables using a common field

What is DaaS?

Database hosted and managed by a provider and accessed over the internet

Examples of relational DBMS?

MySQL, Oracle, SQL Server, PostgreSQL, MariaDB, Microsoft Access