Data Modeling Interview Questions
Can transfer function of a system be equal to its homogeneous solution?
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.
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.
Summarized data
collection of entities...
1. Conceptual level of data hiding
3. External Level Data Hidding
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...
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.
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 ...
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...
What are all the functionality we have to concentrate in banking project?
What is the difference between mvc1 and mvc2 in j2ee?
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 .
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...
Read Best Answer
Editorial / Best Answer
Answered by: Sandhya.Kishan
Answered On : Apr 18th, 2012Toponomy database is a collection of data related to the study of place names, their origins,meaning,topology and their use.
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
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.
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
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.
By using the function getroproperty("field name") we can capture webtable values.
Explain with an example
Read Best Answer
Editorial / Best Answer
Answered by: Ade
Answered On : Apr 4th, 2012Fish-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.
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 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?
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.
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.
Star schema - normalized one snow flake-denormalized
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...
Can you explain about Informatica architecture ? And what difference between service based and service oriented ?
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 | | --------------------------------|-------------------|
|----------------------------|---------------------------------|-------------------| | SOURCES |client tools | TARGET | | like ,oracle,db2 |-...
Describe the v-model and fish model in sdlc ?
What are the values given to the field name,data element and type of a table to make it as a client dependent ?
What is the best way to start the analytical side of the sdlc?
What is the impact of data modeling software engineering?
GUI Representation of a Data model of any system helps in understanding the data flow and relationship between the entities.
User Panel
Categories
Interview Coaching
Ads
Connect
Ads
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.
NH
