Entity Relationship diagram

[hickie182]

Hey guys i am doing a task and i was wondering is this possible or should i do it another way? suppose to be a many to many relationship going into animal history.


This is the information i am working from




Or can someone think of a better Many to Many relationship or on how i can do it?

[orange]

How about stepping back first and telling us about your business and business rules?
We no nothing about your business which makes it difficult to impossible to comment with any certainty.
We can guess, but it will save time if you tell us a bit about WHAT you do.

Does every Consultation result in 1or more Treatments and/or 1 or more Drugs and/or 1 or more OPerations?

Never, your pet is fine, just needs some sleep?
Good luck with your project.

[hickie182]

I know going to seem weird but you actually helped me a lot. Don't know why it was "Does every Consultation result in 1or more Treatments and/or 1 or more Drugs and/or 1 or more OPerations?

Never, your pet is fine, just needs some sleep?
Good luck with your project."

It made me click and think clearly so thank =),

Sorry for the bad post and lack of information.

[orange]

No problem, we've all be in that spot whee someone -not knowing the issue just happens to ask a question - and you see something much more.

Good luck with your project.
Post again if you have issues/opportunities.