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

Tour Operator Agency Database , #A multinational tour operator agency has g... #A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

Find out the names and company names from database, Find out the names and ... Find out the names and company names of all employees sorted in ascending order of company name and descending order of employee names of by which company. SELECT EMPLOYEE_NAME,

DATABASE, WHAT IS SQL WHAT IS SQL

Explain natural join, Explain natural join? Natural Join - Similar as... Explain natural join? Natural Join - Similar as equi-join except in which the join attributes (having similar names) are not involved in the resulting relation. Only one sets

Explain the components of database system in details., Explain the compone... Explain the components of Database System in details.

Finkelstein methodology, PART MARKING: For this section, we will use part m... PART MARKING: For this section, we will use part marking. This means we will supply model answers to all questions but we will only mark six questions. We will choose these randoml

A file manipulation command that extracts some records, A file manipulation... A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT

Explain the functional mode with help of an example, Explain the Functional... Explain the Functional Mode with help of an example. Functional Model  The functional model shows a computation and functional derivation of data values in it without ind

Database administrator, The Database administrator (DBA) uses the data dict... The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p

Which are two ways that entities participate relationship, Which are the tw... Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship