1.

What Is The Difference Between Data Model And An Entity Relationship Diagram?

Answer»

A data model is a model which shows how data is stored and used for e.g. a normal database.
It has 3 MAIN parts:

  • Structural part:- how data is structured.
  • Integrity part:- Rules governing structure.
  • Manipulation part:- operators used to select,update,querry that data,eg select, update, delete COMMANDS in sql.

ENTERPRISE DATA MODEL(ENTERPRISE RELATIONSHIP MODELING) :- This can be called as an CONCEPTUAL model or semantic model. The sub parts of an ERM are:

  • Entity:- It is an object, eg employees, computer.
  • Relationship:- It captures how TWO or more entities are related to each other.
  • Attributes:- Every entity has its own sets of attributes (e.g. PAN no in INDIA for each employee or SSN in US).

A data model is a model which shows how data is stored and used for e.g. a normal database.
It has 3 main parts:

ENTERPRISE DATA MODEL(ENTERPRISE RELATIONSHIP MODELING) :- This can be called as an conceptual model or semantic model. The sub parts of an ERM are:


Discussion

No Comment Found

Related InterviewSolutions