Steps to verify database diagram
-
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;-) -
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 (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;-) -
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[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
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 RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply