1. Consider the relation schemas: faculty = (SSN, last-name, first-name, street,
ID: 3723974 • Letter: 1
Question
1. Consider the relation schemas: faculty = (SSN, last-name, first-name, street, city, state) student (SSN, last-name, first-name, street, city, state) and the following instance: SSNlast-nam e first-name street state 388-67-9009Bai 980-67-8765 Jackson 980-67-8765 Robert 435-67-2342 Charles Shuju Perkins Ma Tina Courtney Washington Baton Rouge LA Baton Rouge LA Baton Rouge LA Baton Rouge LA Iowa State Is this instance a legal instance of relation faculty? Why? a. b. Is this instance a legal instance of relation student? Why?Explanation / Answer
primary key is a field in instance which can uniquely identifies each row in a table.
a) This instance is a legal instance to relation faculty .
In faculty relation, primary key is last name and in the given instance, each last name is different from others and are unique. So it is a legal instance.
b)This instance is not a legal instance to student relation.
In this student relation, primary key is ssn and in the given instance two tuples are having the same instance i.e 980-67-8765. So it violates the primary key definition and hence this instance is not a valid instance.
please feel free to post in comments box if you have any queries please.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.