Entity-relationship Diagram Exercises And Answers Pdf • Premium Quality
\sectionExercise 4: Hospital Management (Ternary Relationship) \textbfScenario: \\ A hospital records which doctor treats which patient on which date. \beginitemize \item \textbfDoctor: doctor\_id (PK), name, specialty. \item \textbfPatient: patient\_id (PK), name, illness. \item \textbfTreatment Date: date. \item A doctor may treat many patients on a given date; a patient may be treated by many doctors; and each treatment happens on a specific date. The combination (doctor, patient, date) is unique. \enditemize
% Optional: show as associative entity? For clarity, many-to-many with attribute. \endtikzpicture \captionERD for University Enrollment (Many-to-Many with attribute) \endfigure \noindent\textitNote: In physical design, ENROLLS becomes a bridge table containing student\_ID, course\_code, and enrollment\_date. entity-relationship diagram exercises and answers pdf
\textbfNotation: We use \textbfCrow's Foot notation. \beginitemize \item Entities: Rectangles \item Primary Key: Underlined attribute \item Relationships: Diamonds (or labeled lines) with crow's foot for many side. \item Cardinalities: 1 (one), M (many), (0,1) optional one, etc. \enditemize \item \textbfTreatment Date: date
\tableofcontents \newpage
% Better to use explicit relationship diamond for clarity \endtikzpicture \endfigure \noindent Alternative clear diagram: \beginfigure[H] \centering \begintikzpicture \node[rectangle, draw] (dept) DEPARTMENT; \node[rectangle, draw, below=2cm of dept] (emp) EMPLOYEE; \node[diamond, draw, left=1cm of dept] (works) WORKS\_IN; \node[diamond, draw, right=1cm of dept] (manages) MANAGES; \enditemize % Optional: show as associative entity
\textbfTask: Draw a ternary relationship ERD.
\vspace2cm \noindent\rule\textwidth0.5pt \textbfAnswer: \beginfigure[H] \centering \begintikzpicture[node distance=2cm] \node[rectangle, draw] (doctor) DOCTOR; \node[rectangle, draw, below left=2cm and -0.5cm of doctor] (patient) PATIENT; \node[rectangle, draw, below right=2cm and -0.5cm of doctor] (date) DATE; \node[diamond, draw, aspect=2, below=1.5cm of doctor] (treats) TREATS; \draw (doctor) -- (treats); \draw (patient) -- (treats); \draw (date) -- (treats); \node at ($(doctor)!0.5!(treats)$) [left] M; \node at ($(patient)!0.5!(treats)$) [left] M; \node at ($(date)!0.5!(treats)$) [right] M; \endtikzpicture \captionTernary Relationship: TREATS \endfigure \noindent The relationship has cardinality M:M:M. In tables, the composite key is (doctor\_id, patient\_id, date).