8. Identify the superkeys, candidate key(s), and the primary key for the following relation instance of the STU CLASS relation schema. Student Number Student Name Student Major Class Name Class Time 0110 KHUMAWALA ACCOUNTING BA482 MW3 0110 KHUMAWALA ACCOUNTING BD445 TR2 0110 KHUMAWALA ACCOUNTING BA491 TR3 1000 STEDRY ANTHROPOLOGY AP150 MWF9 1000 STEDRY ANTHROPOLOGY BD445 TR2 2000 KHUMAWALA STATISTICS BA491 TR3 2000 KHUMAWALA STATISTICS BD445 TR2 3000 GAMBLE ACCOUNTING BA482 MW3 3000 GAMBLE ACCOUNTING BP490 MW4 Student Number Student Name Student Major Class Name Class Time 0110 KHUMAWALA ACCOUNTING BA482 MW3 0110 KHUMAWALA ACCOUNTING BD445 TR2 0110 KHUMAWALA ACCOUNTING BA491 TR3 1000 STEDRY ANTHROPOLOGY AP150 MWF9 1000 STEDRY ANTHROPOLOGY BD445 TR2 2000 KHUMAWALA STATISTICS BA491 TR3 2000 KHUMAWALA STATISTICS BD445 TR2 3000 GAMBLE ACCOUNTING BA482 MW3 3000 GAMBLE ACCOUNTING BP490 MW4 Solution 1. Super Key: If you add any other column/attribute to a Primary Key then it become a super key,H ere we observe STU-CLASS relation Student Number is Primary Key .{Student Number,Sudent Name} and {Student Number , Student Major} are Super Keys. Super Keys for STU-CLASS relation as Follows {Student Number , Sudent Name} {Student Number,Student Major} 2. Candidate Key: are individual columns in a table that qualifies for uniqueness of all the rows. Here in STU CLASS table Student Number , Student Name & Student Major are Candidate keys. Candidate Keys for STU-CLASS relation as Foll ...
Purchase document to see full attachment