Data Management Foundations WGU - C175. Exam Questions & Accurate answers, VERIFIED 2024 | 22 Pages

1. Flat Files: files having no internal hierarchy 2. Heap files: files containing an unsorted set of records that are uniquely identified by a record ID which allows them to be inserted or deleted by that ID. 3. Index Files: files that store a list of lookup field values from a data file, along with the location (address) in the data file of the corresponding record. 4. Hashed Files: files which use a hash function to decide where a record should be placed on a disk. This allows for a faster data lookup without the use of an index file. - -What are four different file types that can be utilized in an older, file-based system? Flat File - -These are unstructured, plain text or binary files. To access or edit data, the entire file is read into computer memory. After the database options have completed, the entire file is then written back out. Index File - -The concept of this file is similar to the concept of an index in the back of a book. It contains keywords and phrases that are located in a particular file. It also contains a pointer to the location in the file where those keywords can be found. - Data - Information - Knowledge - -- This consists of raw facts which have not yet been processed to reveal their meaning. - This is the result of processing the above to reveal its meaning - This is the body of information and facts about a specific subject Data Management - -A process that focuses on data generation, storage, and retrieval. Common functions include addition, deletion, modification, and listing.2 - Database - Metadata - DBMS (Database Management System) - -- This is a shared, integrated computer structure that stores a collection of end-user data and metadata