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 Rhinorhino 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
Joined
Jan 4, 2005
Messages
10
Location
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 Question
Database Design - Reusing one-to-many relationship in a table?
Replies
4
Views
888
mintjulep
M
cjashwell
  • Locked
  • Question Question
ER modelling a relationship using alternative join columns
Replies
5
Views
512
MDXer
MDXer
Dontremb
  • Locked
  • Question Question
Many to Many Relationship help.
Replies
11
Views
691
mjt39
mjt39
03Explorer
  • Locked
  • Question Question
Entity Relationship Diagram Tool
Replies
16
Views
732
03Explorer
03Explorer
rgatrell
  • Locked
  • Question Question
One-To-One relationship design issue
Replies
18
Views
744
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top