Data Processing and Management Quiz

Study Notes

Raw, unprocessed facts and figures without context or meaning.
Examples:
- List of numbers: 5, 10, 15, 20
- Collection of names: John, Mary, Sarah

Converts raw data into useful information by removing errors, incomplete or partial entries, and unnecessary records.
Data preparation phase for making data usable.

Processed data organized and presented to be meaningful and useful.
Provides context and helps understand data.
Example: The list of numbers 5, 10, 15, 20 represents ages of people in a group.

An organized collection of data for easy access and management.
Data is organized into tables, rows, columns, and indexed for easy information retrieval.
A single database management system grants access to all users.
Essential for managing large amounts of information by storing, retrieving, and managing data.
Dynamic websites, like those checking hotel room availability, use databases.
Examples: MySQL, Sybase, Oracle, MongoDB, Informix, PostgreSQL, SQL Server.

Database Engine: Core component responsible for storing, retrieving, and updating data. Handles query processing and execution.
Database Schema: Defines the structure of the database, including tables, relationships, and constraints.
Query Language: Language used to interact with the database, with SQL (Structured Query Language) being the most common for relational databases.
User Interface: Allows users to interact with the database through graphical interfaces or command-line tools.
Database Administrator (DBA) Tools: Utilities for managing and maintaining the database, including backups, performance tuning, and security management.

Controls Redundancy: All data stored in a single file, reducing duplication.
Data Sharing: Authorized users can share data among multiple users.
Backup: Provides backup and recovery subsystems for automatic data creation in case of system failure and data restoration if needed.
Multiple User Interfaces: Offers various interfaces like GUI and application interfaces.