What are the different Data Modeling software tools? Which one is considered the best among all in terms of cost, efficiency and usability ?

geeksds

 Profile Answers by geeksds Questions by geeksds

• Sep 18th, 2008

Visio; ERwin; Rational.  Rational is considered the best.   

SashaFroyland

 Profile Answers by SashaFroyland Questions by SashaFroyland

• Mar 2nd, 2008

ERWin is the industry leader.

Answer Question  Select Best Answer

vas_kal

 Profile Answers by vas_kal Questions by vas_kal

• May 12th, 2008

3NF allows transitive dependency

Sujatars

 Profile Answers by Sujatars Questions by Sujatars

• Jun 15th, 2007

Remove columns that are not dependent upon the primary key

Answer Question  Select Best Answer

ie. whether it should be Star schema or snow flake schema?

SashaFroyland

 Profile Answers by SashaFroyland Questions by SashaFroyland

• Mar 2nd, 2008

Pro Star Schema: Users find easier to query and faster query times. Space consequences of repeated data makes little difference as Dimensional table hold relatively fewer rows then the la...

Answer Question  Select Best Answer

SashaFroyland

 Profile Answers by SashaFroyland Questions by SashaFroyland

• Mar 2nd, 2008

The only difference is in what's been selected in the model type when the diagram was first started. In ERWin 7.3 you have the choice of creating three different kinds of diagrams: 1) Physical...

rahul.katke

 Profile Answers by rahul.katke Questions by rahul.katke

• Dec 27th, 2007

The Logical Data Model (LDM) is derived from the Conceptual Data Model (CDM).The CDM consists of the major entity sets and the relationship sets, and does not state anything about the attrib...

Answer Question  Select Best Answer

Jeetendra Nalawade

• Nov 12th, 2007

We have used a different way of maintaning recursive relationship. We have created a ancestry table which will give the childs for each entry upto n th level. This way you can fire queries directly to get the child upto any specific level.

ritwik roy

• Jul 21st, 2005

using the concept of self join may be a solution to this problem. e.g if a table called employees contains three fields like emp_id,name and manager_id and we will have to find out the name of the ma...

Answer Question  Select Best Answer

Sujatars

 Profile Answers by Sujatars Questions by Sujatars

• Jun 15th, 2007

Second normal form (2NF) addresses the concept of removing duplicative dataMeet all the requirements of the first normal form. Remove subsets of data that apply to multiple rows of a table and pl...

vvijaychandra

 Profile Answers by vvijaychandra Questions by vvijaychandra

• Jun 24th, 2006

create seperate tables for the set of values that apply to multiple records , realate these tables with a foreign key.

Answer Question  Select Best Answer

Sujatars

 Profile Answers by Sujatars Questions by Sujatars

• Jun 15th, 2007

First Normal Form sets the basic structure for an organized database by 1. Eliminating the duplicate/repetative columns from the same table.2. Create a seperate table for each set of related data and identify each set of related data (row) with a unique column (primary key).

vvijaychandra

 Profile Answers by vvijaychandra Questions by vvijaychandra

• Jun 24th, 2006

eliminate the repeating groups in the individual tablescreate a seperate table for each set of related data.identify each set of related data with a primary key

Answer Question  Select Best Answer

SRIKANTH

• Sep 4th, 2006

SEQUENTIAL FILE CANT BE USED AS LOOK UP.. || HASHED FILE CAN BE USER AS LOOK UPIN SEQ.FILE REMOVING DUPLICATES IS DIFFICULT ||IT MAINLY WORKS AS HASHING ALGORITHM WITH OUT ANY KEY COLUMN IT WONT COSIDER..HASHED FILE IS UR FOR BETTER PERFORMANCE..WE INCREASE THE SIZE OF THE BUFFER IN TIS..

sangroover

• Feb 15th, 2006

Hash file is helpful to take data from any coloumn, it will also have a key, as it has the key the data is sorted.wHEN

Answer Question  Select Best Answer

SC

• Mar 9th, 2006

Data sparsity is term used for how much data we have for a particular dimension/entity of the model. It affects aggregation depending on how deep the combination of members of the sparse dimension mak...

Answer Question  Select Best Answer