0 votes 0 votes mukul maurya asked Sep 1, 2018 mukul maurya 866 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply MiNiPanda commented Sep 2, 2018 reply Follow Share The table name is student and all of the options are creating the table "employee". Also none of the options have the last field name as "courseid" instead they have "age". The question is not matching with the options! :/ 0 votes 0 votes Shaik Masthan commented Sep 2, 2018 reply Follow Share the question is more focus on which can be primary key. ( i hope courseid is mistakenly print... it should be age) By observing the tuples we can say that, first name could be use as key ===> option C is matching 0 votes 0 votes MiNiPanda commented Sep 2, 2018 reply Follow Share Shaik Masthan Then why not B? If you say option C then there is no NOT NULL constraint on firstname. So firstname can be NULL but composite Primary key i.e. (firstname,lastname) can't have NULL value in any of the attributes. 0 votes 0 votes Shaik Masthan commented Sep 2, 2018 reply Follow Share @MiNiPanda yes, it's my mistake ( i assumed they given NOT NULL constraint ) yes it's option B only. 0 votes 0 votes Please log in or register to add a comment.