What are E-R diagrams?

 Posted by ArticlesMaint on 9/18/2009 | Category: Sql Server Interview questions | Views: 10491

E-R diagram also termed as Entity-Relationship diagram shows the relationship between various tables in the database. Example: Tables Customer and Customer Addresses have a one to many relationship (i.e. one customer can have multiple addresses) this can be shown using the ER diagram. ER diagrams are drawn during the initial stages of a project to forecast how the database structure will shape up. Below is a screen shot of a sample ER diagram of “Asset Management” which ships free with Access.

Asset management ER diagram.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response