exercises n.
Skip this Video
Loading SlideShow in 5 Seconds..
Exercises PowerPoint Presentation
Download Presentation

Loading in 2 Seconds...

play fullscreen
1 / 7

Exercises - PowerPoint PPT Presentation

Download Presentation
An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  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.