Chapter 11: Information and Data Management

A database is a collection of data organized in a manner that allows access, retrieval, and use of that data.

Data is raw, unprocessed facts and figures, while information is processed, organized, meaningful, and useful data.

Data integrity reflects the quality of the data. The more errors the data contains, the lower its integrity.

<p>Accurate</p> Signup and view all the answers

<p>Files, records, fields, and characters.</p> Signup and view all the answers

<p>A character is one byte, which can be a number, letter, space, punctuation mark, or other symbol.</p> Signup and view all the answers

<p>A field is a combination of one or more related characters that represent a specific piece of information.</p> Signup and view all the answers

<p>A primary key is a field that uniquely identifies each record.</p> Signup and view all the answers

<p>File maintenance refers to the procedures that keep data current, including adding, modifying, or deleting records.</p> Signup and view all the answers

<p>Validation compares data with a set of rules or values to find out if the data is correct.</p> Signup and view all the answers

<p>Deleting records</p> Signup and view all the answers

<p>File processing uses separate files for each department, leading to data redundancy, while the database approach provides a centralized shared data source, reducing redundancy and improving data integrity.</p> Signup and view all the answers

<p>A database management system is software that allows users to create, manage, and access databases.</p> Signup and view all the answers

<p>A data dictionary contains data about each file and each field in those files within a database, including information on data types, size, and validation rules.</p> Signup and view all the answers

<p>A query language is a set of commands used to retrieve, update, or manage information from a database.</p> Signup and view all the answers

<p>SQL is a popular query language used to manage, update, and retrieve data from a database.</p> Signup and view all the answers

<p>QBE is a feature of DBMS tools that uses a graphical user interface to assist users in creating queries without needing to write complex SQL code.</p> Signup and view all the answers

<p>A form provides areas for entering or modifying data within a database. Think of it as a user-friendly interface for inputting specific information.</p> Signup and view all the answers

<p>A report writer allows users to design and customize reports based on data from the database, retrieving, displaying, and printing the desired information.</p> Signup and view all the answers

<p>A relational database organizes data into tables, where each row represents a record and each column represents a field.</p> Signup and view all the answers

<p>A relationship is a link between data in different tables, allowing you to connect and access related information.</p> Signup and view all the answers

<p>An OODB stores data in objects, which can be complex data structures containing both data and behavior.</p> Signup and view all the answers

<p>A multidimensional database can store data in more than two dimensions, often used for analyzing data from multiple perspectives.</p> Signup and view all the answers

<p>A data warehouse is a large database that stores and manages historical and current data, commonly used for analyzing trends and business intelligence.</p> Signup and view all the answers

<p>A database analyst decides on the proper placement of fields, defines relationships between data, and identifies users' access privileges.</p> Signup and view all the answers

<p>A database administrator creates and maintains the data dictionary, manages database security, monitors performance, and oversees backup and recovery procedures.</p> Signup and view all the answers

<p>Attachment</p> Signup and view all the answers

<p>True</p> Signup and view all the answers

<p>A DBMS utilizes techniques like backup, log files, recovery utilities, and continuous backup to ensure data can be restored to a usable state in case of a database failure.</p> Signup and view all the answers

<p>An information system is a set of hardware, software, data, people, and procedures that work together to produce information.</p> Signup and view all the answers

<p>An ERP system integrates MRP II with the information flow across an organization to manage and coordinate various business activities, including product planning, manufacturing, distribution, accounting, finance, sales, human resources, and customer support.</p> Signup and view all the answers

<p>A DMS allows for storage and management of company documents, such as word processing documents, presentations, and spreadsheets.</p> Signup and view all the answers

<p>A TPS is an information system that captures and processes data from day-to-day business activities.</p> Signup and view all the answers

<p>An MIS generates accurate, timely, and organized information to help managers make decisions, solve problems, supervise activities, and track progress.</p> Signup and view all the answers

<p>A DSS helps users analyze information and make decisions.</p> Signup and view all the answers

<p>An expert system captures and stores the knowledge of human experts and then imitates human reasoning and decision-making.</p> Signup and view all the answers