For each of the following collections of relations, give the assumptions concerning the relationship between students, courses,

Question:

For each of the following collections of relations, give the assumptions concerning the relationship between students, courses, and faculty members that are implied by the collection. In each relation, only the primary keys are shown.
a. Student (StudentNum, CourseNum, FacultyNum)
b. Student (StudentNum, CourseNum)
Faculty (CourseNum, FacultyNum)
c. Student (StudentNum, CourseNum)
Faculty (CourseNum, FacultyNum)
StudentFaculty (StudentNum, FacultyNum)
d. Student (StudentNum, CourseNum, FacultyNum)
e. Student (StudentNum, CourseNum)
Faculty (CourseNum, FacultyNum)
StudentFaculty (StudentNum, FacultyNum)
Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts of Database Management

ISBN: 978-111182591

7th edition

Authors: Philip J. Pratt, Joseph J. Adamski

Question Posted: