Explore BrainMass

Explore BrainMass

    Dependency / Multivalued dependency

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Hi

    Please help me with this question. Define dependency and/or multivalued dependencies and explain them.

    Question:
    ---------------------------------------------------------

    Define any functional dependecny and/or multivalued dependecny in the following table. Do not invent any new fields. The superkey of this table consists of COURSE, STUDENT, INSTRUCTOR, SEMESTER.

    COURSE STUDENT INSTRUCTOR SEMESTER GRADE
    --------------------------------------------------------------------------
    XML Alan Fred Fall2004 B
    Database Jane Fred Fall2004 A
    Database Alan Fred Fall2004 A
    XML Jane Fred Spring2005 A-
    XML Sam Mary Spring2005 B+

    Assumptions:

    1. A course, e.g XML, may be offered during many semesters. Each offering of a course is called a class.
    2. A student may be enrolled in many classes during any particular semester and obviously receives just one grade for each class in which the student may be enrolled.
    3. Each class may be taught by more than one instructor in any one semester

    --------------------------------------------------------------

    © BrainMass Inc. brainmass.com October 4, 2022, 3:54 pm ad1c9bdddf
    https://brainmass.com/computer-science/searching/dependency-multivalued-dependency-51317

    Solution Preview

    Please, find the attached word document. Solution includes
    ------ ...

    $2.49

    ADVERTISEMENT