Design a college DB: entities Student(roll PK, name), Course(code PK, title). Relationship Enrolls is M:N (a student takes many courses). The ER diagram becomes three tables: Student, Course, and Enrolls(roll FK, code FK) with a composite key. 1:N like Department-Has-Student needs no extra table, just a foreign key.