Forums for the Business Analyst

 
  Modern Analyst Forums  Business and Sy...  Structured Anal...  ERD Clarity needed
Previous Previous
 
Next Next
New Post 8/13/2013 4:32 PM
User is offline L-Plates
1 posts
No Ranking


ERD Clarity needed 

Hi All,

if anyone can help I would be extremeley grateful!

Firstly, Im new to the forum, its great, thanks to all contributers who have helped me thus far.

I wanted some clarity on :- a) what level of detail is expected for BA' to produce on a ERD for developers to produce the goods?

                                               To elaborate, is a logical model enough ? or do most expect a thorough physical design model?

                                    and b) How much detail should a logical model show? ie should datatypes etc be expected

I ask because I seek a new BA role, but the mention of producing data models in Ads get me thinking about the experience employer requires and also if the ERD'sthey mention are for analysis or design.

Are there any other clues I can look out for in the adverts for clarity.

I understand all employers expect different skill levels just wanted some opinions.

Thanks in advance

 
New Post 8/15/2013 4:33 PM
User is offline Sandy
74 posts
8th Level Poster




Re: ERD Clarity needed 

Generally, a BA would be responsible only for a logical data model and not the physical model. And ERDs show only entities, relationships and attributes - not datatypes. So unless an ad specifically states otherwise, most likely only the logical data level would be expected from a BA position.

However, that still leaves you with the ongoing debate about what belongs in the logical model and what goes into the physical model. If you google 'difference between logical data model and physical data model', you would find a distinct split in opinion as to whether datatypes belong in the logical data model or only in the physical. Chances are, you will encounter both viewpoints at different organizations over your career.

I tend to hold more towards the 'purist' position, and keep datatypes out of the logical model - and when necessary or helpful to do so, use 'logical datatypes' (text, date, number, etc.). Even if a BA isn't responsible for ERDs or data models, a logical data dictionary is a key document. There is a good explanation of the value of a logical data dictionary on the Modern Analyst site under interview questions - link to the specific posting below:

http://www.modernanalyst.com/Careers/InterviewQuestions/tabid/128/articleType/ArticleView/articleId/1392/categoryId/45/What-is-a-logical-data-dictionary-and-what-are-the-benefits-of-maintaining-one.aspx

Logical data dictionaries typically do not go down to the (physical) datatype detail either.

Sandy

 
Previous Previous
 
Next Next
  Modern Analyst Forums  Business and Sy...  Structured Anal...  ERD Clarity needed

Community Blog - Latest Posts

Ekaterina Barabash
Ekaterina Barabash
I address my thoughts to those who are in IT management for whom the terms such as quality of project implementation development and profitability indicators of the company are important.  And it is also addressed to business analysts whose daily routine is the process of communication with Customer. A little about myself first. The last 8...
1 Responses
Dan Tasker
Dan Tasker
I have long been a believer in the saying “Context is everything.” As a business analyst dealing with business users, understanding the context of the topic of discussion is essential. In thinking about what constitutes quality requirements it occurred to me that there are a number of additional contexts that play a role. Examples inclu...
2 Responses
Alexey Kiselev
Alexey Kiselev
We are writing User Stories to fix the scope and describe - what our application should do when implemented.User Stories are great, because the are: Short, Defining Roles, A great connection of the requirement itself and a business need. User Story declared as a high level definition of the requirement, but it could be used to s...
0 Responses




Latest Articles

Framing a New Piece of Work
Dec 16, 2018
0 Comments
Sometimes I find it difficult to explore new pieces of work in a structured way. When given a new challenge / piece of work it’s easy to jump st...
Featured Digital Library Resources 
Copyright 2006-2018 by Modern Analyst Media LLC