C182 - Intro to IT Lesson 6.1 Introduction to the Management of Data

Why is managing data important for organizations?

To ensure data and information systems support business goals and processes

Which responsibility best illustrates a database administrator's role in data management?

Granting and modifying employee access to databases

What does a database management system (DBMS) do with large amounts of data?

Converts data into a usable format for decision-making

How do most databases differ from traditional flat-file systems?

Databases allow data to be accessed from multiple views through internal linking

What problem existed when organizations used separate systems for payroll, personnel, and inventory?

Data duplication and separation across systems

How do database systems improve organizational data use?

By integrating information so the same data can support multiple processes

What is database research?

Analyzing and converting data into information for decision-making

How do websites typically interact with databases?

Web servers query databases and return organized results to clients

Which two major layers make up a typical database application?

Application layer and database management layer

Why does the application layer not directly manipulate database data?

It relies on the DBMS to perform data operations

How is a DBMS similar to an operating system?

It supports both application software and data

What is a database table composed of?

Records and fields

In a database table, what do records represent?

Rows containing related information

What does a field contain?

One piece of data about a record

What is a flat-file database?

A plain text file where each line stores one record

Which operation can be performed on a flat-file database?

Creating, deleting, updating, and searching records

How is data organized in a hierarchical database?

In a tree structure with parent-child relationships

What limits access in a hierarchical database?

Predictable paths within the tree

What uniquely identifies each record in a relational database table?

Primary key

What relationship is created when a primary key from one table appears in another table?

Foreign key relationship