Exercises

1. Exercises 1. In a course registration system, for the event student registers for classes, create an event table entry listing the event, trigger, source, activity, response(s), and destination(s). For the event time to produce grade reports, create another event table entry. 2. Consider the entity-relationship diagram shown in the figure on nest page, the refined ERD showing course enrollment with an associative entity. Does this model allow a student to enroll in more than one course section at a time? Does the model allow a course section to contain more than one student? Does the model allow a student to enroll in several sections of the same course and get a grade for each enrollment? Does the model store information about all grades earned by all students in all sections?

2. 3. Again consider the entity-relationship diagram shown in the figure up . Add the following to the diagram and list any assumptions you had to make. A faculty member usually teaches many course sections, but some semesters they don't teach any. Each course section must have at least one faculty number teaching it, but sometimes course sections are taught by teams. Further, to make sure all course sections are similar, one faculty member is assigned as course coordinator to oversee the course, and each faculty member can be coordinator of many courses.

3. 4. If the entity relationship diagram you drew in exercise 3 above showed a many-to-many relationship between faculty and course section, a further look at the relationship might reveal some additional information might need to be stored. What might this information include? (Hint: does the instructor have specific office hours for each course section? Do you give an instructor some sort of evaluation for each course section?) Expand the ERD to allow this additional information to be stored. 5. Draw a class diagram for the course enrollment system completed in question number 4 above (Use association class notation)

4. Yes to all.