Week Five Flashcards
1.What is the function of data cleansing?
The process of correcting or removing inaccurate data.
2.What is the role of a data warehouse in business intelligence infrastructure?
A tool for storing and analyzing data.A data warehouse consolidates and stores current and historical data from various operational systems, providing a centralized repository for analysis and reporting, which aids in informed decision-making across an organization.
3.What is blockchain primarily used for?
Blockchain technology serves to maintain a secure and transparent record of transactions in a decentralized manner, ensuring that all participants in the network can access the same information while maintaining the integrity of the data.
4.What does OLAP stand for and what is its purpose?
OLAP stands for Online Analytical Processing, and it is used for data analysis to identify patterns and trends.
5.What are the characteristics of big data?
Massive, often unstructured datasets requiring new tools and technologies for management and analysis.
6.What is the significance of data governance?
Ensures data availability, usability, integrity, and security.
7.Name a type of database management system that uses tables for data storage.
Relational DBMS.
8.What are the fundamental components of physical data organization?
Databases, files, records, and fields.
9.What is data redundancy?
The unnecessary repetition of data across different files or systems.
10.What is the purpose of normalization in database design?
Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity, often by dividing large tables into smaller, related tables and establishing relationships between them
11.What information is contained in a data dictionary?
A data dictionary contains metadata about the data in a database, including data definitions, relationships between data elements, data origins, usage, and formats, helping users understand the structure and meaning of the data.
12.What are the main functions of a Database Management System (DBMS)?
A DBMS facilitates the creation, management, and manipulation of databases, allowing users to store, modify, and retrieve data while ensuring data integrity, controlling redundancy, and simplifying data access through a user-friendly interface.
13.What is the role of an Entity-Relationship Diagram (ERD) in database design?
An ERD visually represents the relationships between entities in a database, helping to outline the structure and organization of data, which is crucial for effective database design and ensuring accurate data modeling.
14.What constitutes a file in data organization?
A file is a collection of related records of the same type, organized in a manner that allows for efficient access and management of data within a database or information system.
15.What is a key field in a database?
A key field is an identifier used to uniquely retrieve, update, or sort records within a database, ensuring that each entry can be distinctly recognized and accessed without confusion.
16.What does Structured Query Language (SQL) allow users to do?
SQL is a standard programming language that enables users to manage and manipulate relational databases, including operations like querying data, updating records, and defining database schemas through commands such as SELECT, INSERT, UPDATE, and DELETE.
17.What defines a Relational Database Management System (RDBMS)?
An RDBMS is a type of database management system that stores data in a structured format using rows and columns, allowing for the establishment of relationships between different data entities through the use of primary and foreign keys.
