Data Modelling

5. Abstract representation of data structures relationships and constraints within a domain serving as a blueprint for database design.
7. A key that consists of multiple columns to uniquely identify a record in a database table.
10. Level of detail or depth in representing data elements.
11. Data structures that help enhance data retrieval speed in a database.
13. Introducing redundancy to improve query performance or simply data retrieval.
14. Structure that organizes data into rows and columns, representing entities within a database schema.
15. The descriptive data elements that are used to categorize or classify the data.

1. Unique identifier for each record in a table.
2. Blueprint defining the structure and organization of a database.
3. Centralized repository for integrated and historical data.
4. Specifies the type of data stored in a column.
6. Fields in one table that links to the primary key in another table.
8. The measurable data elements that represent the business metrics of interest.
9. Subset of a data warehouse focusing on specific data.
12. Organizing data to minimize redundancy.