Question: 5. Conceptual Data Modeling Create a data model (ERD) based on the following business rules. You must - Identify all of the main entities. -

5. Conceptual Data Modeling Create a data model

5. Conceptual Data Modeling Create a data model (ERD) based on the following business rules. You must - Identify all of the main entities. - Identify PK and FK - Identify all of the relations and connectivity. - Identify the type of participation optionality, existence dependency and relationship strength in all the relationships. - Resolve the many to many relationships using the associative entities. You must use Lucid chart to draw the ERD (and then copy and paste your complete diagram). 3-2 Physicians who work at a medical center see many patients. The center keeps each physician's personal information including id number, title, first name, and last name. The center also keeps each patient's id and her first and last name. Each patient may be seen by more than one physician, although on different appointments. During an appointment with a physician, which occurs on a particular date and time, a patient may be diagnosed with one or more illnesses associated with the degree of each illness. An illness has its unique medical name and common name that can be diagnosed in different appointments for different patients. Hint: - You may need 4 entities in your diagram: PHYSICIAN, APPOINTMENT, PATIENT, DIAGNOSIS, ILLNESS PHYSICIAN: PATIENT =M:N Use APPOINTMENT as an associative entity - APPOINTMENT: ILLNESS = M:N Use DIAGNOSIS as an associative entity

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!