what is best way to represent below one to one relationship in the relational model? A)combine student and preference relation and select the combination of studentno and prefno as the primary key of new relation B)include studentno as a forein key in the preference relation C)combine student and preference relation and select studentno as the primary key of new relation D)include prefno as a foreign key in the student relation

EBK JAVA PROGRAMMING
9th Edition
ISBN:9781337671385
Author:FARRELL
Publisher:FARRELL
Chapter10: Introduction To Inheritance
Section: Chapter Questions
Problem 3PE
icon
Related questions
Question

what is best way to represent below one to one relationship in the relational model?

A)combine student and preference relation and select the combination of studentno and prefno as the primary key of new relation

B)include studentno as a forein key in the preference relation

C)combine student and preference relation and select studentno as the primary key of new relation

D)include prefno as a foreign key in the student relation

 

Student
Preference
studentNo {PK}
prefNo {PK}
1 .. 1
1.. 1
name
housing Type
email
maxRent
notes
Transcribed Image Text:Student Preference studentNo {PK} prefNo {PK} 1 .. 1 1.. 1 name housing Type email maxRent notes
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Arrays
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK JAVA PROGRAMMING
EBK JAVA PROGRAMMING
Computer Science
ISBN:
9781337671385
Author:
FARRELL
Publisher:
CENGAGE LEARNING - CONSIGNMENT