• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 4 fuera de 69 páginas
Examen

Data Management Foundations Study Guide C175

Document preview thumbnail
Vista previa 4 fuera de 69 páginas

Data Management Foundations Study Guide C175

Vista previa del contenido

lOMoARcPSD|28964921




[Working] C175 Data Management Foundations Study Guide
(1) copy
Data Management Foundations (Western Governors University)




Studocu is not sponsored or endorsed by any college or university
Downloaded by john gatheca ()

, lOMoARcPSD|28964921




Data Management Foundations Study Guide C175

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




1


Downloaded by john gatheca ()

, lOMoARcPSD|28964921




Data Management Foundations Study Guide C175




o Allows Heap file to be inserted or deleted using ID
o 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




o 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

1.3 Data versus Information
 Data
o Data is the Foundation of Information
o Consists of Raw Facts not yet processed to reveal meaning
o Raw facts / data will need to be transformed to better understand what
it is that you have
o Must be properly formatted for storage, processing, and presentation

 Information
o Information is the Bedrock of Knowledge
o Produced by Processing Raw Data to reveal its meaning



2


Downloaded by john gatheca ()

, lOMoARcPSD|28964921




Data Management Foundations Study Guide C175

 Processing may be as simple as organizing it to reveal patterns
or complex as making forecast / drawing inferences using
system statistical modeling
o Key to good decision making and business survival is accurate,
relevant, and timely information

 Knowledge
o Information and facts about a specific subject
o Implies familiarity awareness and understanding of Information
o Key Characteristic is that New Knowledge can be derived from Old
Knowledge
 Data Management
o A discipline that focuses on the proper generation, storage, and
retrieval of data
o Is it core activity for any business, government agency, service
organization, or charity

1.4 Introducing the Database
 Database
o Shared, integrated computer structure that stores:
 End User Data
o Raw facts of interest to the end user

 Metadata (Also called: A collection of Self-Describing Data)
o Data about data through which data is integrated and
managed
o Describes data characteristics and set of relationships
that links data found in the database
o Stores information like:
 Name of each data element
 Type of values (numeric, dates, or text) on each
data element
 Whether the data element can be left empty
o Complements and expands the value and use of the data

 Role of the DBMS
o An intermediary between user and database
o Presents the end user with a single integrated view of data in a
database
o Receives all application requests and translates them into
complex operations
o Hides database complexities from the application programs and users
o Provides a framework to facilitate data quality initiatives



3


Downloaded by john gatheca ()

Información del documento

Subido en
13 de enero de 2024
Número de páginas
69
Escrito en
2023/2024
Tipo
Examen
Contiene
Preguntas y respuestas
$40.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
johngatheca
2.5
(2)
Vendido
21
Seguidores
25
Artículos
729
Última venta
1 año hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes