erwin data modeler interview questions and answers

The approach by which physical data models are created is called as physical data modeling.ĥ. The important or main object in a database is a table which consists or rows and columns. Database performance, indexing strategy, and physical storage are important parameters of a physical model. Physical data model includes all required tables, columns, relationship, database properties for the physical implementation of databases. What is a physical data model and physical data modeling? The approach by which logical data models are created is called as logical data modeling.Ĥ. Logical Data Models contain Entity, Attributes, Super Type, Sub Type, Primary Key, Alternate Key, Inversion Key Entry, Rule, Relationship, Definition etc. This is the actual implementation and extension of a conceptual data model. What is a logical data model and logical data modeling?Ī logical data model is the version of a data model that represents the business requirements (entire or part of an organization). Physical Data Model: Table, Column, Primary key Constraint, Unique Constraint or Unique Index, Non Unique Index, Check Constraint, Default Value, Foreign Key, comment etc.ģ. Logical Data Model: Entity, Attributes, Super Type, Sub Type, Primary Key, Alternate Key, Inversion Key Entry, Rule, Relationship, Definition, business rule, etc The approach by which data models are created is called as data modeling. The following data modeling questions and answers are conceptual questions that are asked during the data modeler interview.Ī 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 and database objects.

Erwin data modeler interview questions and answers