1. How can you use a relational database to store data, be specific.
2. Do you think an organization such as work or school is data rich, but information poor? Why or why not?
3. Do you think that someone personally need to use multidimensional analysis?
First, relational databases are really the industry standard for data management. Many years ago (lets say the 1980's), data was housed in what we called "flat files." These were one-dimensional files which means they only contained one type of information about an entity in the database. The issue with flat files is they can become unwieldy as information is added to each record. Visually, think of a record in a database for one person and then columns of data you want to know about that person. Some of those columns might not be necessary for every person or relevant for every person. The result is a cumbersome file. The relational database sets up multiple one-dimensional files and connects them using a unique identifier. This allows us to find data in different files when its needed and quickly assemble a portfolio of information about a person that is customized ...
A multidimensional analysis for data versus information is examined in the solution.