Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Steps to verify database diagram Expand / Collapse
Author
Message
Posted Monday, December 3, 2012 12:48 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 2,837, Visits: 3,956
In one of our project, where i recently joined , team leader gave me database diagram to verify whether they have added the correct tables and corresponding tables along with the screenshot of proposed(blue print ) of application flow. Can anybody help to how to check what are the areas i need to emphasis ?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1391791
Posted Monday, December 3, 2012 1:24 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
I am not sure if I understood the context of the question so let me rephrase . The TL wanted you to compare the application business flow and then verify if the tables required for this flow is present in the database by looking it up against the ER diagram ?

If this is the case you really need to know the business process and talk to the developers who implemented the tables to understand the design choices. If there is a logical and physical diagram available it might make things easier. Also if there is a design principles document you could refer to that as well. Proper naming conventions if they are implemented along with code comments within the procedures could also help understand a lot of whats going on.



Jayanth Kurup
Post #1391801
Posted Monday, December 3, 2012 1:30 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:42 AM
Points: 2,837, Visits: 3,956
Jayanth_Kurup (12/3/2012)
I am not sure if I understood the context of the question so let me rephrase . The TL wanted you to compare the application business flow and then verify if the tables required for this flow is present in the database by looking it up against the ER diagram ?
yes.


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1391804
Posted Monday, December 3, 2012 1:55 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Create a new Database diagram from the database under verification using SSMS. Try to compare the visual diagrams thereafter.

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1391807
Posted Monday, December 3, 2012 5:40 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 1:01 PM
Points: 15,558, Visits: 27,932
Basically you need to understand the business requirements and then validate that the data structure will meet them. It's conceptually insanely simple. It's a ton of work in practice.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1391865
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse