1. Is the database you created for Computer Assignment #1 is not an OLTP operational database. Explain...
Question:
1. Is the database you created for Computer Assignment #1 is not an OLTP operational database. Explain the similarities and differences between your Company Database and an operational database.
2. Does an OLTP operational database provide business intelligence? What is a better way to build business intelligence?
3. In a relational database, you must create ties or relationships in the information that show how the files relate to each other. What must be done before you can create these relationships?
4. The DBMS contains five important software components, the DBMS engine and the four subsystems. We did not use all the subsystems in Computer Assignment #1. Which ones did we use?
5. Which of the four subsystems would require the hiring of an IT specialist in the form of a computer programmer?
6. If you are the CEO of an organization and you want to make sure only trusted staff have access to the company database, which IT specialist would you hire to help you with that?
7. Most data warehouses are multidimensional, meaning that they contain layers of columns and rows. What information might be contained in a data warehouse?
8. A multidimensional data warehouse is often referred to as a cube. Which data mining tool allows you to “turn the cube” in order to view information from different perspectives?