Entity-relationship Diagram Exercises And Answers Pdf May 2026

\sectionExercise 3: Company Employees and Departments \textbfScenario: \\ A company consists of departments. Each department has a unique department number, name, and budget. An employee has an employee ID, name, salary, and works in exactly one department. A department may have many employees. Additionally, one employee manages a department (the manager is also an employee).

\newpage

\sectionExercise 1: University Database \textbfScenario: \\ A university needs a database to manage its courses and students. \beginitemize \item Each \textbfStudent has a unique student ID, name, and major. \item Each \textbfCourse has a unique course code, title, and credits. \item A student can enroll in many courses. A course can have many students. \item The enrollment date should be recorded as an attribute of the relationship. \enditemize entity-relationship diagram exercises and answers pdf