Link to home
Start Free TrialLog in
Avatar of sburman
sburman

asked on

Using Denomalized Table in a application

I am designing the data model for na application. In the data model I have introduced a denormalized table which would store the static values, like State, Country, File Type, Status etc. This table has columns namely 'Type', 'Name', 'Value' and 'Parent Name'. This table will be used across the application to get data for Drop down etc.
The application that is being developed is on .NET framework and we will using stored Procedures.

We have another technical developer who does not believe in the concepts of having a denormalized table. He feels we should have seperate table for all value types ie, separate table for State, Country, File type, status etc and link them up together.

I want a second opinion on the best approach to the design the pros and cons of each of these approaches


Static Value table Structure
 
Column Name		Description
 
PARENT_ID		         Parent Type Row Id
TYPE		         Type
NAME	  	 	Drill Down Values or Name
VALUE_1		         Supporting Values
VALUE_2		
VALUE_3		
 
Sample Static Values
Address Type	Primary Address
Address Type	Home Address
Address Type	Residential Address
Address Type	Mailing Address
Address Type	Deliver To Address
File Status 	Pending
File Status 	Withdrawn
File Status 	Rejected
 
 
 
 
Sample Static Value Example

Open in new window

SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sburman
sburman

ASKER

Hi Pedro,

We we are not in DW . In a application we have a combination of both Normalized table or denormalized table. Application data models are either in 2N or 3N Form. I wanted to know the advantages to having a 2N over say 3N
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
BrandonGalderisi sent that to me today...it was a very interesting read.  Glad you enjoyed it.  :)
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial