3.
Key Concepts and Techniques of Data Modeling
4.
Data Modeling Interview Questions For Freshers
4.1.
1. What is data modeling?
4.2.
2. What are the different types of data models?
4.3.
3. What is data Modelling used for?
4.4.
4. What are the five steps of data modeling?
4.5.
5. What are the 4 levels of the data model?
4.6.
6. What is the difference between logical and physical data models?
4.7.
7. What is a one-to-many relationship in a data model?
4.8.
8. What is a many-to-many relationship in a data model?
4.9.
9. What is data modeling in SQL?
4.10.
10. What is data Modelling in ETL?
4.11.
11. What is data Modelling in OOP?
4.12.
12. What is a data model in DBMS?
4.13.
10. What is Normalization?
4.14.
10. What is Denormalization?
4.15.
11. What is an index in a database?
4.16.
12. What is an Enterprise Data Model?
4.17.
13. What does a data modeler use normalization for?
5.
Data Modeling Interview Questions For Experienced
5.1.
14. What are the most common errors you can potentially face in data modeling?
5.2.
15. Explain the two different design schemas.
5.3.
16. What does ERD stand for, and What is it?
5.4.
17. What are the Critical Relationship types found in a Data Model?
5.5.
18. In the context of Data Modeling, What is the importance of metadata?
5.6.
19. What are subtype and supertype entities?
5.7.
20. What is a primary key constraint?
5.8.
21. What is a foreign key constraint?
5.9.
22. What is a composite primary key constraint?
5.10.
23. What is relational data modeling?
5.11.
24. Should all Databases be rendered in 3NF?
5.12.
25. What’s the difference between forwarding and Reverse Engineering in the context of data models?
5.13.
26. What are recursive relationships, and how do you rectify them?
5.14.
27. Why are NoSQL Databases more useful than Relational Databases?
5.15.
28. List the types of hierarchies in data modeling.
5.16.
29. What is meant by chained data replication?
5.17.
30. What is virtual data warehousing in data modeling?
5.18.
31. Explain the snapshot of the data warehouse.
5.19.
32. Explain the different kinds of fact tables.
5.20.
33. Differentiate between OLAP and OLTP databases.