Use ACCESS to write the appropriate

SQL query (with QBE assistance) to answer questions 10, 12, 14, 15,

16 for TAL and questions 10, 11, 14 (Bonus), 15, 16, 17 for CAT.

 

Exercise #3.ADue: Sec. 1 & 2: Sep 20 (Tu) & Sep 22 (Th); Start of Class:10 pointsPratt & Last; Chapter 3; EOCQs: pp. 112-113.Assignments must use the SCORE SHEET as the table of contents.PLEASE STAPLE BEFORE CLASS!Chapter 3 [pp 112-113 (8thed)]:Use ACCESS to write the appropriateSQL query (with QBE assistance) to answer questions 10, 12, 14, 15,16 for TAL and questions 10, 11, 14 (Bonus), 15, 16, 17 for CAT.NOTE:USE the TAL & CAT CASES from last assignment or fromChapter 1[the original version, ONLY if necessary].Turn-in printouts of the datasheet, or report and the related query (asappropriate),which shows the answer:1) datasheet view; 2) QBEdesign view , and 3) SQL View.Screen prints may be used, if necessary (ONE PAGE PER PROBLEMPREFERRED).Label each page with problem name (e.g., TAL 3-04).

Attachments:

• 1495178600-Assignment_03.A_Website.pdf
• 1495178601-TAL.png
• 1495178601-TAL and CAT.png