Entity Relationships

Added by Marc Brierley, last edited by Marc Brierley on Mar 14, 2006  (view change)

Entity Relationships

Let this be a new space for general and case-specific course management entity relationship diagrams and usage scenarios to be described. As much as possible, all customers (instructor, application support, system integrator) points of view should be integrated for one wholistic view.

General

Stanford University

University of Arizona

Generalized Chem 103

University of California - Berkeley

Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.

Comments (1)

 

  1. Mar 14, 2006

    Ray Davis says:

    A lot is packed into those U. of Arizona diagrams, so forgive me if I got lost. ...

    A lot is packed into those U. of Arizona diagrams, so forgive me if I got lost. Some follow-up questions:

    1) What does "x-term" mean in the oval "Term/non-term/x-term"?

    2) There's a lot of duplicate data hanging off the "Course" and the "Section". My guess, mostly confirmed by the "Chem 103" example, is that things like "Date & time" and "Instructor" would tend to be on the Course for small courses (without specific enrollment sections) and on the Section for big courses (with multiple Lecture sections, for example). Is that right?

    3) In the "Chem 103" example, though, "Term" data shows up on both the "Chem 101" and the "Lab" objects. Can they really have different terms?

    4) "Chem 101 has multiple labs and lectures. Students enroll in a lecture and lab which auto enrolls them in a course." "Lecture AND lab" or "lecture AND/OR lab"? (I'm trying to figure out if this is the UC Davis case or the UC Berkeley case.)

    5) The diagrams show one diamond labelled "enrolled in" for both sections and courses. At many schools, section membership can be distinguished from the relationship that carries official enrollment data. (Official enrollment data = What grading scheme the student has chosen; How many points the student will receive for the final grade; Who has the right to submit the final grade for the student....) What is this enrollment data associated with for U. Arizona? To put it a different way, when the student gets their grade transcript, do they see one grade for the course, or multiple grades for the course and one grade per section?