Data Management Foundations Study Guide. WGU C175. Exam Questions and answers, 100% Accurate. GRADED A+

Data Management Foundations Study Guide. WGU C175. Exam Questions and answers, 100% Accurate. GRADED A+ Why databases? - -·Helps organizations use data / information as a resource to make decisions File based structure (Prior to BDMS) - -o Attempt to computerize old manual filing system o Was easy to retrieve small amounts of information from o As data grew, it became difficult to locate and retrieve information o Retrieval speed depended on file structure and how data was organized within the structure File types that utilized file based structure - -Flat files, heap files, Index files, hashed files Flat files - -no internal hierarchy and data is unstructured Heap files - -unsorted set of records uniquely identified by record ID -allows heap files to be inserted or deleted using ID index files - -· File that stores a list of Look Up Field values from data file that includes the location (address) in the data file of the corresponding record · Smaller than the entire record, usually fits in main memory for quick look up · Lists keywords and phrases that are in a particular file · Becomes a pointer to the location in the file where the information can be found when stored with keywords and phrases hashed files - -· Uses hash functions to decide where records should be placed on a disk · Allows for faster data look up without the use of an index file 2 data - -raw facts not processed to reveal meaning. Requires transformation to better understand. information - -o Produced by Processing Raw Data to reveal its meaning o Key to good decision making and busi