Steps to verify database diagram

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Steps to verify database diagram

Steps to verify database diagram

Rate Topic

Display Mode

Topic Options

Author

Message

Bhuvnesh

Posted Monday, December 03, 2012 12:48 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1391791

Jayanth_Kurup

Posted Monday, December 03, 2012 1:24 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008

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

Bhuvnesh

Posted Monday, December 03, 2012 1:30 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Jayanth_Kurup (12/3/2012)

yes.

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1391804

Lokesh Vij

Posted Monday, December 03, 2012 1:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 11:26 AM
Points: 1,173, Visits: 1,249

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

Grant Fritchey

Posted Monday, December 03, 2012 5:40 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 3:04 PM
Points: 13,375, Visits: 25,159

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 »

Permissions