Intro. to BI & Data Management
4 important questions on Intro. to BI & Data Management
What is a OLAP data cube?
What does a database system consist of?
- Data (the database) - usually stored in files (tables)
- Software - for handling data accessible via some connection and showing results to the user
- Hardware - lots of internal memory to handle data efficiently
- Users - tactical for maintenance of data, organizer for using the data
What is a primary key?
- It can be single field or a combination of field
- It is not possible for the primary key to be null
- Higher grades + faster learning
- Never study anything twice
- 100% sure, 100% understanding
What is a candidate key?
The question on the page originate from the summary of the following study material:
- A unique study and practice tool
- Never study anything twice again
- Get the grades you hope for
- 100% sure, 100% understanding