Concepts of Database Management
Concepts of Database Management
8th Edition
ISBN: 9781285427102
Author: Philip J. Pratt, Mary Z. Last
Publisher: Cengage Learning
Question
Book Icon
Chapter 6, Problem 13RQ

(a)

To determine

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

(a)

Expert Solution
Check Mark

Explanation of Solution

The given relation is Student(StudentNum_,CourseNum_,FacultyNum_) .

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:

Faculty(FacultyNum_,Name,Department)Course(CourseNum_,CourseName)StudentFaculty(StudentNum_,StudentName)Student(StudentNum_,CourseNum_,FacultyNum_)

(b)

To determine

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

(b)

Expert Solution
Check Mark

Explanation of Solution

The given relation is as follows:

Student(StudentNum_,CourseNum_)Faculty(CourseNum_,FacultyNum_)

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:

Faculty(FacultyNum_,CourseNum_)Course(CourseNum_,CourseName)StudentFaculty(StudentNum_,StudentName)Student(StudentNum_,CourseNum_)

(c)

To determine

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

(c)

Expert Solution
Check Mark

Explanation of Solution

The given relation is as follows:

Student(StudentNum_,CourseNum_)Faculty(CourseNum_,FacultyNum_)StudenFaculty(StudentNum_,CourseNum,_FacultyNum_) .

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.

(d)

Expert Solution
Check Mark

Explanation of Solution

The given relation is Student(StudentNum_,CourseNum_,FacultyNum_) .

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:

Faculty(FacultyNum_,Name,Department)Course(CourseNum_,CourseName)StudentFaculty(StudentNum_,StudentName)Student(StudentNum_,CourseNum_,FacultyNum_)

(e)

To determine

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

(e)

Expert Solution
Check Mark

Explanation of Solution

The given relation is as follows:

Student(StudentNum_,CourseNum_)Faculty(CourseNum_,FacultyNum_)StudenFaculty(StudentNum_,FacultyNum_) .

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.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON
Text book image
Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science
Text book image
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning
Text book image
Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning
Text book image
Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education
Text book image
Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY