Access over 20 million homework & study documents

8 Identify the superkeys, candidate key(s), and the primary key for

Content type
User Generated
Rating
Showing Page:
1/5
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

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/5
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

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/5

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 5 pages?
Access Now
Unformatted Attachment Preview
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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4