Exam 5: Data and Knowledge Management

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

Define each element of the data hierarchy, in order from smallest to largest.

Free
(Short Answer)
4.9/5
(40)
Correct Answer:
Answered by Examlex AI Copilot

In the context of data management and database design, data is organized in a hierarchical structure that allows for efficient storage, retrieval, and manipulation. Here is the data hierarchy defined from the smallest to the largest elements:

1. **Bit (Binary Digit)**: The smallest unit of data in computing, a bit is a single binary value, either 0 or 1. Bits are the basic building blocks of all data.

2. **Byte**: A byte is a group of 8 bits and is the standard unit used to represent a character such as a letter, number, or symbol in a computer system.

3. **Field (or Attribute)**: A field is a single piece of information; it represents a characteristic of some entity or object. For example, in a database table that stores information about employees, a field could be "Last Name" or "Employee ID".

4. **Record (or Tuple)**: A record is a collection of related fields that usually represents a single entity or object. In the employee database example, a record would contain all the fields related to one employee, such as their name, ID, address, and phone number.

5. **File (or Table)**: A file is a collection of records of the same type. In a relational database, this is often referred to as a table. Each record in the file has the same fields but with different data (e.g., all employee records).

6. **Database**: A database is a collection of related files or tables. It is an organized body of related information that is managed in a way that allows for easy access, retrieval, and use of the data. A database might contain all the tables related to managing human resources, sales, inventory, etc., within an organization.

7. **Data Warehouse**: A data warehouse is a centralized repository for all or significant parts of the data that an enterprise's various business systems collect. It is designed to facilitate reporting and analysis across the entire organization, often storing historical data as well as current data.

8. **Data Lake**: A data lake is a storage repository that holds a vast amount of raw data in its native format until it is needed. Unlike a data warehouse, which stores data in files or folders, a data lake uses a flat architecture to store data.

9. **Data Ecosystem**: This is a broad term that encompasses all the various systems, tools, and environments where data is stored, processed, and used within and outside an organization. It includes databases, data warehouses, data lakes, big data processing systems, data analytics tools, and more.

Each level of the data hierarchy builds upon the previous one, adding structure and context to the raw data, which in turn enables more complex operations and insights.

A standardized language used to manipulate data is _____.

Free
(Multiple Choice)
4.7/5
(43)
Correct Answer:
Verified

D

You would be an instance of your university's STUDENT class.

Free
(True/False)
4.8/5
(35)
Correct Answer:
Verified

True

A database management system is primarily a(n) _____.

(Multiple Choice)
4.8/5
(36)

Which of the following is not a reason why managing data is difficult over time? A. New systems are developed. B. The media the data are stored on becomes problematic. C. New sources of data are created. D. The amount of data increases exponentially. E. All of these are reasons why managing data is difficult over time.

(Short Answer)
4.8/5
(40)

The relational database model is based on the concept of three-dimensional tables.

(True/False)
4.8/5
(35)

Master data are generated and captured by operational systems.

(True/False)
4.8/5
(35)

You have moved to a different apartment, but your electricity bill continues to be sent to your old address. The Post Office in your town has which problem with its data management?

(Multiple Choice)
4.8/5
(28)

In a data warehouse, existing data are constantly purged as new data come in.

(True/False)
4.9/5
(38)

Discuss why decisions concerning data structure have a broader impact than decisions concerning hardware and software.

(Essay)
4.8/5
(32)

In a relational database, every row represents a(n) _____.

(Multiple Choice)
4.8/5
(30)

Data dictionaries perform all of the following functions except:

(Multiple Choice)
4.8/5
(40)

Explicit knowledge refers to the cumulative store of subjective learning, which is personal and hard to formalize.

(True/False)
4.8/5
(38)

As an individual student in your university's student database, you are a(n) _____ of the STUDENT class.

(Multiple Choice)
4.7/5
(36)

Data marts are designed for the end-user needs in a strategic business unit or department.

(True/False)
4.8/5
(35)

_____ describe the activities of the business, whereas _____ categorize(s), aggregate(s), and evaluate(s) data generated by the organization's activities.

(Multiple Choice)
4.8/5
(44)

It is easy to manage all the data coming into an organization.

(True/False)
4.9/5
(29)

At your university, students can take more than one class, and each class can have more than one student. This is an example of what kind of relationship?

(Multiple Choice)
4.8/5
(38)

A negative value for a student's grade point average is an example of a data integrity problem.

(True/False)
4.8/5
(40)

A(n) _____ represents a single character, such as a letter, number, or symbol.

(Multiple Choice)
4.9/5
(36)
Showing 1 - 20 of 90
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)