Based on the following situation,
draw a complete Entity Relationship Diagram using theCrow’s Foot notation which
includes:All entities and attributes Relationships Connectivity and relationship participation (4.5 Marks)Primary and foreign keys (3.5 Marks)A lecturer in a university can
manage multiple projects. But, it is not compulsory for a lecturer
to manage a project. Each project is managed by only one lecturer.
Lecturer will have a staff number, a name, a rank, and a research
specialty. Projects have a project number, a...