Consider a student file that contains the following data: Would this set of data
ID: 662996 • Letter: C
Question
Consider a student file that contains the following data:
Would this set of data be suitable and sufficient to use to test each of the following programs? Explain why or why not. a. a program that displays a list of Psychology majors b. a program that displays a list of Art majors c. a program that displays a list of students on academic probation-those with a grade point average under 2.0 d. a program that displays a list of students on the deals list e. a program that displays a list of students from Wisconsin f. a program that displays a list of female studentsExplanation / Answer
With the following data given in the question above, the following data can/or cannot be collected :-
a. The list of Psychology majors can be collected by the following SQL query :-
Select LastName, FirstName from studentfile, where major = "Psychology"
b. The list of Art majors can be similarly retrieved just by changing "Psychology" to "Art". Select LastName, FirstName from studentfile, where major = "Art"
The result wouldn't display any data as there are no fields in the database.
c. To display the list of students on academic probation with a grade point average under 2.0 can be retrieved with the following query
Select LastName, FirstName from studentfile, where "GradePointAverage< 2.0"
d. The list of students on the dean's list can't be retrieved as it is not available in the database.
e. For the similar reason above the list of students from Wisconsin can't be retieved as it isn't mentioned in the list above from where a particular student belongs to.
f. Gender of non of the student is mentioned in the database so the list of female students can't be retrieved.