c) Provide an example of a ternary relationship that loses semantics if represented as three binary relationships. (Use Figures 3.18 and 3.19 below as an example). Do not use the same ER model as in the textbook. SUPPLY Supplier Product Project Pencil Pen Peters Project 1 Peters Project 2 Figure 3.18 Ternary versus binary relationship types: example instances. Johnson Pen Project 1 SUPPLIES USES CAN SUPPLY Product Project Project 1 Project 1 Project 2 Supplier Peters Supplier Project Product Project 1 Pencil Penci Pen Peters Peters Project 2 Pen Peters Johnson Project 1 Pen Johnson Pen OFFERS INSTRUCTOR 1N ON SEMESTER 0.N Figure 3.19 Ternary relationship type in the ER model. INR O.N SEM YEAR O.N COURSE QUALIFIED CNB

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
c) Provide an example of a ternary relationship that loses semantics if represented as
three binary relationships. (Use Figures 3.18 and 3.19 below as an example). Do not
use the same ER model as in the textbook.
SUPPLY
Supplier
Product Project
Pencil
Pen
Project 1
Project 2
Project 1
Peters
Peters
Figure 3.18 Ternary versus
binary relationship types:
example instances.
Johnson
Pen
SUPPLIES
USES
CAN SUPPLY
Product Project
Supplier Project
Project 1
Project 2
Supplier Product
Peters
Pencil
Peters
Pen
Johnson
Peters
Pencil
Project 1
Peters
Johnson
Pen
Project 1
Project 1
Pen
Project 2
Pen
OFFERS
INSTRUCTOR LN
ON
SEMESTER
0.N
Figure 3.19 Ternary relationship
type in the ER model.
INR
O.N
SEM YEAR
O.N
COURSE
QUALIFIED
CNR
Transcribed Image Text:c) Provide an example of a ternary relationship that loses semantics if represented as three binary relationships. (Use Figures 3.18 and 3.19 below as an example). Do not use the same ER model as in the textbook. SUPPLY Supplier Product Project Pencil Pen Project 1 Project 2 Project 1 Peters Peters Figure 3.18 Ternary versus binary relationship types: example instances. Johnson Pen SUPPLIES USES CAN SUPPLY Product Project Supplier Project Project 1 Project 2 Supplier Product Peters Pencil Peters Pen Johnson Peters Pencil Project 1 Peters Johnson Pen Project 1 Project 1 Pen Project 2 Pen OFFERS INSTRUCTOR LN ON SEMESTER 0.N Figure 3.19 Ternary relationship type in the ER model. INR O.N SEM YEAR O.N COURSE QUALIFIED CNR
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY