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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!