What is E-R model, Database Management System

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.

 

955_ER Model.png

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







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
Related Questions
Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

Explain concurrency control? Concurrency control Oracles multiversion concurrency control varies from the concurrency mechanism used by some other data base vendors. Read

What are the technique to define a schema completely ? A schema is completely define by DDL and DML query language.


Define an abstraction by which relationships are treated as higher level entities Ans: Aggregation.  It is an abstraction by which relationships are treated as higher level

Our company hires independent contractors to install equipment at precise locations across North America. We want to track the installation data and generate reports. The compan

what is difference between circular inked lust and grunded linked list

define normalisation and functional dependency

Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with