CS 377 - Database
Homework 1: ER Modeling for Emory
Out: Thursday, September 1
Due: Thursday, September 8, 11:59pm
Consider the following facts about the Emory College and
design a database for it using ER model.
- 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 an ID (e.g., F11,
S11, etc), a start date and an end date.
- A number of sections of a
course are offered in a semester and a section will be taught by one
- Not every course will be
offered in a semester and some courses may have multiple offerings
(multiple sections of the course).
- A student has an ID, name and
- A student can enroll in one
section of some course.
- A student can enroll 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.)
- Draw an ER diagram for the database without using any n-ery relationships (relationships of degree 4 or more).
- Specify key attributes of
each entity type and structural constraints (both cardinality and
participation) on each relationship type.
- Represent all the information above correctly.
- Make sure your design does not add bogus facts. E.g. multiple sections of a course
can be offered in some semester and it would be wrong if your design
"forces" one offering of a course.
- Note any unspecified
requirements, and make appropriate assumptions to make the specification
Please submit your homework as a PDF file. You can draw your ER diagram on paper and
scan it or create it on computer and convert it to PDF.
Please place your PDF file in your cs377
directory as ~/cs377/hw1/hw1.pdf
- Can I assume the chairman is
a faculty in the same department? Yes. But without this assumption is
- Can a course be taught by
more than 1 department? No.
- Does a department have to
teach at least one course? No.
- Does every student have to
enroll in at least one course? No.
- Does every course have to
have students enrolled? No.
- Is at least one course taught
each semester? Yes.
- Does the entity Section have any
attributes not mentioned in the problem? No, but you can add some, like
Max Number Enrolled...
- Does a faculty member have to
teach at least 1 course? No.
- Does each faculty have to be
in a department? Yes.
- Does each course have to be
taught at least once (i.e. ever taught)? No.