Question

Draw a Conceptual Model for a University using the given scenario. Note: Every entity must have at minimum of four attributes. Use the six steps process to draw the Entity Relationship Diagram. A University may contain many colleges and each college must be part of one University. A college may maintain many labs and each lab must be part of one college. Each college has many lecturers. Each lecturer may work for many colleges. A college must contain many departments and each department must be part of one college. Each department must have one HOD and each HOD must work for one department. Each HOD must manage many lecturers and each lecturer must be managed by one HOD. Every lecturer may teach many courses and each course may be taught by many lecturers. A student must take many courses and each course may be taken by many students. Every college may have one admin and each admin must be working in one college. An Admin may write many orders. An order is written by one admin. An item is supplied by one or more vendors. A vendor may supply many items. An order may consist of many items. An item may be part of many orders.