In database management system (DBMS), data are kept separate from the applications' programming code. This means that ________.
database does not need to be changed if a change is made to an application
Bringes, a retail chain, has retail stores across three states. With its current legacy system, Bringes is having problems tracking the inventory levels for its stores. It is planning to implement Oracle database systems to replace this legacy system. Which of the following most supports Bringes' decision to replace its legacy system with an Oracle database system?
Bringes' channel partners use a database system that supports the Oracle database system.
Treston, an automobile manufacturer, has recently implemented a new database system. It is confident that this system will help enhance the company's internal (employees) and external (customers and channel partners) communication. Treston is planning to pursue a just-in-time inventory system soon after the database system is implemented. After the implementation of the database system, however, Treston realized that the database system was not effective. Which of the following, if true, can be cited as a reason for the failure of Treston's database system?
Treston's new database system was not supported by the database system of its suppliers and distributors.
Business rules are captured by the designers of the database and included in the data dictionary to ________.
prevent illegal or illogical entries from entering the database
A(n) ________ is a compilation of data from the database that is organized and produced in printed format.
true about query by example capabilities in a database?
It helps to create a query quickly and easily.
The purpose of a data warehouse is to ________.
key business information into the hands of more decision makers
Online analytical processing tools enable users to ________.
analyze different dimensions of data beyond simple data summaries
In online analytic processing systems, ________ are the values or numbers the user wants to analyze
true about digital dashboards?
It supports usage models like push reporting, exception reporting and alerts, and pull reporting.
Online analytical processing systems are designed for efficient retrieval of data and categorize data as measures and dimensions.