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

Your posts are moderated

Write your message here..

Related Questions

Develop a database design , A practice called Perfect Pets provides private... A practice called Perfect Pets provides private health care for domestic pets throughout America. This service is provided through various clinics located in the main cities of Ame

Explain trivial dependency, Explain trivial dependency? Functional depe... Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.

Create a database, Project: Microsoft Access You have been asked by the ... Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access

Data warehousing, job scheduling for different cubes job scheduling for different cubes

Explain about primary key, Explain about primary key Primary Key: It ... Explain about primary key Primary Key: It is one of the candidate keys that are taken to be the recognizing key for the entire table. E.g. although there are two candidate ke

Write short notes on relational model, Write short notes on relational mode... Write short notes on relational model The relational model uses a collection of tables to show both data and the relationships between those data. The relational model is an ex

Lock, lock and types of lock lock and types of lock

Explain the use of constraints in functional model, Explain the use of cons... Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Develop a fragment of a hypothetical system, The objectives of this assignm... The objectives of this assignment are:  - to develop skills in the design of database driven applications  - to develop skills in applying SQL to implement the relational and

Special comparison operator used in where clause-dml, Special comparison op... Special comparison operator used in where Clause a.   between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE