Explain the conventions for displaying an ER schema as an ER diagram?

An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

Mapping Cardinalities: Express the number of entities to that another entity can be related through a relationship. For binary relationship sets among entity sets A and B, the mapping cardinality must be one of:

1. One-to-one: An entity in A is related along with at most one entity in B, and an entity in B is related with at most one entity in A.
2. One-to-many: An entity in A is related along with any number in B. An entity in B is related with at most one entity in A.
3. Many-to-one: An entity in A is related with at most one entity in B. An entity in B is associated with any number in A.
4. Many-to-many: Entities in A and B are related along with any number from each other.

The suitable mapping cardinality for a particular relationship set depends on the real world being modeled. Cardinality ratios for binary relationships are represented on ER diagram through displaying 1,M, N etc. on the diamonds.

Existence Dependencies: if the existence of entity X depends on the existence of entity Y, then X is said to be existence dependent on Y.

Posted Date: 5/11/2013 3:45:02 AM | Location : United States

Ask an Expert

Related Discussions:- Explain displaying an er schema as an er diagram, Assignment Help, Ask Question on Explain displaying an er schema as an er diagram, Get Answer, Expert's Help, Explain displaying an er schema as an er diagram Discussions

Write discussion on Explain displaying an er schema as an er diagram
Your posts are moderated

Write your message here..

Related Questions

Failure controlling methods, Failure Controlling Methods: Failures can be h... Failure Controlling Methods: Failures can be handled using different recovery methods that are talk about later in the unit. But the first question is doing we really require recov

What are the states of transaction, What are the states of transaction? ... What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

What is a view, What is a view?  Make a view of EMP table named DEPT 20, to... What is a view?  Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.  Ans:  View is a virtual table that does not consist

Define database management system, Define database management system? D... Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

Explain in details about the functions of dba, Explain in details about the... Explain in details about the f unctions of DBA ?

Tables, does tables are called relations does tables are called relations

What is average response time, What is average response time? The avera... What is average response time? The average response time is that the average time for a transaction to be done after it has been submitted.

In which format database schema is written, In which format database schema... In which format database schema is written ? Data base schema is written in the DDL format.

Transactions t1 and t2 are in a deadlock, Evaluate: a.When transactions... Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.

Function module and a normal abap/4 subroutine, What is the difference betw... What is the difference between the function module and a normal ABAP/4 subroutine? In contrast to normal subroutines function modules have uniquely exact interface.  Declaring da