Question

A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?

ID#
FirstName LastName StudentMajor Address
1
Beth Borsky Art 55 Winsap Ln.
2
Hank Hoff Chemistry 7 Gosling Rd.
3
Stephanie Serle Political Science 136 Finley Ave.
4
Rafi Rohr Art 55 W. 79th St.
a list of students over the age of 35
a list of students grouped by major
a list of students who got over a 90% on the entrance exam
a list of all male students

Answer 1

An instructor will find a list of students grouped by major

Step-by-step explanation:

A list of students over the age of 35 can't be found because there is no column containing the information of students age, A list of students who got over a 90% on the entrance exam can't be found as well because there is no column containing that information, A list of all male male students cant be found as well because there is no column containing the exact Gender of each student

meanwhile:

A list of students grouped by Major can be found from the student info Table of Harris Community College because there is a column that specifies the Major that each student enrolled for

Answer 2

The correct answer is a list of students grouped by major.Querying this table will give a list of all students grouped by major as the table contains a list of a students and a field that lists their major. The table does not have gender, age or the grade that they scored.