EECE 4273/6273

Database Engineering

[left.htm]

A certain computer company maintains an internal education department whose responsibility is to run training courses for the company's employees.  It currently offers a variety of such courses (COURSE), each have a unique course number (COURSE_NO) and a subject (SUBJECT).  New courses can be added and an old one eliminated at any time.

Each course has many offerings (that is, it is taught many times).  The data about an offering (OFFERING) are its offering number (OFFNO), date (DATE), location (LOCATION), the students enrolled in the offering, the teachers for the offering, and the immediate prerequisite courses.  The offering number is unique only within a course.

Teachers and students are both employees (EMPLOYEE).  Each teacher of an offering is identified uniquely by his/her employee number (EMPNO), and not his/her name (NAME).  A teacher can teach more than one class offering.  Each student enrolled in an offering is identified uniquely by his/her employee number (EMPNO), and not his/her name (NAME).  A student's enrollment record also shows the grade (GRADE) that student obtained for that offering.