# Data Modeling Interview Questions

Showing Questions 41 - 49 of 49 Questions
First | Prev | Next | Last Page
Sort by:
|
•

#### Data Modeling software tools

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

#### geeksds

• Sep 18th, 2008

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

#### SashaFroyland

• Mar 1st, 2008

•

#### vas_kal

• May 11th, 2008

3NF allows transitive dependency

#### Sujatars

• Jun 15th, 2007

Remove columns that are not dependent upon the primary key

•

#### SashaFroyland

• Mar 1st, 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

• 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...

•

#### Why are recursive relationships are bad? How do you resolve them?

• 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...

•

#### 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

• Jun 24th, 2006

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

•

#### 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

• 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

•

#### 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 14th, 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

Showing Questions 41 - 49 of 49 Questions
First | Prev | Next | Last Page
Sort by:
|