A database includes the following tables and design for a query, Query3, illustrated in both Microsoft Access QBE and SQL formats. (a) What is the result of the Query3 design applied to the tables?
(b) If the goal is to identify the notebook computer makers of the computers that have not required any maintenance (including the NCID and the Maker name), does Query3 provide the needed information?
(c) If the answer to (b) is no, what errors need to be corrected in Query3?
(d) Once the query is corrected, what should the result look like?

Question

A database includes the following tables and design for a query, Query3, illustrated in both Microsoft Access QBE and SQL formats.   (a) What is the result of the Query3 design applied to the tables? 
(b) If the goal is to identify the notebook computer makers of the computers that have not required any maintenance (including the NCID and the Maker name), does Query3 provide the needed information? 
(c) If the answer to (b) is no, what errors need to be corrected in Query3? 
(d) Once the query is corrected, what should the result look like?

Quizplus · Accepted Answer

The Answer of A database includes the following tables and design for a query, Query3, illustrated in both Microsoft Access QBE and SQL formats.   (a) What is the result of the Query3 design applied to the tables? 
(b) If the goal is to identify the notebook computer makers of the computers that have not required any maintenance (including the NCID and the Maker name), does Query3 provide the needed information? 
(c) If the answer to (b) is no, what errors need to be corrected in Query3? 
(d) Once the query is corrected, what should the result look like?

A Database Includes the Following Tables and Design for a Query