ER Diagram example with solution
Here we draw an ER diagram for a college based on the given question.
College offers course in different stream. In each stream, various students are enrolled. Each stream is divided into 8 semesters and each semester is divided into two sections. In each semester various subjects are taught. One subject is taught by at most one lecturer and one lecturer can teach more than one subjects.