Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2013

    Unanswered: can anyone help with this question

    . Suppose there is a table college with student_id/class_id combined key.
    student-id student-name class-id class-name book grade instructor-id instructor-name

    with the following FDs:
    student-id → student-name
    student-id, class-id → grade
    class-id → book
    class-id → class-name
    class-id → instructor-id
    instructor-id → instructor-name

    Convert the table below to a set of 3NF tables. You do not have to draw anything fancy. Just write down the tables and attributes. Do not forget foreign keys.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Ok, done!

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts