Video Tutorial 1: What is a Data Model and Data Modeler Responsibilities? What’s in it: Data Model, High Level Data Modeler Responsibilities along with images of a conceptual data model, logical data model and physical Data Model is explained using Erwin Data Modeling Tool. Video Tutorial 2: Explain Data Modeling Development Life Cycle? What’s in…
General Questions: Have you exported objects from the data model to different database? What is the use of it? What is aggregated data and why do you need aggregated data? What is the role of a logical data modeler and physical data modeler? How do you gather requirements for creating data model? What is the…
1. What is normalization? E.F. Codd gave some rules to design relational databases and the rules were focused on removing data redundancy which helps to overcome normal data modeling problems. The process of removing data redundancy is known as normalization. 2. What are the types of normalization? First normal form, Second normal form, third normal…
The following data modeling questions and answers are conceptual questions that are asked during the data modeler interview. 1. What is data modeling? A data model is a conceptual representation of business requirement (logical data model) or database objects (physical) required for a database and are very powerful in expressing and communicating the business requirements…
