Entity-relationship Diagram Exercises And Answers Pdf -

\newpage

\draw (dept) -- (manages) node[midway, above] 1; \draw (emp) -- (manages) node[midway, below] 1; \endtikzpicture \captionCompany ERD \endfigure entity-relationship diagram exercises and answers pdf

\vspace2cm \noindent\rule\textwidth0.5pt \textbfAnswer: \beginfigure[H] \centering \begintikzpicture[node distance=2.5cm, auto] % Student Entity \node[rectangle, draw, minimum width=2.5cm, minimum height=1cm] (student) STUDENT; \node[above=0.2cm of student] \textbfStudent; \node[below=0.1cm of student, align=center] \tiny student\_ID (PK)\\ name\\ major; \newpage \draw (dept) -- (manages) node[midway, above] 1;

% Works-in (1 to many) \draw (dept) -- node[right] 1 ++(2,0) -- node[above] works-in ++(0,-1.5) -- node[left] M (emp); % Manages (1 to 1, but optional on employee side because not every employee is a manager) \draw[->, thick] (emp.east) -- ++(1.5,0) -- ++(0,1.5) -- node[above, midway] manages (1) (dept.east); \node at (3.5,-0.2) 1 (optional); \newpage \draw (dept) -- (manages) node[midway

\draw (dept) -- (works) node[midway, above] 1; \draw (emp) -- (works) node[midway, below] M;