Author Question: The role of database administration is typically a more hands-on, physical involvement with the ... (Read 58 times)

Mr3Hunna

  • Hero Member
  • *****
  • Posts: 536
The role of database administration is typically a more hands-on, physical involvement with the management of databases.
 
  Indicate whether the statement is true or false

Question 2

Explain the difference between operational and informational systems as well as the primary factors that contribute to the need for separation.
 
  What will be an ideal response?


kxciann

  • Sr. Member
  • ****
  • Posts: 356
Answer to Question 1

TRUE

Answer to Question 2

An operational system is built to run a business in real-time using current data. An informational system is designed to support decision making based on historical point-in-time data. There are three primary factors which dictate the need to separate operational and informational systems:
1. A data warehouse centralizes data that may reside on several different systems.
2. A properly designed data warehouse improves the quality and consistency of data.
3. Contention for resources can be reduced by separating the informational system from the operational system.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

The first oncogene was discovered in 1970 and was termed SRC (pronounced "SARK").

For a complete list of videos, visit our video library