Question: Question 2 (a)The foundational concepts underlying the relational database model are from the field of mathematical relations. Use the example of three sets S1, S2

Question 2 (a)The foundational concepts underlying the relational database model are from the field of mathematical relations. Use the example of three sets S1, S2 and S3 to illustrate the concept of a mathematical relation (Use elements of your choice to populate each set). (b)Consider the table below. Car 1 4.0 2 3 4.0 Student R- Student Name Student GPA Number Registration Number Abc1234 Snoop Jimmy Def3456 Tupac Tom 3.9 Ghi1111 Eminem Adam Interpret the table in the context of Texas Tech, which means Student R- Numbers are unique. Further, assume the car registration number is unique to each user in the population under consideration. (i) Identify 3 super keys in this relation. (ii) Explain why the keys you have selected qualify to be super keys (iii) Identify 2 candidate keys in this relation. (iv) Explain why the keys you have selected qualify to be candidate keys (v) Distinguish between a primary key and a candidate key 2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
