1 votes 1 votes Databases database-normalization candidate-key + – garam_masala_ asked Nov 21, 2017 • retagged Jul 8, 2019 by Cristine garam_masala_ 459 views answer comment Share Follow See 1 comment See all 1 1 comment reply Himanshu Kumar Gupta commented Sep 10, 2020 reply Follow Share only three CK are possible 0 votes 0 votes Please log in or register to add a comment.
2 votes 2 votes 3 CK possible. 1. S.no 2. Marks 3. {Name,Age} Ashwin Kulkarni answered Nov 21, 2017 Ashwin Kulkarni comment Share Follow See all 3 Comments See all 3 3 Comments reply nikkey123 commented Nov 22, 2017 reply Follow Share why not {SNO,Age} is candidate key ? 0 votes 0 votes Ashwin Kulkarni commented Nov 22, 2017 reply Follow Share Already SNO is a Candidate key, so anything more with SNO will be turn out as SuperKey. 0 votes 0 votes nikkey123 commented Nov 22, 2017 reply Follow Share okay 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes 3 keys are possible for given instance.... S.no is 1 st candidate key as uniquely identify each row... Marks is 2 nd candidate key as uniquely identify each row... {NAME,AGE} is 3rd candidate key as uniquely identify each row... SHUBHAM SHASTRI answered Nov 21, 2017 SHUBHAM SHASTRI comment Share Follow See all 0 reply Please log in or register to add a comment.