Answered step by step
Verified Expert Solution
Link Copied!

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:

  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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft Visual Basic 2008 Comprehensive Concepts And Techniques

Authors: Gary B. Shelly, Corinne Hoisington

1st Edition

1423927168, 978-1423927167

Students also viewed these Databases questions