Case Based Critical Thinking Questions Case 10-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Kyra asks how to select all movies that received an award between 1940 and 1955. Maxwell tells her that the query criteria for the Award Year field should be: _____. A) = 1940 AND = 1940 OR

Question

Case Based Critical Thinking Questions Case 10-1 Maxwell has developed a Movies database. He presented his design to his class, and some of his listeners had questions. Here is one of the tables Maxwell showed to the audience. Kyra asks how to select all movies that received an award between 1940 and 1955. Maxwell tells her that the query criteria for the Award Year field should be: _____. A) >= 1940 AND <= 1955 B) >= 1940 OR <= 1955 C) = 1940 AND = 1955 D) HIGHER THAN 1940 AND LOWER THAN 1955

Quizplus · Accepted Answer

The query criteria for the Award Year field should include movies with award year greater than or equal to 1940 and less than or equal to 1955. Therefore, the correct syntax is >= 1940 AND <= 1955.

Case Based Critical Thinking Questions Case 10-1 Maxwell Has Developed