39 Refer to the following ER diagram to answer the question below: PK Student SSN Name Year GPA How are keys used in these relations? PK PK Registration CampusID SSN Enrollment Date Graduation Date 4 PK O The CampusID attribute in the Registration relation is a candidate key. O The SSN and CampusID attributes in the School and Student relations areforeign keys. O The CampusID and SSN attributes in the Registration relation are foreign keys. O The SSN attribute in the Registration relation is a candidate key. School CampusID Name Address

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
39
Refer to the following ER diagram to answer the question below:
PK
Student
SSN
Name
Year
GPA
How are keys used in these relations?
PK
PK
Registration
CampusID
SSN
EnrollmentDate
Graduation Date
PK
O The CampusID attribute in the Registration relation is a candidate key.
O The SSN and CampusID attributes in the School and Student relations areforeign keys.
The CampusID and SSN attributes in the Registration relation are foreign keys.
O The SSN attribute in the Registration relation is a candidate key.
School
CampusID
Name
Address
X
PERHI
Transcribed Image Text:39 Refer to the following ER diagram to answer the question below: PK Student SSN Name Year GPA How are keys used in these relations? PK PK Registration CampusID SSN EnrollmentDate Graduation Date PK O The CampusID attribute in the Registration relation is a candidate key. O The SSN and CampusID attributes in the School and Student relations areforeign keys. The CampusID and SSN attributes in the Registration relation are foreign keys. O The SSN attribute in the Registration relation is a candidate key. School CampusID Name Address X PERHI
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Normalization
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
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education