14% Lesson 1 Introduction to Databases, Information and Data (7 Questions) Competency 4017.1.1: Introduction to Information and Data Explain how data, databases, and data management is used in today's organization Explain what data is and how is it st

14% Lesson 1 Introduction to Databases, Information and Data (7 Questions) Competency 4017.1.1: Introduction to Information and Data Explain how data, databases, and data management is used in today's organization Explain what data is and how is it stored Explain the different types of data Define file structures Explain how data was stored and retrieved before the use of database management systems 1.1 Why Databases • Best way to store and manage data • Makes data persistent and shareable in a secure way • Essential for organizations to know information about Customers, Products, Employees, Debtors / Creditors • Helps organizations use data / information as a resource to make decisions 1.2 File Structures • File-Based (Prior to DBMS) 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 utilized in a file-based system o Flat Files • No internal hierarchy • Plain text or Binary files • Data that is unstructured • Uses a lot of computer memory to access, edit, and rewrite files after use o Heap Files • Unsorted set of records • Uniquely identified by record ID WGU Data Management Foundation