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
In which form of relational database developer refers to a record? In a tuple form of relational database developer refers to a record.

The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

What is Cross Product? Simply Cross product is Binary Operator

Using a labelled diagram explain the operation of the Data Warehouse, define the basic architectural components and outline the main functionalities. Briefly explain the role an op

Explain the Attribute inheritance Ans: Throughout the rendering of the objects in a view, attribute sets of objects higher in the view hierarchy are inherited via objects below

Define raid? Briefly explain it? A range of disk organization methods, collectively called redundant arrays of independent disks (RAID) o   Improvement of reliability throug

Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.

Question 1 Explain the 10 reasons to use MySQL Question 2 Write the SQL statements to demonstrate the following using SELECT command Expression Evaluation ORDER BY

What is theta join explain? Theta  Join  - The  theta  join  operation  is  an  extension  to  the  natural-join operation which permits us to merge selection and a Cartesian

Design Of Distributed Databases: The distributed databases are mainly relational at local level. So a local database schema is the similar as that of a centralised database design