2 pointsConsider the following relational schema on students of a school. studentInfostudentInfo{enrollment_num, class, section, roll, name}.{enrollment_num} and {class, section, roll}{class, section, roll} are two possible candidate keys.What is the maximum number of possible superkeys of studentInfo?studentInfo?1616181820202222

In a Students table with columns StudentID, FirstName, LastName, and Email, which combination of columns can be considered a super key?

Consider the following relation schema pertaining to a training database:Trainee (traineeno, name, address)Enroll (traineeno, courseno, coursename)where the primary keys are shown underlined. The number of tuples in the Trainee and Enroll tables are 60 and 10 respectively. What are the maximum and minimum number of tuples that can be present in (Student * Enroll), where ‘*’ denotes inner join ?

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name. Query: Display all the student name, course name and also age of the students, whose age is between 23 to 27 and course having 'BCA'. Find out the students whose age is maximum.

Question 8In the following student table, which attribute could be used as a primary key?Student first nameStudent last nameMobile numberCarl Merlo07445532123MarkNero074565323271 pointStudent last nameMobile numberStudent first name

Identify the foreign key for STUDENT relation.STUDENT (stuID, stuLName, stuAddress)ENROLLMENT (enrID, subName, className, stuID)Choose one answer. a. enrID b. subName c. stuID d. className