oracle

#30 -- We have the table TAB1(studentID, course, title, grade). The Primary key is studentID and course. Is this table in second Normal form? If yes, state that is in second normal form. If no, how would you convert it to table or tables, so it would be in second normal form.

#31 -- Assume we have a table named TAB(Sid, firstName, homephone, majorCode, major). Is this table in third normal form? If yes, state that is in third normal form. If no, how would you convert it to table or tables, so it would be in third normal form.