2025 LATEST UPDATED DATA MODELING 1 ASSIGNMENT, MIDTERM AND
FINAL EXAM. COMPLETE TEST BANK WITH OVER 300 ACTUAL QUESTIONS
WITH 100% CORRECT VERIFIED ANSWERS. A+ GRADE GUARANTEED
SUCCESS
1) What is data modelling?
i) Data modelling is the process of creating a model for the data to store in a database.
ii) It is a conceptual representation of data objects, the association between different
data objects, and the rules.
2) Explain various types of data models
There are mainly three different types of data models:
Conceptual:
i) Conceptual data model defines what should the system contain.
ii) This model is typically created by business stakeholders and data architects.
iii) The purpose is to organize, scope, and define business concepts and rules.
Logical:
i) Defines how the system should be implemented regardless of the DBMS.
ii) This model is typically created by data architects and business analysts.
iii) The purpose is to develop a technical map of rules and data structures.
Physical:
,i) This data model describes how the system will be implemented using a specific
DBMS system.
ii) This model is typically created by DBA and developers.
iii) The purpose is the actual implementation of the database.
3) Explain the fact and fact table
i) The fact represents quantitative data.
ii) For example, the net amount which is due.
iii) A fact table contains numerical data as well as foreign keys from dimensional tables.
4) List out various design schema in data modelling
There are two different types of data modelling schemas:
1) Star Schema, and
2) Snowflake Schema
5) When should you consider denormalization?
Denormalization is used when there is a lot of involvement of the table while retrieving
data. It is used to construct a data warehouse.
6) Explain dimension and attribute
i) Dimensions represent qualitative data. For example, product, class, plan, etc.
ii) A dimension table has textual or descriptive attributes. For example, the product
category and product name are two attributes of the product dimension table.
,7) What is the fact less fact?
i) Fact less fact is a table having no fact measurement.
ii) It contains only the dimension keys.
8) What is in-memory analytics?
In-memory analytics is a process of caching the database in RAM.
9) What is the difference between OLTP and OLAP?
1. OLTP is an online transactional system.
OLAP is an online analysis and data retrieving process.
2. It is characterized by a large number of short online transactions.
It is characterized by a large volume of data.
3. OLTP uses traditional DBMS.
OLAP uses a data warehouse.
4. Tables in OLTP database are normalized.
The tables in OLAP are de-normalized.
5. Its response time is in a millisecond.
Its response time is in second to minutes.
6. OLTP is designed for real time business operations.
OLAP is designed for the analysis of business measures by category and attributes.
, 10) What is table?
i) The collection of rows and columns is called as table. Each and every column has a
datatype.
ii) Table contains related data in a tabular format.
11) What is column?
Column or field is a vertical arrangement of data that contain related information.
12) Define data sparsity
Data sparsity is a term used for how much data you have for entity/ dimension of the
model.
13) What is composite primary key?
Composite primary key is referred to the case where more than one table column is
used as a part of primary key.
14) What is primary key?
i) Primary key is a column or group of columns that unequally identify each and every
row in the table.
ii) The value of primary key must not be null.
iii) Every table must contain one primary key.
15) Explain foreign key
i) Foreign key is a group of attributes which is used to link parent and child table.
FINAL EXAM. COMPLETE TEST BANK WITH OVER 300 ACTUAL QUESTIONS
WITH 100% CORRECT VERIFIED ANSWERS. A+ GRADE GUARANTEED
SUCCESS
1) What is data modelling?
i) Data modelling is the process of creating a model for the data to store in a database.
ii) It is a conceptual representation of data objects, the association between different
data objects, and the rules.
2) Explain various types of data models
There are mainly three different types of data models:
Conceptual:
i) Conceptual data model defines what should the system contain.
ii) This model is typically created by business stakeholders and data architects.
iii) The purpose is to organize, scope, and define business concepts and rules.
Logical:
i) Defines how the system should be implemented regardless of the DBMS.
ii) This model is typically created by data architects and business analysts.
iii) The purpose is to develop a technical map of rules and data structures.
Physical:
,i) This data model describes how the system will be implemented using a specific
DBMS system.
ii) This model is typically created by DBA and developers.
iii) The purpose is the actual implementation of the database.
3) Explain the fact and fact table
i) The fact represents quantitative data.
ii) For example, the net amount which is due.
iii) A fact table contains numerical data as well as foreign keys from dimensional tables.
4) List out various design schema in data modelling
There are two different types of data modelling schemas:
1) Star Schema, and
2) Snowflake Schema
5) When should you consider denormalization?
Denormalization is used when there is a lot of involvement of the table while retrieving
data. It is used to construct a data warehouse.
6) Explain dimension and attribute
i) Dimensions represent qualitative data. For example, product, class, plan, etc.
ii) A dimension table has textual or descriptive attributes. For example, the product
category and product name are two attributes of the product dimension table.
,7) What is the fact less fact?
i) Fact less fact is a table having no fact measurement.
ii) It contains only the dimension keys.
8) What is in-memory analytics?
In-memory analytics is a process of caching the database in RAM.
9) What is the difference between OLTP and OLAP?
1. OLTP is an online transactional system.
OLAP is an online analysis and data retrieving process.
2. It is characterized by a large number of short online transactions.
It is characterized by a large volume of data.
3. OLTP uses traditional DBMS.
OLAP uses a data warehouse.
4. Tables in OLTP database are normalized.
The tables in OLAP are de-normalized.
5. Its response time is in a millisecond.
Its response time is in second to minutes.
6. OLTP is designed for real time business operations.
OLAP is designed for the analysis of business measures by category and attributes.
, 10) What is table?
i) The collection of rows and columns is called as table. Each and every column has a
datatype.
ii) Table contains related data in a tabular format.
11) What is column?
Column or field is a vertical arrangement of data that contain related information.
12) Define data sparsity
Data sparsity is a term used for how much data you have for entity/ dimension of the
model.
13) What is composite primary key?
Composite primary key is referred to the case where more than one table column is
used as a part of primary key.
14) What is primary key?
i) Primary key is a column or group of columns that unequally identify each and every
row in the table.
ii) The value of primary key must not be null.
iii) Every table must contain one primary key.
15) Explain foreign key
i) Foreign key is a group of attributes which is used to link parent and child table.
