E-R Model

This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database by a set of attributes. An Entity - Relationship model is an abstract way to define a database. It generally starts with a relational database, which loads data in tables. Some of the data in these tables point to data in other tables - for instance, your entry in the database would point to various entries for each of the phone numbers that are yours. The ER model would define that you are an entity, and each phone number is an entity, and the relationship between the phone numbers and you is 'has a phone number'. Diagrams prepared to design these relationships and entities are called E-R diagrams or entity-relationship diagrams.

 

Posted Date: 7/30/2012 1:46:07 AM | Location : United States

Ask an Expert

Related Discussions:- What is E-R model, Assignment Help, Ask Question on What is E-R model, Get Answer, Expert's Help, What is E-R model Discussions

Write discussion on What is E-R model
Your posts are moderated

Write your message here..

Related Questions

Multivalued attributes, For every multivalued attribute 'A', we make a new ... For every multivalued attribute 'A', we make a new relation R that contains an attribute corresponding to plus the primary key attribute k of the relation that shows the entity typ

In a hierarchical model of data records are organized, In a Hierarchical mo... In a Hierarchical model of data records are organized ? In the hierarchical model of data records are organized as Tree structure.

Sql iis setup and admin - maybe tfs, I want a good Microsoft Admin experien... I want a good Microsoft Admin experienced in IIS and SQL Server. They require being able to set it up and administer from then onwards. Experience in Team Foundation Server a

Describe physical data independence, Describe Physical Data independence ? ... Describe Physical Data independence ? Physical Data Independence - It is capacity to modify the internal schema without having to change conceptual schema. Therefore, the exter

Find names of employees, Consider the relations EMP(ENO,ENAME,AGE,BASIC_S... Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep

Explain the deadlock avoidance, Define deadlock avoidance. An alternat... Define deadlock avoidance. An alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested. Each request requires the s

Data models, After going by the database architecture, let us now dwell on ... After going by the database architecture, let us now dwell on an important query: how is the data organised in a database? There are a lot of basic structures that exist in a datab

What is known as sequential file organization, What is known as sequential ... What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every

What is database utility, What is database utility? Database utility is... What is database utility? Database utility is the interface among the ABAP/4 Dictionary and the underlying the SAP system.

Give the limitations of sql authorization, Give the limitations of SQL auth... Give the limitations of SQL authorization. The code for checking authorization becomes intermixed with the rest of the application code. Implementing authorization by applic