Data Modelling

3. A key that consists of multiple columns to uniquely identify a record in a database table.
6. Data structures that help enhance data retrieval speed in a database.
8. Subset of a data warehouse focusing on specific data.
10. The descriptive data elements that are used to categorize or classify the data.
11. Centralized repository for integrated and historical data.
12. Specifies the type of data stored in a column
14. Level of detail or depth in representing data elements.

1. The measurable data elements that represent the business metrics of interest.
2. Structure that organizes data into rows and columns, representing entities within a database schema.
4. Blueprint defining the structure and organization of a database.
5. Fields in one table that links to the primary key in another table.
7. Abstract representation of data structures relationships and constraints within a domain serving as a blueprint for database design.
8. Introducing redundancy to improve query performance or simply data retrieval.
9. Organizing data to minimize redundancy.
13. Unique identifier for each record in a table.