Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Entity Relationship Diagrams 1

Status
Not open for further replies.
cjw2

cjw2

Technical User
Jan 4, 2005
10
GB
Is it acceptable when creating an entity relationship diagram to have two separate relationships from say entity A to entity B?
(Going from A to B and from different attributes in A but to the same attribute in B)
 
Sort by date Sort by votes
Yes. It happens alot, for instance, BillTo and ShipTo Addresses for a Customer, or PerformingDoctor and AttendingDoctor for a Patient.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

LuciusThorne
  • Locked
  • Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
299
mintjulep
M
cjashwell
  • Locked
  • Question
ER modelling a relationship using alternative join columns
Replies
5
Views
138
MDXer
MDXer
Dontremb
  • Locked
  • Question
Many to Many Relationship help.
Replies
11
Views
155
mjt39
mjt39
03Explorer
  • Locked
  • Question
Entity Relationship Diagram Tool
Replies
16
Views
155
03Explorer
03Explorer
rgatrell
  • Locked
  • Question
One-To-One relationship design issue 2
Replies
18
Views
152
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top