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 are the various properties of Relational tables? Relational tables have 6 properties: 1. Each row is unique. 2. Column values are of the same kind. 3. Values are


Read the description below and draw an Entity-Relationship diagram for it. You must use the symbols described in the course materials. This database will help the Parents Assocc

Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

Question 1 Explain ER model Question 2 What are the characteristics of a computer provided information? Question 3 What are facts and guidelines to be considered when se

What is Cross Product? Simply Cross product is Binary Operator

Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

Task Part A. Create an ERD from a business problem. (50 marks) Read the following problem and complete the tasks listed below. THE ABS Blood Bank Australian Blood Services (ABS) i

What is transaction? Collections of operations that form a single logical unit of work are known as transactions.

List two restrictions that are applied on the modification (updation, insertion or deletion) of base tables through view.  Ans: The two restrictions are: 1. If a view