| ER Diagram [message #90467] |
Sat, 25 October 2003 10:02  |
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  |
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 |
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 |
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 |
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 #90561 is a reply to message #90467] |
Mon, 08 March 2004 19:28 |
diksha
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
|
"if we put an attribute with the relationship representing (diamomd shaped box) what is it called".
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
