(Top 2024/2025 EXAM REVIEW PAPER )WGU- C175. Database Management - Foundations - Chapter Review Cards. Questions & accurate answers. rated A+

WGU- C175. Database Management - Foundations - Chapter Review Cards. Questions & accurate answers. rated A+ What is data redundancy, and which characteristics of the file system can lead to it? - -Unnecessarily duplicated data resulting from a file system's inability to represent and manage data relationships. What is data independence, and why is it lacking in file systems? - -data independence exists when changes to a file's data characteristics don't affect data access programs and is therefore lacking in file systems because file access is dependent on a file's data characteristics What is a DBMS, and what are its functions? - -It's a collection of programs that manage the db structure and control shared access to the data in the db. Its functions are: - Storing and updating, as needed, metadata in a data dictionary - Creates the complex structures for data storage - Transforms data to fit the created structures - Creates and enforces security - Creates complex structures to allow multiuser access - Handles backup and recovery 2 - Promotes and enforces integrity rules - Provides access to the data through utility programs and APIs - Provides end-user access to data within a network environment What is structural independence, and why is it important? - -it exists when changes to the file's structural characteristics (e.g. # of columns) has no impact on data access programs which substantially reduces programming effort and program maintenance costs Explain the differences between data, information, and a database. - -data are raw facts, information is data processed to provide meaning, and a database stores/shares data so that it can be transformed into information as needed List and describe the different types of databases. - -Single-user: sits on a user's desktop Multiuser: allows more than one user simultaneous access Workgroup: is a multiuser for 50 or fewer users, or a specific department in an organization Enterprise: is used by the entire organization and supports more than 50 users Centralized: supports data located at a single site Distributed: supports data distributed across several sites Cloud-based: created and maintained through cloud data services