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
What is the difference between SQL Server 2000 clustered and nonclustered indexes? With a clustered index, the data are kept in the bottom level of the index and in the similar

1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development

Name the metrics for selecting top algorithm There are a number of metrics for selecting top algorithm: i) Computational complexity: Computational complexity refers to eff

Question: Using the data model express the following queries in SQL. (a) Create the Table named "Cinema" and make the cinema_code to be the primary key of the relation and

Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): 2160_Convert the following ER - diagram into a

Haw does it work one database application

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

Consider the subsequent relations RENTER(rno, fname, lname, address, tel_no, pref_type, max_rent) VIEWING(rno, pno, date, comment) PROPERTY_FOR_RENT( pno, street, area ,city,

Database Administrator One of the main perpose for having the database management system is to have control of both data or programs accessing that data. The person having li

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