WGU- C175. Database Management - Foundations - Chapter Review Cards. Questions & accurate answers. rated A+ 2024

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