Chapter 6, Problem 10RQ

(a)

To determine

To find the relationship between students, courses and faculty members in the specified relation.

Explanation of Solution

The given relation is $\text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)$ .

The above relation Student and Faculty has many-to-many relationship since a new table is generated whose primary key is the combination of all primary key.

Since a faculty teaches many students and a student is taught by many faculties. Therefore, the relation between student and faculty is many-to-many relationship.

The relation between Student and Course has many to many relationships since a student can take many courses and a course can be taken by many students.

After creating new table, the collection of tables is as follows:

$\begin{array}{l}\text{Faculty}\left(\underset{\_}{\text{FacultyNum}}\text{,Name,Department}\right)\\ \text{Course}\left(\underset{\_}{\text{CourseNum}}\text{,CourseName}\right)\\ \text{StudentFaculty}\left(\underset{\_}{\text{StudentNum}}\text{,StudentName}\right)\\ \text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)\end{array}$

(b)

To determine

To find the relationship between students, courses and faculty members in the specified relation.

Explanation of Solution

The given relation is as follows:

$\begin{array}{l}\text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\right)\\ \text{Faculty}\left(\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)\end{array}$

Since one student can take many courses and one course is taken by many students.

Therefore, the attributes StudentNum and CourseNum in the Student relation used as the primary key shows the many-to-many relationship between StudentFaculty and Course tables.

The relation Faculty and Course has many-to-many relationship since one faculty can be assigned many course numbers and one course number can be assigned to many faculties.

After creating new table, the collection of tables is as follows:

$\begin{array}{l}\text{Faculty}\left(\underset{\_}{\text{FacultyNum}}\text{,}\underset{\_}{\text{CourseNum}}\right)\\ \text{Course}\left(\underset{\_}{\text{CourseNum}}\text{,CourseName}\right)\\ \text{StudentFaculty}\left(\underset{\_}{\text{StudentNum}}\text{,StudentName}\right)\\ \text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\right)\end{array}$

(c)

To determine

To find the relationship between students, courses and faculty members in the specified relation.

Explanation of Solution

The given relation is as follows:

$\begin{array}{l}\text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\right)\\ \text{Faculty}\left(\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)\\ \text{StudenFaculty}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum,}}\underset{\_}{\text{FacultyNum}}\right)\end{array}$ .

The relation StudentFaculty and Faculty has many-to-many relationship since many students have assigned many courses.

The relation Faculty and Course has many-to-many relationship as many faculties can be assigned many courses.

The relation StudentFaculty and Course has many-to-many relationship since one faculty can be assigned many course numbers and one course number can be assigned to many faculties.

Also, the relation StudentFaculty and Faculty has many to many relationships since one student is taught by many faculties and one faculty can be assigned to many students.

(d)

To determine

To find the relationship between students, courses and faculty members in the specified relation.

Explanation of Solution

The given relation is $\text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)$ .

The above relation Student and Faculty has many-to-many relationship since a new table is generated whose primary key is the combination of all primary key.

Since a faculty teaches many students and a student is taught by many faculties. Therefore, the relation between student and faculty is many-to-many relationship.

The relation between Student and Course has many tomany relationships since a student can take many courses and a course can be taken by many students.

After creating new table the collection of tables are as follows:

$\begin{array}{l}\text{Faculty}\left(\underset{\_}{\text{FacultyNum}}\text{,Name,Department}\right)\\ \text{Course}\left(\underset{\_}{\text{CourseNum}}\text{,CourseName}\right)\\ \text{StudentFaculty}\left(\underset{\_}{\text{StudentNum}}\text{,StudentName}\right)\\ \text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)\end{array}$

(e)

To determine

To find the relationship between students, courses and faculty members in the specified relation.

Explanation of Solution

The given relation is as follows:

$\begin{array}{l}\text{Student}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{CourseNum}}\right)\\ \text{Faculty}\left(\underset{\_}{\text{CourseNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)\\ \text{StudenFaculty}\left(\underset{\_}{\text{StudentNum}}\text{,}\underset{\_}{\text{FacultyNum}}\right)\end{array}$ .

The relation Student and Course has many-to-many relationship since many students have assigned many courses.

The relation Faculty and Course has many-to-many relationship since many faculties can be assigned to many subjects.

The relation Student and Faculty has many-to-many relationship since one faculty can be assigned many students and one student can be assigned to many faculties.