GeekInterview.com
Series: Subject: Topic:

Data Modeling Interview Questions

Showing Questions 1 - 20 of 43 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Can transfer function of a system be equal to its homogeneous solution?

Asked By: anshul malhotra | Asked On: May 6th, 2013

Transform the following differential equation into a transfer function and find the homogeneous solution to the differential equation from the transfer function

What is aggregation in DBMS?Explain in simple words.

Asked By: dhananjay.rai008 | Asked On: Sep 1st, 2011

Star Read Best Answer

Editorial / Best Answer

Answered by: Bapineedu Bollempalli

View all answers by Bapineedu Bollempalli

Member Since Sep-2011 | Answered On : Sep 18th, 2011

A concept which is used to model a relationship between a collection of entities and relationships. It is used when we need to express a relationship among relationships. Aggregation - a feature of the entity relationship model that allows a relationship set to participate in another relationship set. This is indicated on an ER diagram by drawing a dashed box around the aggregation.

Answered by: joyce shelton on: Apr 8th, 2013

Summarized data

Answered by: kumar on: Oct 1st, 2011

collection of entities...

Manages's salary details are hidden from employees this is 1. Conceptual level of data hiding 2. Physical level of data hiding 3. External level of data hiding 4. EIther 1 or 2...

Asked By: Rujul | Asked On: Mar 9th, 2007

Answered by: vinot on: Jan 23rd, 2013

1. Conceptual level of data hiding

Answered by: ritu yadav on: May 7th, 2010

3. External Level Data Hidding

Database structure change

Asked By: Marco | Asked On: Aug 10th, 2011

We already have a database structure, but it is the structure without normalization and very confused and in need of change, but already has a large volume of stored data, for example, all financial data company, which finance department officials are afraid of losing. we are undecided about remodeling...

Star Read Best Answer

Editorial / Best Answer

Answered by: Bapineedu Bollempalli

View all answers by Bapineedu Bollempalli

Member Since Sep-2011 | Answered On : Sep 18th, 2011

What ever data base structure you have you can get a Logical model out of it using Reverse Engineering. Erwin is one data model tool which does it. You should apply normalizing techniques to bring the same to a 3NF (Normal Form) and reduce the redundancy. Creating new entities by breaking up of de-normalized entities. Resolving many to many relationships. Finally create a new database structure (Physical Model) based on 3NF from the logical model. Once you acheive a model in 3NF you can do Data migration by simple ETVL ( Extract, Transform, Validation and Load) from old data structure to new data structure. Before doing it your High Level Design should have proper Data mapping document and Metadata document so that you do not lose data.

Answered by: Rohit on: Nov 18th, 2012

It purely depends what kind of problem you are facing currently. Performance issue can be dealt in n different ways, you need to see the current configuration of DB, the queries, the hardware etc. If ...

Answered by: Bapineedu Bollempalli on: Sep 18th, 2011

What ever data base structure you have you can get a Logical model out of it using Reverse Engineering. Erwin is one data model tool which does it. You should apply normalizing techniques to bring the...

Banking domain

Asked By: krmmanivannan | Asked On: Jul 15th, 2012

What are all the functionality we have to concentrate in banking project?

Mvc design pattern

Asked By: ankurcse11 | Asked On: May 8th, 2012

What is the difference between mvc1 and mvc2 in j2ee?

Star Read Best Answer

Editorial / Best Answer

Answered by: Sandhya.Kishan

View all answers by Sandhya.Kishan

Member Since Mar-2012 | Answered On : May 14th, 2012

1.MVC1 consists of Web browser accessing Web-tier JSP pages. The JSP pages access Web-tier JavaBeans that represent the application model, and the next view to display is determined by hyperlinks selected in the source document or by request parameters. 2.MVC1 is page-centric design, meaning any JSP page can either present in the JSP or may be called directly from the JSP page. 3.MVC1 Combines both presentation logic with the Business logic. 4.MVC1 we can have multiple controller servlets. 1.MVC2 introduces a controller servlet between the browser and the JSP pages. The controller centralizes the logic for dispatching requests to the next view based on the request URL, input parameters, and application state. 2.MVC2 removes the page-centric property by separating Presentation, Control logic and Application state. 3.MVC2 can have only one controller servlet .

Answered by: Sandhya.Kishan on: May 14th, 2012

1.MVC1 consists of Web browser accessing Web-tier JSP pages. The JSP pages access Web-tier JavaBeans that represent the application model, and the next view to display is determined by hyperlinks sele...

What is a toponomy database ?

Asked By: sesu64 | Asked On: Apr 13th, 2012

Star Read Best Answer

Editorial / Best Answer

Answered by: Sandhya.Kishan

Answered On : Apr 18th, 2012

Toponomy database is a collection of data related to the study of place names, their origins,meaning,topology and their use.

Answered by: Sandhya.Kishan on: Apr 18th, 2012

Toponomy database is a collection of data related to the study of place names, their origins,meaning,topology and their use.

What is difference between query calculation and layout calculation

Asked By: konka.ramesh37 | Asked On: Aug 27th, 2011

Star Read Best Answer

Editorial / Best Answer

Answered by: Sandhya.Kishan

View all answers by Sandhya.Kishan

Member Since Mar-2012 | Answered On : Apr 11th, 2012

The query calculation helps to create a report to add a new row or column with values that are based on a calculations. Layout calculation helps to create a report which contains run time information such as current time, date, and user name.It does not perform any operations on data.

Answered by: Sandhya.Kishan on: Apr 11th, 2012

The query calculation helps to create a report to add a new row or column with values that are based on a calculations.
Layout calculation helps to create a report which contains run time information such as current time, date, and user name.It does not perform any operations on data.

How to capture webtable values

Asked By: rajvgkumar | Asked On: Aug 31st, 2011

Star Read Best Answer

Editorial / Best Answer

Answered by: Sandhya.Kishan

View all answers by Sandhya.Kishan

Member Since Mar-2012 | Answered On : Apr 11th, 2012

By using the function getroproperty("field name") we can capture webtable values.

Answered by: Sandhya.Kishan on: Apr 11th, 2012

By using the function getroproperty("field name") we can capture webtable values.

What is fish-bone analysis?

Asked By: varadarajan | Asked On: Jan 9th, 2012

Explain with an example

Star Read Best Answer

Editorial / Best Answer

Answered by: Ade

Answered On : Apr 4th, 2012

Fish-bone Analysis is a cause and effect analysis tool that helps to identify the problem and causes of the problem using a fish-like structure - the problem is at the head of the fish and the skeleton are the causes. Example is if an organization is experiencing decline in profit, the possible causes could be increase in cost of production, decline in revenue, competition in the market, substitute for our products etc. This analysis is usually conducted in a brainstorming session.

Answered by: Ade on: Apr 4th, 2012

Fish-bone Analysis is a cause and effect analysis tool that helps to identify the problem and causes of the problem using a fish-like structure - the problem is at the head of the fish and the skeleto...

Describe collage as system?

Asked By: Said Omar | Asked On: Nov 24th, 2011

Describe your university or college as a system. what is the input? what is output? what is the boundary? what is the components and their relationship? the constraint the environment draw a diagram of this system

What is the difference between star flake and snow flake schema?

Asked By: Remo | Asked On: Apr 11th, 2006

Star Read Best Answer

Editorial / Best Answer

Answered by: zahoorahmad

View all answers by zahoorahmad

Member Since Apr-2006 | Answered On : Apr 12th, 2006

Star Schema:

Well in star schema you just enter your desired facts and all the primary keys of your dimensional tables in Fact table. And fact tables primary is the union of its all dimension table key. In star schema dimensional tables are usually not in BCNF form.

SnowFlake:

Its almost like starschema but in this our dimension tables are in 3rd NF, so more dimensions tables. And these dimension tables are linked by primary, foreign key relation.

Answered by: Wassim Saade on: Nov 23rd, 2011

Star flake schema's are snowflake schema's where only some of the dimension tables have been denormalized.
Every star flake schema is also a snowflake schema.
Not every snowflake schema is a starflake schema.
A snowflake schema with all of its dimension tables normalized is not a starflake schema.

Answered by: karpuni on: Jul 24th, 2008

Star schema - normalized one snow flake-denormalized

Logical database design

Asked By: Crescience | Asked On: Sep 26th, 2011

Discuss how you would use storage structures mainly the tablespaces, database security features, Oracle net services to logically manage what users can do or not to the database. Assume you would want to achieve partial database availability to different users at some times so that whilst some users...

Informatica architecture

Asked By: bingiramesh | Asked On: Sep 4th, 2011

Can you explain about Informatica architecture ? And what difference between service based and service oriented ?

Star Read Best Answer

Editorial / Best Answer

Answered by: venkatesh

Answered On : Sep 21st, 2011

|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-------------------------------- | | | |powercenter repositery | | | |------------------------------- | | |________________|repositery server | | --------------------------------|-------------------|

Answered by: venkatesh on: Sep 21st, 2011

|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-...

Client dependent table

Asked By: Subina | Asked On: Aug 30th, 2011

What are the values given to the field name,data element and type of a table to make it as a client dependent ?

How to construct pyramid struture

Asked By: ch.rajun | Asked On: Aug 24th, 2011

What is erd?

Asked By: Interview Candidate | Asked On: Aug 23rd, 2005

Answered by: randysam on: May 30th, 2011

An ER Diagram.  It shows the relationship of tables to each other.

Answered by: geeksds on: Sep 18th, 2008

Entity-Relationship diagram

Data modeling

Asked By: tasneem402 | Asked On: May 31st, 2008

What is the impact of data modeling software engineering?

Answered by: JayashreePatil on: Jul 2nd, 2008

GUI Representation of a Data model of any system helps in understanding the data flow and relationship between the entities.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.