Question

Design an ER diagram for a database for the Emory College. Here are some facts about the college:

1. The Emory College consists of a number of Departments (MathCS, Physics, etc)
2. A department has a unique name, address, phone number and can have a number of faculty members.
3. A faculty member has SSN, name, office, phone number and salary
4. A department has one department chair with a starting date
5. A department can teach a number of courses
6. A course has a unique ID, a course name and a description
7. A semester has a unique ID, a start date and an end date.
8. A number of sections of a course is offered in a semester and a section will be taught by one faculty member.
9. Each section is uniquely identified by a section number.
10. Not every course will be offered in a semester and some courses may have multiple offerings (= multiple sections of the course offered in a semester).
11. A student has an ID, name and address
12. A student can enrolled in one section of some course.
13. A student can enrolled in multiple sections in one semester.
    (Clarification: multiple sections of different courses - but you don't have to represent this fact in the ER diagram because it is not easy to do)

Answer 1

Please do comment in case of any doubt or concern..

Let me know through comment if need any further change..