Needs more info about consultant database modeling for my job

Asked By 0 points N/A Posted on -
qa-featured

I would like to use ERD Diagram (Entity Relationship Diagram) and wanted to check which is better among the 3 levels: The Conceptual Data Model, The Logical Data Model and The Physical Data Model. The company I am working for has a lot of databases. I have searched some consultant database modeling too but I need more info about this first.

SHARE
Best Answer by Davidson Mudge
Best Answer
Best Answer
Answered By 0 points N/A #168874

Needs more info about consultant database modeling for my job

qa-featured

Hi Marian,

     You mentioned your company has a lot of databases, you have to make sure before choosing which data model to use is if your database can work on the 3 models. Each database model can give an advantage and disadvantage at the same time.  Let me list down each data model and their key points to help you decide:

  • Conceptual data model-  Shows the commonality regarding the relationship of each data. It is the best to use if you want to have a documentation regarding a business wide database. Though this holds less detail about the database.
  • Logical data model- Has more detail and it defines the entities of operational data and the transactional data as well. This is can be developed independently regardless of the technology that it will be implemented.
  • Physical model- This can have detailed information, that can produce a database. This model must know the technology it will be implemented to as it will be dependent on it.
Answered By 55 points N/A #168873

Needs more info about consultant database modeling for my job

qa-featured

Hello Marian Bfinch,

                        If you want to know about these things then you can must a good background of the database. Because these things are the most time consuming thing of a the database because there you are initializing the database. After that you have to make tables and then you have to perform 1st , 2nd and 3rd normalization. The logical data model is a good one as you can check each and every thing at this level so I suggest you to see the things in your database at logical model.

Related Questions