Vocabulary for Careers in Databases

Fill in the Blanks: Complete the sentences below using the correct vocabulary words. 1. A databaseis a structured collection of data that is stored and accessed electronically.2. Normalizationis the process of organizing data in a database to reduce redundancy and improve data integrity.3. The blueprint or architecture of a database that defines how data is organized is called a schema.4. A queryis a request for data or information from a database.5. Data Integrityensures the accuracy and consistency of data within a database over its lifecycle.6. A Relational Databasestores data in tables and allows relationships between the data.7. Data Warehouseis a centralized repository where data from multiple sources is stored for analysis and reporting.8. The systematic computational analysis of data or statistics to derive insights is called analytics.9. Extract, Transform, Loadis a process used to extract, transform, and load data into a database.10. A Cloud Database is hosted in a cloud computing environment, offering scalable data storage. Multiple Choice: Choose the correct answer for each question. Which term refers to a programming language used to manage and manipulate relational databases? Python SQL Java C++ What is the purpose of indexing in a database? To store backup copies of data To reduce redundancy To quickly locate and access data To analyze big data A _ is used to store extremely large datasets for computational analysis. Schema Cloud Database Big Data ETL Which of the following is a centralized repository for analysis and reporting? Data Warehouse Relational Database Query Backup _ is used to extract data from sources, transform it, and load it into a database. Analytics ETL Backup Schema What does a schema define in a database? The amount of storage required How data is organized and relationships are handled The location of the database The type of analysis conducted A _ database stores data in tables with relationships. Non-relational Relational Cloud Key-value What process ensures that data in a database is accurate and consistent? Querying Normalization Indexing Backup The ability to analyze patterns and trends within large datasets is called _. Data Integrity Analytics Indexing Data Modeling What type of database is hosted in a cloud environment? Key-value database Data warehouse Cloud database Relational database Discussion Questions: Provide detailed answers to the following questions. Why is normalization important when designing a database? How does a relational database differ from a non-relational database? Describe the role of ETL in database management.