Previous Page
Next Page

A.1.

A.1.1. Brief English Description of the ER Diagram

  1. Student may be registered in one or more (M) Grade_Reports (Grade_report is for a specific course).

    A Grade_Report must relate to one and only one (1) Student.

    (Students may be in the database and not registered for any courses, but if a course is recorded in the Grade_report table, it must be related to one and only one student).

  2. A Section must have one or more (M) Grade_Reports (Sections only exist if they have students in them).

    A Grade_Report must relate to one and only one (1) Section.

  3. A Section must relate to one and only one (1) Course.

    A Course may be offered as one or more (M) Sections.

    (Courses may exist where they are not offered in a section, but a section, if offered, must relate to one and only one course).

  4. A Student may be related to one and only one (1) Department_to_major (A student may or may not have declared a major).

    A Department_to_major may have one or more (M) Students (A department may or may not have student-majors).

  5. A Course must be related to one and only one (1) Department_to_major.

    A Department_to_major may offer one or more (M) Courses.

  6. A Section must be offered in one and only one (1) Room.

    A Room may host one or more (M) Sections.

  7. A Course may have one or more (M) Prereq (A course may have one or more prerequisites).

    A Prereq may be a prerequisite for one or more (M) Courses.

  8. A Student may have one or more (M) Dependents.

    A Dependent must be related to one or more (N) Students.

Table A-2. Table definition of other tables that have been used in this book

PLANTS
    COMPANY                  NVARCHAR(20)
    PLANTLO                  NVARCHAR(15)
    PRIMARY KEY(COMPANY, PLANTLO)
 
CAP
    NAME                     NVARCHAR(9)
    LANGU                    NVARCHAR(7)
    PRIMARY KEY(NAME, LANGU)



Previous Page
Next Page