How does a relational database organize data, and how does it differ from on object-orientated database? (10 points)
Relational databases are organized into two-dimensional tables called relations with rows and columns. Each business entity will have its own table. For instance, one table is used for suppliers, and another table used for customers. Object orientated databases are more versatile. Not only do they include images, drawing and photographs and other features, object-orientated databases are capable of retrieving graphics and multimedia applications, whereas relational databases strictly deal with rows and columns which is limiting.
Entity-relationship diagrams illustrate the connection or relationship in terms of one-to-one, one-to-many, or many-to-many relationships between entities. By using a connecting line followed by short marks and crows feet, a reader can see how many different relationships each entity has.
Normalization streamlines multiple relationship entities, or many-to-many relationship entities to eliminate duplicate data and better equip the system to maintain itself. It increases stability, flexibility and minimizes redundant data.
Define and object-orientated database and explain how it differs from a relational database.
Object-orientated database is as it says in that it contains objects, videos, multimedia formats, whereas relational databases strictly contain rows and columns. However, relational databases tend to be quicker to retrieve data. Object-orientated databases are becoming increasingly popular because with all the variations on multimedia, such as java applets on the Web, integrating pieces of data is easier. Hybrid systems are surfacing that are capable of both relational and object-orientated.
What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? (12 points)
Databases provide information to executives and managers for them to make better decisions and run the business more efficiently. Separate functions for manufacturing, sales, accounting, special capabilities and tools are needed to analyze data and access information from multiple sources. Functions such as data warehousing, data mining and tools for accessing internal databases are such items.
Define a data warehouse and describe how it works.
A data warehouse is a database the holds current and historical data of potential interest to decision makers throughout a company. When it extracts historical and current data it with external data and reorganizes it into a central database that is used for management reporting and analysis.
Define business intelligence and explain how it is related to database technology.
Business intelligence is a series of analytical tools that work with data stored in databases to find patterns and insights for helping managers and employees make better decisions to improve organizational performance. Databases keep track of transactions; data warehouses find patterns and insights through OLAP, data mining, querying and reporting. Business intelligence allows managers and employees the ability to make decisions and respond to the data and patterns.
Describe the capabilities of online analytical processing (OLAP).
OLAP is similar to a rubix cube in that twisting and turning the data in multidimensional avenues will produce varying useful information. It enables users to view the same data in different ways using multiple dimensions. OLAP enables users to obtain online...