Home » Developer & Programmer » Designer » ER Diagram
ER Diagram Sat, 25 October 2003 10:02
 priyanka Messages: 14Registered: October 2000 Junior Member
In the ER diagram if we have a table thats a linking table used for a many to many relationship between 2 tables.. it is shown as a kite in the ER diagram...

So what if linking table has more fields apart from the PK of the two tables its meant to link? Can it still be shown as a relation (kite) or does it have to shown as a element then?

what does the double line mean between the linking table and one table...
Re: ER Diagram [message #90472 is a reply to message #90467] Thu, 06 November 2003 15:39
 Jose Messages: 11Registered: December 2001 Junior Member
Hola:

Disculpa que te escriba, pero estoy desesperado por no encontrar información para diseñar lo siguiente:

Tengo tres tablas como ejemplo

Una persona con ID = 1 es mi PK de la tabla personas pero quiero que sea FK de la tabla Empleados “o” FK de la tabla Clientes.

No se como construir esto.

Quisa me puedas ayudar con esto.

Muchas Gracias

TEMA: ARC RELATIONSHIPS
Re: ER Diagram [message #90473 is a reply to message #90467] Fri, 07 November 2003 12:34
 Hussain Messages: 2Registered: November 2003 Junior Member
Yes, even if the linking table has more fields apart from the PK's of the two tables, it can still be shown as a relation (kite).
The double line means that the table (whihc is connected via a double line to the linking table) is dependent on the linking table. In other words its a weak entity.
Re: ER Diagram [message #90546 is a reply to message #90467] Thu, 12 February 2004 14:10
 Atwek Messages: 1Registered: February 2004 Junior Member
This is going to be my Master Research programe, and soon i will be able to tell on how to deal with such a case... I will be designing one which will be working along with Fox pro
Re: ER Diagram [message #90553 is a reply to message #90546] Mon, 23 February 2004 18:55
 navin rao Messages: 1Registered: February 2004 Junior Member
i want to know how to draw a E-R diagram for three tables and how the columns of each table is connected.
Re: ER Diagram [message #90554 is a reply to message #90553] Mon, 23 February 2004 22:49
 bijal patel Messages: 1Registered: February 2004 Junior Member
plz tell me the rules and symbol for ER diagram as early as possible
Re: ER Diagram [message #90561 is a reply to message #90467] Mon, 08 March 2004 19:28
 diksha Messages: 1Registered: March 2004 Junior Member
"if we put an attribute with the relationship representing (diamomd shaped box) what is it called".
Re: ER Diagram [message #90573 is a reply to message #90467] Tue, 06 April 2004 01:59
 urvish Messages: 1Registered: April 2004 Junior Member
plz give me full detail of
the e-r diagram.