Needs more info about consultant database modeling for my job

Asked By marian bfinch 0 points N/A Posted on - 05/01/2013

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.

• Status: Open
• Question Views: 555
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Business Management

Best Answer by Davidson Mudge

Go To Solution

Best Answer

Best Answer

Answered By Davidson Mudge 0 points N/A #168874

Needs more info about consultant database modeling for my job

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.

About Davidson Mudge

Questions
3

Answers
500

Best Answers
197

• Vote Up 0 Vote Down

• Posted on - 05/10/2013
• Question Category: Business Management

Answered By Marvin M Calderon 55 points N/A #168873

Needs more info about consultant database modeling for my job

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.

About Marvin M Calderon

Questions
23

Answers
200

Best Answers
88

• Vote Up 0 Vote Down

• Posted on - 05/12/2013
• Question Category: Business Management