Question

Draw a logical ERD (Entity Relationship Diagram, in Crow’s Foot notation) for the following case study. In your ERD, you will need to show entities, attributes, relationships, connectivity & participation, and primary and foreign Keys. You can make up attributes if not given in the case study and make any assumptions if needed. However, your assumptions should not contradict with any information which is already available in the case below.

Case study:
A University has several departments, for example, School of ICT. Each department employs many employees, but each employee works in one department only.
An employee can supervise many other employees, but an employee may have only one supervisor.
Each department offers many courses. A course can be a prerequisite of many other courses, but a course may have only one pre-requisite.
Note: You can draw ERD on a paper or use any software. You will need copy & paste your ERD as an image below.

Answer 1

A logical ERD can be drawn for the case study using Crow’s Foot notation, showing the entities, attributes, relationships, connectivity & participation, and primary and foreign keys.

Step-by-step explanation:

A logical ERD (Entity Relationship Diagram) can be drawn for the given case study using Crow’s Foot notation. The entities in the ERD are 'University', 'Department', 'Employee', and 'Course'. The relationships are as follows:

• Each Department belongs to one University.
• Each Department employs many Employees.
• Each Employee works in one Department.
• Each Employee can supervise many other Employees.
• Each Employee may have only one supervisor.
• Each Department offers many Courses.
• Each Course can be a prerequisite of many other Courses.
• Each Course may have only one pre-requisite.

The connectivity and participation can be shown using the crow's foot symbol and the primary and foreign keys can be indicated using underlined attributes.