Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design an ER diagram for a database for the Emory College. Here are some facts about the college: The Emory College consists of a number
Design an ER diagram for a database for the Emory College. Here are some facts about the college:
- The Emory College consists of a number of Departments (MathCS, Physics, etc)
- A department has a unique name, address, phone number and can have a number of faculty members.
- A faculty member has SSN, name, office, phone number and salary
- A department has one department chair with a starting date
- A department can teach a number of courses
- A course has a unique ID, a course name and a description
- A semester has a unique ID, a start date and an end date.
- A number of sections of a course is offered in a semester and a section will be taught by one faculty member.
- Each section is uniquely identified by a section number.
- 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).
- A student has an ID, name and address
- A student can enrolled in one section of some course.
- 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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started