Timeline for How can I model a medical scenario in an entity-relationship diagram?
Current License: CC BY-SA 3.0
53 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 3 at 12:06 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 5 at 15:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 1 at 22:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 12, 2023 at 12:05 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 10, 2023 at 8:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 7, 2023 at 13:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 22, 2022 at 12:04 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 23, 2022 at 22:07 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 21, 2022 at 19:08 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 22, 2021 at 7:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 24, 2021 at 12:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 21, 2021 at 20:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 19, 2020 at 12:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 15, 2020 at 9:05 | history | edited | CommunityBot |
Commonmark migration
|
|
| May 20, 2020 at 22:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 19, 2020 at 13:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 19, 2019 at 9:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 11, 2019 at 8:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 4, 2019 at 21:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 30, 2018 at 13:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 28, 2018 at 1:00 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 25, 2018 at 10:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 18, 2018 at 20:18 | answer | added | David Browne - Microsoft | timeline score: 0 | |
| Aug 18, 2018 at 20:02 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 19, 2018 at 8:16 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 17, 2018 at 3:24 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 17, 2018 at 6:34 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 16, 2018 at 15:57 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Mar 12, 2018 at 0:14 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Feb 9, 2018 at 20:10 | answer | added | jyao | timeline score: 0 | |
| Feb 9, 2018 at 19:30 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jan 1, 2018 at 6:46 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Nov 27, 2017 at 10:50 | comment | added | Walter Mitty | If I had to guess, I would guess that "Physician makes diagnosis" is in the context of a single patient. As in "patient X has the flu". If so, it should be a ternary relationship. Does your book show how to model ternary relationships? | |
| Nov 27, 2017 at 10:47 | comment | added | Walter Mitty | It looks like the book you are learning from is a good one. I'm going to point out that you are beginning with subject matter analysis. That's a good place to start, and a good use of the ER model. Your questions concerning ternary relationships are good ones. Note that these are questions concerning the true nature of the subject matter, and not questions about database design. That is as it should be, during data analysis. But few, if any, of us are experts in the subject matter under discussion. For that reason, we won't be able to tell you if your answersto the issues are correct. | |
| Nov 27, 2017 at 10:41 | comment | added | Walter Mitty | @ypercube it depends on what the word "diagnosis" means. If one asserts that "patieient X has the flue", then the diagnosis might be "has the flue". If that's the diagnosis, then many patients could have the same diagnosis. | |
| Nov 26, 2017 at 10:58 | comment | added | ypercubeᵀᴹ | I understand that this is what you have been given but "a Diagnosis may apply to many Patients" doesn't really make any sense. | |
| Nov 26, 2017 at 10:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 27, 2017 at 1:36 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Sep 18, 2017 at 8:55 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Aug 9, 2017 at 20:36 | answer | added | CaM | timeline score: 0 | |
| Aug 9, 2017 at 20:19 | comment | added | Anthony Genovese | You need an encounter which ties all of those things together on a specific date and time. | |
| Aug 9, 2017 at 19:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jul 10, 2017 at 14:11 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 7, 2017 at 3:36 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| May 4, 2017 at 3:26 | comment | added | Nick.Mc | Congratulations, you have started learning data modelling with one of the most difficult subject areas :) With regards to Order/Treatment relationship, can one order result in multiple treatments? Can a given treatment always be tracked back to a single order or might a single treatment be the result of (or attributed to) many orders? There might not be even be an order entity. In a medical data model, many to many relationships are the norm not the exception. | |
| May 4, 2017 at 2:46 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 2, 2017 at 18:55 | answer | added | joanolo | timeline score: 0 | |
| Dec 5, 2016 at 23:27 | history | tweeted | twitter.com/StackDBAs/status/805916548112248833 | ||
| Dec 5, 2016 at 21:48 | history | edited | MDCCL | CC BY-SA 3.0 |
Added comment clarifications; made some rewordings; modified formatting.
|
| Dec 5, 2016 at 21:17 | history | edited | user3832583 | CC BY-SA 3.0 |
added 1099 characters in body
|
| Dec 5, 2016 at 20:30 | history | edited | MDCCL | CC BY-SA 3.0 |
Modified title; made rewordings; reordered content; changed formatting.
|
| Dec 4, 2016 at 20:33 | review | First posts | |||
| Dec 4, 2016 at 21:20 | |||||
| Dec 4, 2016 at 20:33 | history | asked | user3832583 | CC BY-SA 3.0 |