CoolInterview.com - World's Largest Collection of Interview Questions
Send Free SMS
 Interview Questions  
 Our Services  


INTERVIEW QUESTIONS DATA WAREHOUSING DATA WAREHOUSING BASICS DETAILS
Question :
What is ER Diagram


Category Data Warehousing Basics Interview Questions
Rating (0.0) By 0 users
Added on 7/26/2006
Views 1684
Rate it!
Answers:

The Entity-Relationship (ER) model was originally proposed by Peter in 1976 [Chen76] as a way to unify the network and relational database views.

Simply stated the ER model is a conceptual data model that views the real world as entities and relationships. A basic component of the model is the Entity-Relationship diagram which is used to visually represents data objects.

Since Chen wrote his paper the model has been extended and today it is commonly used for database design For the database designer, the utility of the ER model is:

it maps well to the relational model. The constructs used in the ER model can easily be transformed into relational tables.
it is simple and easy to understand with a minimum of training. Therefore, the model can be used by the database designer to communicate the design to the end user.

In addition, the model can be used as a design plan by the database developer to implement a data model in a specific database management software.





If you have the better answer, then send it to us. We will display your answer after the approval.
Name :*
Email Id :*
Answer :*
Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
Process Verification  Enter the above shown code:*
Inform me about updated answers to this question

   
Related Questions
View Answer
What is degenerate dimension table?

View Answer
What is VLDB

View Answer
What is Dimensional Modelling

View Answer
What are the vaious ETL tools in the Market

View Answer
What is the main differnce between schema in RDBMS and schemas in DataWarehouse....?

View Answer
What are the possible data marts in Retail sales.?

View Answer
What is incremintal loading?
What is batch processing?
What is crass reference table?
What is aggregate fact table

View Answer
What is meant by metadata in context of a Datawarehouse and how it is important?

View Answer
What is a linked cube?

View Answer
What is surrogate key ? where we use it explain with example.

View Answer

Please Note: We keep on updating better answers to this site. Subscribe to our newsletter to get notified when better answer is posted.

Notify me when better answer is posted!
Email:

View ALL Data Warehousing Basics Interview Questions

User Options
Sponsored Links


Copyright ©2003-2010 CoolInterview.com, All Rights Reserved.
Privacy Policy | Terms and Conditions
Page URL: http://www.coolinterview.com/interview/8146/default.asp?cachecommand=bypass


Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Free SMS | Dedicated Servers | Joke of the Day

0.69