Homework Help is Here – Start Your Trial Now!
Engineering
Data Structures and Algorithms
Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a particular plan to use sode. AND a particular category. 2. Do a query to show all of the fields for a particular building OR a particular category. 3. Do a query to show the id number, the name of the resource, the category, the building, and the plan to use code for records where there is a particular building AND a particular plan to use code OR where there is an id number greater than a certain number AND a particular category. 4. Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan to use code. 5. Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan to use code. 6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3. You decide what criteria to use. 7. Do a query to show all of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.

Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a particular plan to use sode. AND a particular category. 2. Do a query to show all of the fields for a particular building OR a particular category. 3. Do a query to show the id number, the name of the resource, the category, the building, and the plan to use code for records where there is a particular building AND a particular plan to use code OR where there is an id number greater than a certain number AND a particular category. 4. Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan to use code. 5. Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan to use code. 6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3. You decide what criteria to use. 7. Do a query to show all of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.

icon
Related questions
Question

Program assignment

Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a particular plan to use code AND a particular category. 2. Do a query to show all of the fields for a particular building OR a particular category. 3. Do a query to show the id number, the name of the resource, the category, the building, and the plan to use code for records where there is a particular building AND a particular plan to use code OR where there is an id number greater than a certain number AND a particular category. 4. Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan to use code. 5. Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan to use code. 6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3. You decide what criteria to use. 7. Do a query to show all of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.
Transcribed Image Text:Queries: 1. Do a query to show name of the resource, building, category and plan to use code for a particular plan to use code AND a particular category. 2. Do a query to show all of the fields for a particular building OR a particular category. 3. Do a query to show the id number, the name of the resource, the category, the building, and the plan to use code for records where there is a particular building AND a particular plan to use code OR where there is an id number greater than a certain number AND a particular category. 4. Do a query to show all of the fields for a particular building AND a particular category OR for just a particular plan to use code. 5. Do a query to show all of the fields for a particular building AND either a particular category OR a particular plan to use code. 6. Do a query to show all of the fields for records that meet criteria 1 OR criteria 2 OR criteria 3. You decide what criteria to use. 7. Do a query to show all of the fields for records where the id number is less than a certain amount (you pick the amount) AND either it is in a particular building OR has a particular plan to use code.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer