Home » Developer & Programmer » Designer » ER Diagram
ER Diagram [message #90467] Sat, 25 October 2003 10:02 Go to next message
priyanka
Messages: 14
Registered: 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 Go to previous messageGo to next message
Jose
Messages: 11
Registered: 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



Empleados, clientes y Personas



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 Go to previous messageGo to next message
Hussain
Messages: 2
Registered: 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 Go to previous messageGo to next message
Atwek
Messages: 1
Registered: 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 Go to previous messageGo to next message
navin rao
Messages: 1
Registered: 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 Go to previous messageGo to next message
bijal patel
Messages: 1
Registered: 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 Go to previous messageGo to next message
diksha
Messages: 1
Registered: 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 Go to previous messageGo to next message
urvish
Messages: 1
Registered: April 2004
Junior Member
plz give me full detail of
the e-r diagram.
and give me your e-mail address.
Re: ER Diagram [message #90595 is a reply to message #90554] Fri, 07 May 2004 19:48 Go to previous message
swati
Messages: 7
Registered: May 2001
Junior Member
tell me about how to start designing er diagram and data flow diagram.
of 5 table consider
Previous Topic: relation
Next Topic: DATA files
Goto Forum:
  


Current Time: Thu Mar 28 18:27:26 CDT 2024