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 called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

Using Relational Algebra which query finds customers, who have a balance of over 1000 ? Using Relational Algebra Π Customer_name( σ balance >1000(Deposit)) is query to find cu

Explain Composite attribute in SQL ? Composite attribute: A composite attribute has many components, each of that is atomic or composite.

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

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known

Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known

Draw an ER diagram that shows the organization of a simple student database. The database captures the information about letter grades obtained by university students who enrolled

What is System R? What are its two major subsystems? System R was intended and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its pur

Define Forms Based Interfaces? Forms-Based Interfaces - A forms-based interface display a form to each user. Forms are commonly designed and programmed for naive users and inte