Consider the instance of the Students relation shown in Figure 3.1.
FIELDS (ATTRIBUTES, COLUMNS)

An Instance S1 of the Students Relation
1. Give an example of an attribute (or set of attributes) that you can deduce is not a candidate key, based on this instance being legal.
2. Is there any example of an attribute (or set of attributes) that you can deduce is a candidate key, based on this instance being legal?

Transcribed Image Text:

Field namessid name age gpa 19 3.3 18 3.4 18 3.2 19 3.8 53831Madayan madayan@music11 1.8 12 2.0 login 50000 Dave Jones j davecs 53666 Jones jones@cs 53688 Smith smith@ee 53650 Samath TUPLES RECORDS, ROws) Smith smith 53832 Guldu guldu@musio